on 01-21-2010 12:23 PM
Hi,
Can any one know about rverser calculation in SD Pricing. I am working on implementation project of process industry and it is very common scanrio in their pricing.
Customer will raise a PO for Rs 1058 which is inclusive of Discount,exice, VAT/CST.So system should do reverse calculation and will give me value for vat/cst,excise ,discount and base price.
how to configure that.
Customer Po Price Rs 1058
So system should calculate BAse price,Discount,Excise and Vat/CST
Means Base Price 1000 -
A
Less Mat Dis- Rs 60----
B
NEt Price- 940----
C ( A-B)
Excise BED - 75.2 -
8 % on C------D
Ed Cess 1.504-----2% on D--
E
HE Cess 0.752-----1% on E--
F
Gross Price 1017.45 ( CDE+F)--G
Vat 40.69 -
H
Total 1058 ( G+H)
Client want they will put Rs 1058 and system should do reverse calculation and calculate all above value automaticaly.
Waiting for immediate reply
Bye
SD Consultant
ok
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You will have to set Calculation Type for this Condition Type in V/06 as H (percentage Included), to get the below result.
1. Customer enters into the single Sales Line Item = $10
2. System calculates Special Tax (ZTX1) : 10% = $10 / (100% + 10%) * 10% = $0.9
3. System calculates Price (PR00) : $10 - $0.9 = $9.1
In case of tax value to be calcuated based upon gross value.
$10 = $9.1 + $0.9.
This is pricing case of Percentage inclusive.
So to calculate the ZTX1 as 10% = 0.9,
regards
Vivek.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
104 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.