Inventory Costs
We are a manufacturing business and over the last 2 months we have noticed that our average costs in MYOB on select lines have dropped dramatically between January to February and further again from ...
Forum Discussion
Hi Mike
These are manufactured products, and we are using autobuild. The the autobuilds don't seem to be recorded at lower costs than before and all the component costs arebeing included that were before.
Hi JosephE , can you pick a good example of a product with this issue, then run the item register detail report for a suitable (long) date range to Excel, and add a column for the unit cost of each transaction. If possible, pick an item that you can report from its beginning in the file
1. Does the report agree to the screen register?
2. Does the change in unit costs provide any clues?
(Sales transactions pick up the average cost/unit from the item information at the time the sale is recorded).
Do you use multiple locations?
Thanks again MIke
Interesting results for the Item Register report. There is a whole bunch of transactions in the periods in whch the Margin has dropped where the amount on certain sale transactions is zero even though the quantity of stock on hand is going down by large amounts.
I have attached a screenshot.
Any thoughts on why and how this could be happening?
Hi JosephE , I don't see any build transactions, so I can't see a full movement history?
For any of the invoices showing zero cogs on this display, if you edit the invoice, add a fullstop to the journal memo, click OK (to repost the invoice), then run this report again, do the values change?
Can you run an item sales detail report for this product, and customise it to remove the Status and Promised Date fields, and add in the Gross margin dollar and percent. Do the sales showing nil COGS on this register report correctly or not? (Don't post the result, too sensitive).
Hi Mike_James ,
Tried editing the invoice in this way but unfortunately had no effect on the values.
I have attached an example of the full movement history on an invoice where there were many zero COGS transactions (00028739). I have highlighted the zero COGS transactions. As you can see the build amounts are correct but no costs are going up against the sale.
I ran the item sales detail report for this transaction also and the Gross margin dollar and percent are showing 100% margin on the sales showing nil COGS on the item register.
