Hi Mike_James
We've done a little investigation. What I've been able to ascertain is the timeline.
1. The stock was received and an assembly order was created on the same day in our inventory management system. T
2. The inventory management system then sent the work order to MYOB as a BILL first, but then about 12 hours later, said system sent the Purchase Order Receipt as a BILL. (Not an ideal scenario).
Therefore MYOB (we assume because we don't know how to back track a transaction audit trail), would've gone into negative inventory at some point....again not ideal. So you were correct. That would've hit COGS.
We're now trying to track where MYOB may have gotten the item cost on the assembly order from given that it would have not had any idea of the item cost yet. (The item card has a $0 standard cost, and the PO receipt wouldn't have been receipted yet).
The inventory management system would've had the correct costs, because as far as it is concerned, the PO Receipt would've updated its internal standard cost. So the work order there reflects the right dollar value.
Thanks JIllyTan , I wasn't aware you were using a 3rd party program. I think you've highlighted the cause, ie the PO receipt being sent through as a bill?
