Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
a month ago
We are construction company and we are doing jobs at different locations under the supervision of Project site managers. We need to provide Accounts Payable and Receivable reports, only relevant to each project site, on daily basis.
There is no straight report in MYOB as such it seems. I was exporting to excell and formating these to required level and exporting purchase register with Job number and doing vlookup to to bringin the Jobwise payable report. It takes huge time as well to export, format and bring aged payable by Job number.
Any on can suggest
- Is there any report which gives Job wise Aged Payable Report/Aged Receivable Report? I
- Is there any short cuts to achieve this.
Because, all the people may not be good in Excel. When other accounting softwares provides these, I am surporsed MYOB still haven't fixed these.
4 weeks ago
The Receivable and Payables reports in AccountRight look at the overall transaction i.e. the total amount of the transaction. Job costing is based on a per-line basis as such you are not able to get a Receivable or Payable report by job.
The best option would be to run the Sales [Customer Detial] report include the due date and job number. You would then send that report to Excel to filter and sort the values using Excel Functions and other functions to achieve the desired report. Other MYOB Community members may have some ideas but this would be the method I would use if that is required