Microsoft Dynamics AX (Archived)

Set database log for Journal : pick (TmpInventDim).InventLocationId

(0) Share

Report

Posted on by Tanyaboon

418

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

I have the same question (0)

All responses (6)

Answers (1)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Tanyaboon,

Why is it that you want to track/log transactional data?

Best regards,

Ludwig

Was this reply helpful? Yes No
André Arnaud de Cal... 301,109 Super User 2025 Season 2 on at

Like (0)

Report

Hi Tanyaboon,

The TmpInventDim is a temporary table and thus excluded from a database log. What is the purpose for logging the warehouse change?

Was this reply helpful? Yes No
Tanyaboon 418 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Tanyaboon 418 on at

Like (0)

Report

Thank you very much Ludwig Reinhard

Could you advise me what table and module for this form ?

So I can testing as you advised.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,109 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No