A/R Invoice History - how to calc Invoice Totals for type CM and DM (Credit and Debit Memo)

[bordway]

Hi,

I am looking for help in duplicating these values:
- "Invoice total" and "Balance"
--- for invoice Types CM (and DM).
----- as displayed on the "A/R Invoice History tracker".

I've been using the formula below
-- it appears to be working OK for type "IN" invoices.
--- But I just noticed some "CM" invoices didn't look correct.
----- The few things I've tried so far... no luck

>> Invoice Total:.... TaxableSalesAmt + NonTaxableSalesAmt + FreightAmt + SalesTaxAmt
>> Test if you need to subtract DiscountAmt (or not)
>> AR_InvoiceHistoryHeader table

Thanks,

Bruce










Bruce O