It looks like you're new here. If you want to get involved, click one of these buttons!
So Hornsby Ku-Ring-Gai Community College has been attempting to get Cash accounting information out of the onCourse system.
We were printing 'Cash movement detail reports' from the Banking Deposits list and then manually checking individual invoices against the payment entries for GST/FRE. However today, while staring down the prospect of writing a custom export/report to automate this process (with next to no scripting experience), I realised that there must be a way to get the information we need without figuring out code.
That way is as follows:
Open the Banking Deposits interface and highlight all the desired entries.
Click 'Find Related' and select Payments In.
Highlight all the resulting Payment In entries in the list.
Click 'Find Related' again, this time selecting Invoices.
Highlight all the Invoices in the list and click the Export button (top right of window, next to Report and Cogwheel).
In the Export window, choose the 'InvoiceLine CSV Export' and choose a location to save the resulting file.
Contained in the CSV created in this process is all the invoice line data such as tax codes and discount amounts etc, which can be easily modified in Excel to suit your needs.
Hope this is helpful to someone out there in similar circumstances, or perhaps anyone else wanting a way to collate their invoice data for review.