Warehouse number is not showing on ON hand form but it is on transaction

(0) Share

Report

Posted on by Shabir Ahmad

3,110

5543.On_2D00_Hand.png

Hi Experts,

Warehouse number is not showing on On hand form line but as I checked it transaction it was showing warehouse number. Please check the images.How can I show this warehouse number on ON-Hand form even I manually added in table inventdim table but no luck?

Best Regards,

Shabir

All responses (1)

Answers (0)

Suggested answer

André Arnaud de Cal... 294,095 Super User 2025 Season 1 on at

Like (1)

Report

RE: Warehouse number is not showing on ON hand form but it is on transaction

Hi Shabir,

Not sure why you wanted to update the warehouse on the inventory transaction. It is not supported to change InventTrans or InventDim records manually. I don't know if you changed values in the InventDim records or changed the InventDim field on the InventTrans table. If you changed values on the InventDim table, you might have changed many other transactions as well.

I can imagine that there was a requirement to fix a wrong posting, but there might be more tables related to this transaction. The On-hand information is taking data from the InventSum table which is not updated when you manually change the Inventory transaction. This table is updated during the inventory posting process.

There might be an option to run the Consistency check for the Inventory and choose an option to fix data instead of a check only. How to do this is written in a blog: Consistency check | timsaxblog (wordpress.com)