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. 

Views: 28

Reply to This

Replies to This Discussion

Hi

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 - deon@maperp.co.za

What flavor of Sage are you using?

RSS

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service