Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
I am doing my inventory value reconcilliation for 30th June and had noticed that there are a few items with zero value against them. I went in to a stock adjustment that I did on the 5.6 to update as current value for these items and some are now showing correct amounts while another is showing a less amount as there was a sale in july so its deducted this off even though the stock adjustment occured in June and the Reconcilliation report is for June but when I go to print it shows minus the t. How do I fix this?
ie the stock at 30th June was 20 units at $30.00 each total should show on Reconcilliation Report as $600 but because there was a sale in July it is show value of $540 why is this the case?
Solved! Go to Solution.
Not sure if this answers part of your question or not, however when calculating COGS for a Sale MYOB uses the value of the item divided by the on hand count at the time the transaction is processed.
So if you process a Sale transaction on 6 July and the Sale is dated 6 July, MYOB uses the information it has to calculate COGS. If you then (say on 7 July) enter an inventory adjustment dated 30 June, this has no affect on the 6 July COGS calculation, this amount is not recalculated due to the inventory adjustment. FYI COGS on a Sale reduces the count and value of the Item.
This is why Item Register values don't always make sense until you understand the order the transactions were entered.
In your last para "but because there was a sale in July it is show value of $540 why is this the case?" If 2 items were sold in July, then you would expect count to drop to 18 and value to $540. If this does not make sense, please provide more info, for example where are you seeing the $540, and what date are you using, etc.
Thanks that does answer my question, I will have to be more mindful of this in the future.