Report: Aged Payables [Detail] - Job Number

Hi Dan

Thanks for your comment.

We would use this report to capture the expenses spent on a job. This would assist us with our own progress claims plus the Job budget.

I find the Purchases Supplier report helpful and yes if there was a job filter on this report that would be great to avoid having to export to excel and deleting admin plus other job purchases. Can this please be added?

Thanks for your help, look forward to your response :)

Thanks

ACorp

Ps - the specific report I'm refering to is the Supplier - Purchases detail (not summary).

Thanks!

I have only just joined the community, and found this post while looking for information

I also would really like to see the option of aged payables filtered to job level as my employer is constantly asking for everything at job level.  We are in the construction industry, therefore we need to report on most jobs as if they were mini companies (P&L, Aged payables, aged receivables etc).  For projecting cashflows over the coming weeks, aged payables at job level would be invaluable.

For our purposes, I thought another option to gather this information could be having custom lists or fields within the enter purchase screen, as the majority of our purchases are for one job, although from what I can see, custom lists only seem to relate to card level and we have many suppliers who supply for multiple jobs.

Job specific aged payables/receivable reports would be useful.  I have voted for it.

Hi ACorp,

Accounting Addons have developed an Aged Payables Report that can be filtered by Job.

It is free to download and use.

The report is an Excel Pivot table that replicates the Aged Payables Report in MYOB with a Job filter at the top. Upon setting the job filter only the line items allocated to that job will display in the report.

Its also possible to display jobs down the page

It can be customised futher by dragging other Filters into the report if required

The solution can be linked to multiple MYOB data files

You can download it from here:

http://accountingaddons.com.au/excelreportlink-aged-payables-pivot-solution/

Please contact me if you have any questions

Regards

Jeff Stephenson

Managing Director at Accounting Addons

Visit us at http://accountingaddons.com.au
Email me at jeff@accountingaddons.com.au
Phone us on 1300 ADDONS (1300 233667)

I urge you to please implement a solution for the Payables reports to have filtering by Job Number.

We are currently have 10 projects running and would like to know what is owing for each specific project at any given time.

Please advise when this will be implemented.

Hi

Does anyone know how I can generate a report displaying the aged payables per job at a point in time?

This would be of huge value to us, I think most construction companies would find this of value!

There should be a option to get a report on the aged creditors, what they have been paid and what they owe for each job number. 

This will help us find our position on the job, help with cash flow managment and progress claims.