Material Return to Project

Epicor ERP 10
1

Dear experts, While taking Material Return back from Project, GL effect should be Debit to Stock and Credit to Project WIP.

User has taken the Material Return back to Project. After revenue recognition he checked that GL effect Debit to Project WIP & Credit to Project Stock is not reflecting. Could you please suggest, how to resolve this issue.

Job Production Detail Report_001154.xlsx (70.2 KB)

Inventory WIP Reconciliation Report_001154.pdf (76.7 KB)

In inventory WIP report , You can see that

  1. First Transaction is Material Issued
  2. Second transaction after revenue reorganization
  3. Third transaction is returning the material
  4. After revenue reorganization fourth entry is missing which will reverse the project cost.
2

Two things

  1. The lines you highlighted (red box) say for job 001154, the Prod Detail says 001153.
  2. In the Prod Detail the legal numbers show different site (mfgsys for the issue, and RUS for the return)
3

Dear @ckrusen, I have download Production detail report in PDF same data appearing

Job Production Detail Report_001154.pdf (66.7 KB)

While returning the material, user had selected the different Transaction Document Type. Thats why it is showing “RUS” in legal number.

4

I would look at the Part Tran History for the part to verify the transactions happened the way you expected them to. Include the SysDate, to make sure that its not a back date transaction.

Also, on the WIP Recon, you have it filtered to just one GL Account.

image

Maybe the return hit other accounts. If you can find them it might help you figure out why.