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?
Hi Mike_James
Yes, the PO Receipt is sent as a BILL because from the 3rd party software perspective, the PO is placed there. If we sent it through as a PO we introduce another layer of processing. Unfortunately, that's how our assembly orders come through as well
So when we did the assembly order, that came through as a BILL. The unit cost on there was say $1.06. I would ASSUME given that, the inventory would have gone into negative? Given the item card has $0 standard cost, that would have gone in as negative inventory as 0 cost. So when the PO Receipt came through, it was at the correct cost of $1.36. Again my assumption would be that this would bring Stock On Hand to 0. So now the question I'm trying to answer is where did that $1.06 come from because in the inventory management system, the cost on the work order was $1.36....
At first I thought perhaps it took Weighted Average Cost but then I can't get the math to match. So I'm not sure that's it.
Cheers
Jilly
Hi Jilly (JIllyTan)
It's great to see that Mike_James has provided assistance with this. There are a few factors as to where the amount being posted comes from.
If it was an import from a 3rd party, I would check with them first, as it could have come across with the partial posting to COGS.
Another factor is f it was edited after being imported / recorded, it can cause the posting to be different, as it might be based on the original amounts, not the current values.
If you are still unsure, feel free to respond with a screenshot of the transaction so I can reproduce the error on my end.
