410
I would like to setup database for Warehouse field (Location) as below.
Can you suggest me where is the table for this filed.
I found in personalize is TmpInventDim but it's not work.
(TmpInventDim).InventLocationId
*This post is locked for comments
It would be very hard to do a logging on warehouse changes only for the inventory transactions. The table name is InventTrans. The warehouse is not a field directly in this table, but it is referenced using the InventDimId field. Changes on this field can be a change in any of the item dimensions like color, site, location, serial number. So, you can log the InventDimID field, but you then also have to do additional work to get a warehouse change.
What is the exact reason that your customer wants to know these changes? I do assumen it is not just for growing the database size logging this type of change. What do they expect to get out of this logging?
Hello Tanyaboon,
Inventory transactions can in general be logged.
However, as you have probably many inventory transactions, you have to be very careful with the fields that you select for logging.
Otherwise you might see performance effects on your system.
MS does in general not recommend logging transaction data.
If you only log the warehouse fields, things might however be ok from a performance perspective.
Before doing that, please test this carefully in a demo/test environment before you apply this in the live system.
Best regards,
Ludwig
Thank you André Arnaud de Calavon and Ludwig Reinhard for the reply.
My client would like to check database log for Warehouse field in Inventory Transactions to know that who change warehouse location. But I tried to setup for InventDim but it's not work.
Hi Tanyaboon,
The TmpInventDim is a temporary table and thus excluded from a database log. What is the purpose for logging the warehouse change?
Hello Tanyaboon,
Why is it that you want to track/log transactional data?
Best regards,
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (