Error in excise duty values in RG1 register

[Piyush]

Dear All,

While extracting the RG1 registers it has been found that values for Basic excise duties, Education cess and SH edu. cess are not appearing properly.

I have verified the following

1. There were 3 deliveries against which 3 separate invoices have been created. Against these 3 invoices, 3 excise invoices have been created. All the inoices are posted to accounting.

2. Sales material as well as sold to and ship to parties are same in all the three invoices.

3. Dispatch location i.e. plant is same for all 3 invoices.

4. In J_1IEXCDTL table EXBAS as well as EXBED, ECS and EXADDTAX1values are appearing properly for all the 3 line items.

But no values are coming for 2 line tiems; whereas correct values are coming in 1 line item in the Excel download as well script for RG1 register.

Please help ASAP.

Thanks & Regards

Piyush

[Lakshmipathi]

Against these 3 invoices, 3 excise invoices have been created

Do you mean to say that the excise values are flowing both in biling document and excise invoice? I dont think so, if the values are not posted to FI. Please confirm.

thanks

G. Lakshmipathi

[Piyush]

Dear Lakshmipathi,

All the 3 invoices are psoted to accounts. All the 3 excises invoices are also posted to accounts. Duty values are flowing properly.

The problem is in the RG1 register extraction.

BED, ECS and HCS values are displayed for line 1 but it is blank for remaining 2 line items.

Thanks & Regards

Piyush