Has anyone configured trading excise scenario in SAP B1? Kindly provide your inputs on the subject. SAP B1 does not have any transactions/reports to address the scenario.
As per the Excise Norms organisation which is trading excise commodities needs to maintain RG23D register. This register contains the details of the Excise Materials purchaseed and the sales made against these purchases. RG23 D register contains the details such as the supplier's name, invoice number, invoice date, excise duty paid on purchases etc.
On making the sales all these details pertaining to the purchases need to be printed on the Excise Invoice. RG23D contains these details.
I hope I have made myself clear. kindly revert for clarifications, if any.
Please find Message Number : 615000 regarding First Stage Dealer Invoice.
The Message and reply from SAP is paster here:
Calculation of Tax:
While making A/R Invoice, Excise duty is calculated on the Assessable value of the material. i.e. Sale value of the material. This mode of calculation is suitable for a manufacturing concern.
For a Trading concern, who is merely selling excisable items, he can collect the excise duty paid on inputs. For this purpose, Excise duty should be calculated on the purchase cost of the material rather than the sale value of the material.
Also, while making the A/R Invoice, the information related to the Purchaser details should also be provided.
Eg.,
Material X of 100 quantities was purchased from Mr. Supplier, for Rs.1163.20 which includes a Excise duty of Rs.163.20 @ 16%.
Break-up:
Qty: 100 No.s
Price: Rs.10
Excise duty: (100No.s x Rs.10 x 16.32%) = 163.20
Total Value: 1163.20
VAT @ 4% = 46.528
Total Transaction value = 1209.728
When I am selling 50 quantity of this material, I should make invoice like this.
Quantity: 50 No.s
Price : Rs.17 -
> Selling Price.
Total (Without Tax): Rs.850.
Excise duty Recovery:( Rs.50 No.s X Rs.10 X 16.32%) = Rs.81.60
Total including Excise duty = 931.60
VAT @ 4 % = 37.264
Total Sale value = 968.864
Hence, Calculation of Excise duty should not be on Sale value. Since, this is a recovery only, Excise duty should be calculated on the related purchases value and details regarding the purchaser should also be provided.
Please suggest us how this is possible in SAP.
The reply from SAP Support is;
Dear,
Request you to test the following workaround
1) Create two Tax Codes
a) BED + VAT Mfg
b) BED + VAT Trading
2) Farmula for BED + VAT Mfg
BED_BaseAmt = Price*Qty
BED_TaxAmt=BED_BaseAmt*BED_Rate
3) Farmula for BED + VAT Trading
BED_BaseAmt = AssessableValue*Qty
BED_TaxAmt=BED_BaseAmt*BED_Rate
4) In the item master data populate the field assessable value with the
price used to calculate excise duty at the time of purchase.
5) Use the tax code BED + VAT Trading at the time of trading.
Request you to test the above workaround at your end and consult it with
the accountant of the customer before implementing it.
If the above workaround resolves the reported issue,please confirm the
Thanks Guys for your support. However, what I am looking is not the calculation of tax but passing the details of purchasing to Sales Invoice.
ie.., Name of the supplier, Invoice No. of the Supplier, Invoice Date of the supplier, Total Quantity in the Invoice. etc. These details are to be reflected in the sales invoice.
One of the methods that I have in mind is by using batch management. Is there any other method of handling the scenario? Has anyone configured trading excise scenario for any of their clients?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.