Report: Aged Payables [Detail] - Job Number

[ACorp]

Good afternoon,

Leeya suggested that I post my idea for a new Aged Payables report that also has a Job No Field. This report would allow you to specify a job # so all purchases relating to a particular job are listed. That way say for example if 1 invoice is split into 3 jobs & then if you only specify one job on the report, only the section allocated to that one job on the invoice is shown in the report. Another benefit of this report is also the convenience of not needing to export to excel to filter out any other job or admin purchases.

Hope you agree!

Kind regards

ACorp

"Aged Payables Report - Job Specific"

[Dan_Moulton]

Thanks for the feedback. I'm interested to understand more about the administrative task you need to complete with the report. The Payable reports are really designed to show a summary of what is owed to Suppliers, and as such they don't report at the detailed transaction line level which by the sounds of it is what you need. Other reports such as Purchases Supplier allow you to add the Job fields, if you had a Job filter on these detailed reports would it help?

[ACorp]

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

[ACorp]

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

Thanks!

[Tbat]

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.

[ASWatCR]

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

[Jeff_AccAddons]

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)

[JosephMojo]

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.

[Alex2800]

Hi

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

[StannardFH]

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

[HURQLD]

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.