Customer invoice reports
I need a report that lists all invoices for any 1 customer that includes the gst in the amount column regardless of being paid or not. I can do the Sales ( Customer Detail) but it only gvies me e...
Forum Discussion
Thanks but I am after a report that includes gst in the amount.
Whilst the customer detail report gives me additional filters to choose, none of them can include or exclude gst
Any other suggestions?
Hi lyndor,
Thanks for reaching out. To view a list of transactions assigned to a specific account, you can generate the General Ledger detail report and apply filters to isolate the desired account(s). It's essential to keep in mind that when you run a report based on an account, it will exclusively display the amount allocated to that particular account. Consequently, transactions allocated to income accounts will not include the GST amount, as GST is allocated to the "GST Collected" account rather than the income account.
If the reports available in AccountRight do not meet your specific requirements, you may explore third-party applications available on our website's App Marketplace as an alternative solution.
Regards,
Earl
So are you saying that MYOB cannot produce a list of customer invoice numbers with corresponding amounts including gst, just 1 customer?
No matter if they are paid or not?
Hi lyndor,
Thanks for your response. Currently, this feature is not available in our software. However, You can view the following GST reports from the GST report group (go to the Reports menu at the top of your screen > Index to Reports > GST tab).Want to change the look and content of a report? Learn about customising reports.
Regards,
EarlHi lyndor
You can get that raw data out of MYOB via https://odatalink.com
It provides an invoices end point which includes all the fields provided by the Invoices end piont in the MYOB API
https://developer.myob.com/api/myob-business-api/v2/sale/invoice/
The data comes in via Power Query and in there the data can be transformed to filter a particular customer and to return that tax inc amount
Jeff
