Hi All,
How to setup structure for following values
Amort Excise is calculated @ 10% per piece
qty = 1000; price = 10
Basic Amt (A)= 10000
Amor exice (B)% = 1000
Total (C = A+B ) = 11000
Excise(D= 8% of C) = 880
Total (E = C+D) = 11880
Vat (F= 4% of (A+ 8% of A)) = 720
Total Value = 11880+720 (E+F)
can it be done without customization.
Thanks & Regards,
Vijay
0
Comments
If a machinery costing 1,00,000 is supplied by customer and the machine is capable to produce 1000 qty of item, The assessable value on which the excise will be calculated will be as follow:
Sale Price + (1,00,000/1000) i.e. Sale Price + 100.
In your example I am thing the price on which the tax will be calculated will be base price (10000) + excise duty ((10000+1000)*8/100)= 880.
Correct me if I am wrong
http://ssdynamics.co.in
http://ssdynamics.co.in
http://ssdynamics.co.in
Basic Price
Excise Duty ((Basic Price + Ammortization value)*excise rate)
VAT/CST (Basic Price + Excise Duty)
charges if any
P.S. Are you considering it for Sales or Purchase
http://ssdynamics.co.in
What you have said is correct , I dont think its possible to use excise calculation based on assessable Value. Here i have given an example how its being processed.
Cost of Tool = 10
Total Qty = 200
Price = 50
Tool Amortization cost ( 200* 10) = 2000
Total Assessable value (200 * 50 ) = 10000
Excise Duty @ 10 % ( 10000*10%) = 1000
Duty on Amortization @ 10% ( 2000*10%) = 200
ecess amount ( [1000+200] * 2% ) = 24
shecess amount ( [1000+200] * 1% ) = 12
VAT @4 % ( [10000+1000+24+12] * 4%) = 441
Totamt (10000+ 1000+200+24+12+441) = 11677.
Hope this is much more clear.
Regards,
Vijay
For printing display line amount, assessable value (Tool Amortization value on sales line * qty), give a subtotal and then excise.
We are using the same since 2 years in a implementation and is working fine.
http://ssdynamics.co.in
Amortization Excise value is only used for calculation of excise amount and it will have no bearing on the VAT amount.
There is a difference between Excise and VAT
http://ssdynamics.co.in
i.e In Structures,
Can I define Excise twice, 1 Using Percentage and the other based on number of quantity..
Never done it but the answer is no. The excise calculation is done using the setup i.e. Excise Business Posting & Excise Product Posting Group. So if you define it twice it will calculate it twice on same % and not on different.
http://ssdynamics.co.in
1) I just worked out on another solution kindly suggest weather its correct way to follow,
In Excise Posting Setup,I have defined
a) Basic Excise Duty
Bed Calculation type =Excise %
BED % = 8
b) Special Excise Duty
SED Calcultation type = % of Accessable Value
SED % = 8
c) She cess & E Cess = Inclusive of both.
I am getting all the values correctly but is using SED is correct in this situation?
2) My client does not want excise to be rounded off, so in GL setup , excise rounding precision I have given 0.01. But when I try to post I get following error.
"Amount -***** needs to rounded in G/L entry no=**"
Hope to get a reply
Thanks