Skip to Content
0
Jun 17, 2009 at 07:01 AM

J1iex issue : J_1IEXCDTL GR qty doesn't get updated

45 Views

Hi ,

we have a process like .... Capture excise invoice , MIGO 103 , MIGO 105 and Post excise invoice.

Facing one issue wherein system is not updated GR QTY in J_1IEXCDTL table.

The step I am following are

1) Capturing excise invoice ( Say number is 100 and excise invoice internal number 45)

2) Cancelled that excise invoice

3) Re-creating exscise invoice with same number ( 100 and excise invocie internal number 46)

4) Did MIGO 103

5) Perfomred MIGO 105

6) Now cancelled MIGO 105 ,

Issue 1 : It changed the status of both excise invoices 45 and 46 (internal numbers) to "IN PROCESS"

Actually the Status of 45 should be CANCELLED and 46 should be "IN PROCESS"

Issue 2 : Generally reversal of MIGO , updates the "Qty of Goods received" in J_1IEXCDTL but in this case Qty doesn't get chaned to 0 for Excise invoice 46.

Issue 3: Because of all these issues , we are not able to cancel Excise invoce 46. System is throwing an error

" REVERSE the material document before invoice cancellation"

have u guys encountered such types of issue ...

regards

Shrey