Inventory Variances
Hi, We have huge inventory variances between the inventory ledger and the GL. I have identified that the variances are due to product builds. The product build is using the inventory account in...
Forum Discussion
Hi Mike,
Thank you for getting back to me. I only work part time, so today is first day back in the office since posting my question.
I have attached a screen shot of the GL which relates the the transaction in the screen shots previously provided.
I don't believe the COGS account is the issue. I believe the fact that the journal created in the background by MYOB DR's and CR's the asset account is the issue. I believe one side of the transaction should be going to the COGS account when it is not.
I have run an inventory variance report on 31st October and again on 1st November. There is movement in the variance by $21.79 in finished goods and $15.53 in raw materials. This is what leads me to believe the variance is caused by MYOB DR'ing and CR'ing the same asset account, instead of the COGS.
If the DR to raw materials of $15.53 and the CR to finished goods of $21.79 was not being posted to those asset accounts, there would be no change to the variance on the inventory variance report.
Hi Blair38 , thanks for providing these further details. The journal does not look like a normal autobuild entry should, so can I ask for more information: For all the item codes involved in the journal, can you review each one and note the inventory asset account. Then tell me if any other asset accounts appear in the list other than the two accounts shown in your screenshot?
The items have the following asset accounts:
PTE2140 1-1330 Finished GoodsPTE2150 1-1330 Finished Goods
COP016 1-1310 Raw Materials
COJ036 1-1310 Raw Materials
Hi Blair38 , can you also send me a screenshot of the journal itself?
The journal is in the screen shots above.
CR 1-1310 $0.79
CR 1-1310 $14.74
DR 1-1310 $15.53
CR 1-1330 $126.93
DR 1-1330 $148.72
CR 1-1330 $21.79