Wednesday, June 23, 2010

Increase Excise Duty Payable GLs amount in SAP

Problem: MRP was revised of certain finished products after removal from excise warehouse. stocks were out of the system and bringing them back to excise warehouse was not possible. Stock counting of such items at all india level was done and differential duty of increased MRP was calculated manually.

In SAP J2IUN transaction the value of Excise Duty related payable GLs was to be increased with this manually calculated amount.

Solution:
1. Create a new customer (name anything like MRP Revision Excise Duty Difference etc.
2. Create a FG material having stock value of Rs. 0.01 only
3. Upload intial stock of 1 qty into this newly created material
4. Create FOC Invoice from Excise Plant

At the time of Sales order creation, change the MRP in pricing (AFS Conditions) so that system calculates exact differential duty payable.

Excise payable GLs would get updated automatically on saving of excise invoices.

Block the customer
Block the material

Same procedure to be used in future.

No comments:

Post a Comment