Customised reports for Sales and Purchases

Experienced Cover User Aviator
17 Posts
Experienced Cover User
Experienced Cover User




Customised reports for Sales and Purchases

I need assistance regarding reports for our auditing basis.  From research what I can see I will need to do 2 different reports and merge them or either copy and paste information to an excel spreadsheet.

What I need is the following:-


-  Total number of invoices received and average payment time to Suppliers (in days);


                        -  Total number of invoices sent to each Customer (Sales);


                        -  Number of which invoices were within 3 days of receipt of the invoice from the Supplier;


                        -  Number of which were outside of 3 days of receipt of the invoice from the Supplier;


                        -  Average payment time by the agency to Supplier (in days after the invoice to the agency has been sent).




By Supplier:

                        -  Average time (in days) between the final charter date and the invoice being received by the Supplier;


                        -  Number of which were paid within 10 days of the Air Charter final date;

                        -  Number of which were paid 1-3 days late;

                        -  Number of which were paid more than 3 days late.


I would like any information or assistance.


Huge thanks

MYOB Moderator Neil_M
6,837 Posts
MYOB Moderator
New Zealand
MYOB Moderator




Re: Customised reports for Sales and Purchases

Hi @Aviator


Thanks for your question


Assuming you have located the reports that contain the raw information that you require, you can then use the Send To function on the report to send that information. This will allow you to then combine the two reports in Excel, which you can then use to calculate these different ratios and percentages that you are looking for with these reports.


Do let us know if you have any further questions

MYOB Client Support
Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
Get the conversation started and make a new post Start a Post