Inventory and cost of orders

Hi MYOB_rookie,

It makes total sense on what you’re after. The Inventory Value Reconciliation report is perfect if you’re trying to line up your inventory values with your accounting records, which is why it includes all orders, even those waiting to be invoiced. If you’re looking to see which items you still have available to sell, the item register summary report is the way to go. That one shows you exactly how much you have in stock at any time, so you know what’s available.  

Cheers,

Princess

Thanks for responding so quickly, Princess_R​ 

I ran the Item Register Summary report and you’re right—it does show how much is available to sell.
However, it doesn’t filter out items that are on customer orders (i.e., received but not yet invoiced).
Another way to put it is that it doesn’t exclude the committed stock.

I’m not sure whether there’s a report that can do this, or if I’d need to export the data and filter out the committed stock in a spreadsheet. Love to hear any suggestions you may have.

Thanks again,

MYOB_rookie

Hi MYOB_rookie,

Oh i missed that. I took another look, and I’m not totally sure the Item Analyse Inventory Summary will show exactly what you need, but it does list both committed stock and available stock info, so it could be worth trying out. If it doesn’t do the trick, then yes, the other way is to export the data to a spreadsheet and work from there.

Cheers,

Princess

Thanks Princess_R​.

No problems at all, any chance you know how to add a committed stock column to that report? I feel like you should be able to do it through custom filters but not sure how they work.

Beauty Princess_R​ 

Stock on hand report in the browser version is fire. I will need to do some formulas but I probably get AI to write them for me. Thanks for your persistence as you have resolved my issue. 

Much appreciate your assistance.

MYOB_rookie