Can anyone tell me if there is a way to show the total tax (HST) on the bottom of a statement for outstanding invoices or even adding a new column to the statement to show the HST for each invoice. I have looked in the fields list under the maintainence for designing the statement and I have not found anything like this.

Hi Heather,

Receivables statement forms lists invoice original and outstanding balances, but cannot break out the tax specifically. This information is not stored in the Transactions file on which Statements are based.

is there anywhere in the system or in reports that would give you this breakdown of tax for a customer??? If a customer has 100 invoices on his acct that he is paying for and would like to know how much is tax I have to look at each invoice and add the tax up (this takes too long).

If there is know way to see the tax amount, can this be considered a request in future updates to find a way to breakdown the tax to show the totals.

I have noticed on Statements I receive from our Vendors that there is a total at the bottom of the statement to show total HST on purchases.

Thanks for all your help.

How do you issue invoices? If you use Adagio Invoices, the invoice can (and should) show applicable taxes.

The Tax Tracking report can be sorted and subtotalled by customer. It shows all invoices, not just those outstanding and unpaid.

Heather:

Not even sure if this is possible without some testing but;

You would need to create a custom Adagio (Crystal) Report using the customer current transactions to determine outstanding invoices and the tax tables (from whatever invoice module you are using) to find the HST. The report output would be your customer statement (it would be possible to dress this up to look exactly like a statement).

I would think this will require a fair amount of expertize in Crystal and the Adagio database.

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.