Inventory quantity by location is empty

1

Hello, my inventory quantity by location is showing empty after this new upgrade. kindly help to fix ASAP

inv qty by loc
inv qty by loc797×363 10.5 KB

2

@lubos @Tut please help check if am missing something out regarding my concern

3

Dear Team,

I really need help here. There is no way I can check the quantity of my inventory in each locations. Am I missing something out or is there any other way to handle it?

Inventory quantity by location does not give the true picture of the current quantity

4

No one can help without information. A screenshot of a blank report is as useless to us as to you. You need to show screenshots of drill-downs from the Inventory Items tab that illustrate something that should show that does not. Depending on your response, more may be required.

5

Thank you @Tut for your response. find the attached inventory items

inventory items1
inventory items11506×777 59.3 KB

qty owned
qty owned1502×446 24.3 KB

inventory quantity summary is capturing records as seen below
inventory qty summary
inventory qty summary826×641 21.2 KB

But inventory quantity by location has not record of any inventory.

Please help

6

You need to select one item and then show the edit screen of the transactions related to it

7

thanks.

see an illustration

inventory qty summary
inventory qty summary826×641 32.5 KB

this item was purchased by 2 inventory location adding up to 25

3
31497×447 21.5 KB

sales invoices (2) were also raised

4
41501×392 18.1 KB

Inventory quantity summary perfectly captured the records but inventory quantity by location is empty. its not showing the current inventory quantity by location.
i noticed that after the update, the ONLY record captured by “inventory quantity by location report” is inventory transfers. If an item was brought in through purchase invoice; it would not reflect on the report(inventory quantity by location), also sales invoice does not affect the particular report, its only INVENTORY TRANSFERS. please carefully take a look at it

8

Please read my question properly and in full

I asked to see the screen showing the edit transactions not the screen showing a list of transactions

9

@Joe91 thank you. find the sales and purchase edit screen

5
51538×856 33.7 KB

6
61185×892 49.2 KB

10

Thank you

They are in order as far as I can tell

Can you please confirm the version number of Manager you are using?

11

Thank you

Am using cloud version 24.6.17.1664

12

OK, there is something odd - the Inventory Quantity by Location is tracking some quantity but it is not clear which of the various inventory quantities now available it is using

I haven’t time to look at this in detail tonight, sorry

13

Thank you @Joe91

I was trying to explain to you that the report ONLY captures inventory transfers, thereby neglecting purchase invoice, and sales invoice deduction

14

There are no a number of quantities associated with inventory items - each quantity is affected by different transactions - sakes invoices, delivery notes, sakes orders, etc etc

It isn’t clear which of these quantities is being used in the various Inventory reports

I suspect that the Inventory by Location is not using the correct quantity

This is a bug, in my opinion

15

The new update 24.6.17.1665 has still not fixed the issue on “inventory quantity by location”