Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
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).
- 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.
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