What do you mean by pending ARE-1 forms ?? Is it to be received from shipping agent ?? Is it to be submitted to Central Excise ??
For information, if the exports is made under Letter of Undertaking (LUT), you need to get the ARE-1 duly authenticated by Customs Officials within 6 months from the date of invoice date. On the other hand, if the exports is made under Rebate, you need to submit the ARE-1 immediately, once you get the Let Export details.
So based on this, you need to define a logic in such a way that the report should have input options like
- Export Type
- SAP Billing reference
- ARE-1 received on
As and when the ARE-1s are received, the third column should be updated so that at a later date, if you generate a report, wherever, the "ARE-1 recd.on" column is blank, those are pending.
If your requirement is different from the above, please let us know.
The logic for fetching ARE-1 details is from table J_1IEXCHDR and J_1IEXCDTL table there you can get the ARE-1 details by passing TRNTYP ='ARE1' and check whether against your reference Excise Invoice (J_1IEXCDTL - RDOC2) ARE-1 record is available or not.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.