VAT or CST not calculating properly after manual excise entry

[Pankaj13]

In normal scenario, as per tax procedure VAT or CST is calculated on the sum of Excise duty and Base Amount, but if excise is entered manual in PO via condition JEXC in pricing procedure, even though excise condition (JMOP) is updated correct in tax procedure, the dependent values on it like VAT or CST are not updating as per new excise value. Any idea if something is missing in config?

Thanks for support

[binoy_vargis1]

It should work properly. Can you show the screenshots of Tax procedure in OBQ3 and also the Invoice tab in PO.

Regards

Binoy

[Pankaj13]

Thanks Binoy for quick reply, below are the required screenshots, let me know if anything else is required.

[binoy_vargis1]

Tax procedure seems ok. Can you check by deleting the condition record of 12.5% for JMOP.

Regards

Binoy

[former_member192897]

If you are using JEXC (Manual Excise), why you have maintained the condition record for JMOP? You can delete the condition record JMOP for the selected tax code and check once again creating a new PO and see if the calculation part is fine.

[Pankaj13]

Hi,

Values are coming Correct if I remove value for JMOP, below are the 2 queries

1. We have both Manual and Automatic allocation of Excise duties, so in this case we have to maintain 2 separate tax codes for the same?

2. Even if JMOP is set zero, at the time of J1IEX (Excise Capture), MIGO, J1IEX(Excise Post), proper accounting entries are triggered, but at the time of MIRO, excise accounting entries are coming different account.

e.g. in our case 10000 was manual excise set and instead of going to excise clearing account, it was going to material inventory GL i.e. LACTOSE 1 GL

[binoy_vargis1]

Yes you have to create two different tax codes for this purpose. For your second query can you show the accounting entry at the time of J1IEX.

Regards

Binoy

[Pankaj13]

J1IEX is shown , but we are still looking for solution for proper MIRO entries as excise should go to excise clearing account rather material account.

[former_member192897]

What happened when you chose the relevant tax code in MIRO as per your requirement? Did you get the proper accounting entries? If yes, what is the issue then?

[binoy_vargis1]

Create Taxcode such that in PO Taxes you can see the setoff condition desired with 0%(eg. JMOP) and total condition as 100%(eg.JMX1). Now check whether excise clearing account is coming or not.

Regards

Binoy