web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Finding table name and...
Supply chain | Supply Chain Management, Commerce
Answered

Finding table name and field for warehouse on SO header or lines in databse log

(0) ShareShare
ReportReport
Posted on by Chourouk Souissi 45

Hello,

I need to track warehouse change on Sales order using databse log

but I cannot find the table name or field name 

Can you please help

Thanks

I have the same question (0)
  • Suggested answer
    Danny Bilodeau Profile Picture
    Danny Bilodeau 4,934 Super User 2026 Season 1 on at

    Hi Chourouk,

    You will find under the <Trade> node.  If you select Show Table names, you will find these:

    pastedimage1665103367797v1.png pastedimage1665103385303v2.png

  • Chourouk Souissi Profile Picture
    Chourouk Souissi 45 on at

    Hello Danny,

    thank you for your reply

    I couldnt find the field related to Warehouse on that table

    Could you please help?

    thanks

  • Verified answer
    Danny Bilodeau Profile Picture
    Danny Bilodeau 4,934 Super User 2026 Season 1 on at

    Hi Chourouk,

    In the Sales Table, the warehouse field name is actually <InventLocationID>.  You can validate in the table itself if you have the table viewer extension for Google.

    In the SalesLine table, you have to look for teh field <InventDimID>.  There is a unique InventDim value for a specific combination of all inventory dimensions (Product, Storage and Tracing).  Any changes in one of these will cause the InventDim to be changed.

    Kind regards,

    Danny

  • Chourouk Souissi Profile Picture
    Chourouk Souissi 45 on at

    Thank you Danny for your reply

    As InventDimID do not show the old and new values for the Warehouse directly I used Sales table (InventLocationId)


Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Mallesh Deshapaga Profile Picture

Mallesh Deshapaga 254

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 188 Super User 2026 Season 1

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 131 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans