SAP B1 Total w/o Discount

[thobenjo1]

Hi I want to get the doctument total which includes discount also but not tax. How do I get it ?

T0.[DocTotal] + T0.[DiscSum] + T0.[DpmAmnt] - T0.[TotalExpns] - T0.[VatSum] AS 'Subtotal (LC)

In this how do I get discount , so that the discount also gets reduced from this total

[narayanis]

Hi,

when you say doctotal it considers everything - unit price, discount and taxes. Ideally, you should consider price before discount, discount, and tax separately. During calculation discount will be deducted from total price and tax will be applied post discount deduction then freight comes in picture.