Hello all,
I have created a counting journal for an item and the Cost price does not populate on the journal line. The item's model group is set to Weighted average, and so there is no cost price set in the Price field on the Managae cost fast tab of the Released product form. Since no price is populated in the Counting journal by default, when I post the journal (say, to add 1 unit to inventory), it throws off the weighted average cost for the next transaction.
Here is the model group:
Here is the journal line. Note there is no Cost amount.
Here is the transaction history. Note that I ran a Recalculation hoping that would solve the issue, and it did not. The cost for the Counting journal in Purchased status was 0 and the first inventory adjustment is -12.90. This -12.90 was the price after the Recalculation. Before the Recalculation, the cost for that transaction was -14.29 or ((100+200+0) / 21). By my calculation, the Counting journal cost should have been 15.00 or ((100+200) / 20) which would have made the inventory adjustment cost -15.00 or ((100+200+15) / 21).
The cause of the issue is the Counting journal with 0 cost. Can anything be done to automatically populate this field with the correct Weighted average cost?