So, we have part that had a transaction of 2,100 for Backflush labor. but, according to my engineer, it should only of been 100. So she went and tried to correct it with the 2,000 on the 6th, and that did nothing to solve.
-
Why not MFG-STK ie: Return the 2,000 to stk.
The issue of raw-mtl to a job STK-MFG will Credit Inventory and Debit WIP
Therefore
The return of raw-material from the job to inventory
will Credit WIP and Debit Inventory… -
Check the HELP for the DATA COLLECTION - ADJUST MATERIAL command
“Use the ADJUST MATERIAL window to adjust the physical location or quantity of a material. You will only run this program when a material quantity is recorded as being in a specific physical location, but is actually in another location.”
Sounds as if this command was intended to “SHIFT” the location of where the parts are.
1 Like
What does the quantity say in Part Tracker?
You would need two transactions for this problem. To get the cost from the job you need the ADJ-MTL transaction. However, to get the material back into stock you will need a ADJ-QTY transaction. You will need a reason code setup to remove the cost from the ADJ-MTL account back to Stock accounts for the cost to move properly. The ADJ-MTL should move the cost from the job/wip accounts to a holding ADJ-MTL account if you have it setup this way. Then, the ADJ-QTY transaction with the proper reason code GL control can move the cost from the ADJ-MTL account to the stock account. Otherwise, you would need to create a negative labor qty record and then update the JOB MOM and then process again and the system would move the cost on its own.
Thank you for all the replies. I was out sick for since Monday after I posted this. I will go through this and let you guys know how things went or if I have nay other questions.
@cchang The Part Tracker say 100.
In E9, I believe there is a conversion program 6430 that you can try running if there is a discrepancy between Part Tracker and Part Trans History totals. Not sure what it is in E10.
@cchang Sorry for late response, last week was not a good week. Yeah, I don’t see anything like that for 10.
@Mark_Wonsil Did that this morning to no avail.
The easiest way to fix this is to find the offending labor transaction and adjust the qty in T&E if you can. It will back out the inventory and costs all on one transaction. The caveat is, you have to do this before the transaction is posted (I think).
Yeah you do. Interestingly, the labor looks good. It seems, it posted and then someone changed it somehow. While it worked for the Job/accounting, it didn’t work for the transaction history. So I have this mess.
Rephrase: labor was probably logged incorrectly on the related operation or someone went in and changed the engineering after labor was logged and the backflush completed.