Inventory Quantity Summary report and Inventory Items Does not correspond

1

I am having a problem with my Desktop version when it comes to Inventory.

Inventory Quantity Summary would show, for example, the I have 324 units of a particular item in stock, but Inventory Items (Tab) show zero stock available. Inventory Items and my physical stock correspond.

I do not find any help that assist me on the guides.

What may be the problem?

2

There are many types of quantities under Inventory Items tab. Qty owned is accounting quantity which is what Inventory Quantity Summary report breaks down for the period.

3

Thank you for your feedback Lubos.

How and when will than the be zero as it is, the way I see it, not possible to show stock on a report (and in assets) which was already sold. Or am I missing something somewhere?

4

Inventory Quantity Summary is quite an old report created when Manager tracked Qty owned only. Now Manager tracks about 10 different quantity types for each inventory item so probably the report should be updated and that you can get breakdown of any quantity type.

What are you really trying to achieve?

5

On my summary dashboard it shows a value and then when I pull the report it shows that quantity which confuse me and as I keep looking for where the problem might be.

I just want to see what is on hand and if it correspond with. the physical stock in my store.
If I can see what the value of the actual stock on hand is will also help a lot.

6

Qty on hand is a column available under Inventory Items tab. This allows you to track physical quantity.

See: https://www.manager.io/guides/inventory-items

7

Yes, That I know and I am using it. But in my assets (Inventory in Hand) Shows a value of stock that I do not have on hand. That is where my problem is

Image 2025-01-17 at 11.41
Image 2025-01-17 at 11.411034×606 53.9 KB

8

The figure is clickable. So you can drill down all the way to individual entries that are making up the balance.

9

I know it is clickable and did go in there, but this is what the problem is. That amount does not correspond as there cannot be a value if there is no stock. Can it be removed?

10

Can you show screenshot how it shows there is no stock when you drill-down that figure?

11

I will send you screenshot of Inventory on hand (In Inventory Items) and Inventory Quantity Summary. There you will see what I mean. The value showed, in the previous screenshot, equal the Inventory Quantity Summary which is also not correct.

The question remains… How can there be a value for stock that is not in stock

Image 2025-01-17 at 12.23
Image 2025-01-17 at 12.231240×590 52.6 KB

Image 2025-01-17 at 12.25
Image 2025-01-17 at 12.252202×1060 228 KB

12

You balance sheet balance is derived from Qty owned, not from Qty on hand.

Qty owned is quantity for accounting purposes. You can purchase something from supplier but have it delivered later. In that case Qty owned increases when supplier invoices you and Qty on hand increases when you receive goods.

Drill-down into Qty owned and compare with drilling-down into Qty on hand to see why it’s different.

If you don’t own any quantity, then Qty owned should be zero.

13

I do understand that and did the drill down, but even for accounting purpose or stock purpose the 2 must correspond.

How is it possible to Own stock (324 units) which was already sold and is currently showing Zero on hand. That does not make sense and that is why I asked the question.

I am willing to send you both files to see if you can find the problem

14

Please read the guides as per earlier post by @Lubos at https://www.manager.io/guides/inventory-items. They are very clear about how Qty on Hand is populated, i.e. only through Goods Receipts and Delivery Notes or Invoices where you enabled them to serve as such as well, as per guide. Why you are asked to show drill-downs and preferably edit screens is because in the quoted post you question how it is possible to “Own” inventory (324 units), which have been sold (How did you sell them? while 0 units are on Hand (may never have been “Delivered” or “Received” and thus stay 0). So the first question is about the claim you sold the 324 units, therefore show an example and edit screen of how you sold these.

Qty on Hand

If you are using Qty to Deliver and/or Qty to Receive, the Qty on Hand shows your physical quantity on hand.

  • Increased by Goods Receipts.
  • Decreased by Delivery Notes.
  • Excludes Sales Invoices unless they also act as delivery notes.
  • Excludes Purchase Invoices unless they also act as goods receipts.
  • Includes all other general ledger transactions.

Note: Sales Invoices, Purchase Invoices, Debit Notes, and Credit Notes affect Qty Owned but have no effect on Qty on Hand. Conversely, Delivery Notes and Goods Receipts affect Qty on Hand but have no effect on Qty Owned.