Excise - Balance qty, showing wrong in RG 23 D and in J1iJ

Hi:

We have issue with respect to the Excise records inventory movement. and this started happening for no reason in last month.

The balance of inventory in the Excise records is not getting exhausted as and when invoicing is done.

For example:

If XYZ batch inward through GR is 100KG on 1st Jan

Issue through invoice on 2nd Jan is 10Kg

Ideally the status of this product batch in excise records should be 90Kg

after invoicing on 2nd. This is not happening. The balance is still showing

as 100Kg.

This could create wrong batch selection in invoice for excise and the

excise records is not showing the correct movement. This could create

problems in statutory compliance.

Can someone tell me why this is happening and what needs to be done?

Thanks