cancel
Showing results for 
Search instead for 
Did you mean: 

SAP B1 Total w/o Discount

thobenjo1
Explorer
0 Kudos
120

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

View Entire Topic
narayanis
Active Contributor
0 Kudos

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.