Hi i am creating a sales report less discounts from the totals tab in AR invhistory header and detail. it is subtracting the discount from each line item. Any idea how i can get the sales less discounts in a sales invoice report.
I assume you are working in Evolution (Sage 200)
Discount are not stored in tables, except if you use a discount transaction code i.e. DS.
If you use the transaction code, look in the POSTAR table - for all transactions of the discount transaction code (the tx codes are all in the TRCODES table.)
Look then for all tx with same audit trail number - and do the calc.
Let me know if I can be of more help - email@example.com
What flavor of Sage are you using?