nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Inventory and cost of orders

MYOB_rookie

Good morning MYOB community,

I’m hoping someone here can help me.

I’m trying to find my true inventory value.
The issue I’m having is that when I look at the Inventory Value Reconciliation report, orders that are pending invoicing are showing up.

What I really need to know is the value of inventory I actually have available to sell—i.e., not yet committed to a customer prior to invoicing.

Does that make sense? Thanks in advance for any help!

Cheers,
MYOB_rookie

Find more posts tagged with

Desktop

Accepted answers

Princess_R

Hi @MYOB_rookie,

The AccountRight desktop inventory Analyse report already includes the committed column, but I’ll also send you this handy info about filtering reports. Plus, I found a fantastic report that's perfect for what you need, the Stock on Hand report in the browser version. I really think this one will give you just the right data.

Cheers,

Princess

All comments

Princess_R

Hi @MYOB_rookie,

Cheers,

Princess

MYOB_rookie

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.

Princess_R

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

MYOB_rookie

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

Princess_R

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