Hi Heather

If all you need is something that shows Invoice Sub-Total , HST, Invoice Total, the following will work. This assumes that you are using Order Entry and have Gridview.

Table: O/E History Header (Under Adagio OrderEntry)
Fields: Cust #, Name, Inv Date, Inv #, Doc Type, Doc #, Disc Base, Tax 1, Total Dollar Value
You'll want to filter out the "O" type documants which will leave you with "I" and "C" types.
(I have a Calculated Column called Sub Total Amount which is {Total Dollar Value} - {Tax 1} because I use negative invoices rather than credit notes.)

This will give you a list of all invoices and credits, paid and unpaid, showing the Sub-Total (Disc Base), GST (assuming GST is Tax 1 in your system), and invoice/credit total. You can create your own filters, or export it to excel to edit and send to customers.

If you only want unpaid invoices, you'll have to use the A/R Transaction Matching File table from Adagio Receivables and either create a common join between the two in Gridview, or export it to excel and merge it with the previously exported table.

Of course, if there was a running amount for the discount base available in statements, you could show the before and after tax amounts on the statement and then your customer could do the calculation.
_________________________
Mike Smith
Viktorian Sheet Metal Mfg Inc