Excise scenario

[Former Member]

Dear Experts,

Can anybody explain how to map in SAP below scenario

If we are selling both Excise and Non excise product and we are enjoying the input credit from raw material for using excise and non excise production, we have to pay an extra amount to the Government at the end of the month.

Actually this extra 5% is not excise amount. As per rule at the end of the month we have to calculate the total nonexciable sale and calculate assessable value (60% of MRP of Non excise product) , on assessable value we calculate 5% and treat as duty payable. so this 5% is fully expenses for us, because we are not collecting from customer.

Early reply will be appreciated with points

Regards,

Caprin

[former_member206976]

Hi Caprin,

Very rare requirement. Please update the details like for which industry this is required , that information will help to our forum members.

While coming to your query there is no way to raise a invoice by using standard configuration.

 As per rule at the end of the month  we have to calculate the total nonexciable sale and calculate assessable value (60% of MRP of Non excise product) ,

First you collect the data from system by developing a report based on VBRK, VBRP and KONV compare with where the VBRK - VBLEN is not equal to RDOC In J_1IEXCHDR for Excise Transaction type DLFC.

After getting the total details of non excisable material sales with values

Down load the data with billing document numbers and prepare a BDC to post the Excise JV in accounting by using transaction FB50 or use J1IS

Hope this will help your query.

regards

bvdv

[Former Member]

Hi friends,

Thanks for your inputs ,basically this scenario is for footwear Mfd Industry,

Regards,

Caprin

[Former Member]

Hi Caprin,

Seems to be unique scenario. Need more clarity on the process.

But still my suggestion is to a maintain seperate document type for selling the non-excisable material. Maintain a pricing procedure which captures the duty.

Like

ZMRP, ZASS, ZABT (40%). Get the asseasable value, maintain a condition type ZNEX(5% DUTY) with a separate account key. Have a seperate G/L for that value. Pay the amount through PLA.

Thats my suggestion.

Thanks,

Saravan Raja