What's the difference between inventDim and InventSite

(0) Share

Report

Posted on by ..

2,017

Hi,

So I know that there is a form for inserting to inventSite table.

But what about inventDim when do records get inserted and how?

And what's the difference between these two tables?

I can see that salesTable has a relation with inventSite

But salesLine has a relation with InventDim

All responses (5)

Answers (1)

Sort by

Verified answer

YY Lim 960 on at

Like (1)

Report
Copy link

Link copied!

InventDim is combination of inventory dimension such was location, warehouse, site and etc. In the inventDim table, you would see the field inventSiteId which is the value part of the entire dimension.

For example, your sales order has warehouse W1 and Site S1, it will try to find in your inventDim combination whether you have this, if not, the new InventDimId will be created such as ID001. In this pair inventDim, you can see the inventDimID = ID001, warehouse =W1 and Site= S1.

When you create a new order with exactly the same inventory dimension combination, your next sales order inventDim will have this value ID001 as inventDim store all the dimension you have for the sales order including the site. If you create another sales order with only Site S1, it will try to find the combination, then create ID002 because it doesn't exists.

If you have another order with warehouse W2 and site S1, then a new combination would be created ID003

Ignore other dimension at this example, I am using site and warehouse only. In example above you can see combination below.

InventDimId InventLocationId InventSiteId

ID001 W1 S1

ID002 S1

ID003 W2 S1

I hope this make sense
.. 2,017 on at

Like (0)

Report
Copy link

Link copied!

Hi Yuan,

Thanks for you answer, can you help in answering this question as well which is related

community.dynamics.com/.../how-to-fill-salesline-with-the-correct-inventdim
YY Lim 960 on at

Like (0)

Report
Copy link

Link copied!

Please mark as answered in this post if above answered your question, I replied on the other post too with few lines of codes, hope it helps.
.. 2,017 on at

Like (0)

Report
Copy link

Link copied!

Hi Yuan,

Is the combination only for SiteId and LocationId? If not then what else?
YY Lim 960 on at

Like (0)

Report
Copy link

Link copied!

There are plenty of them, I don't have the table with me, if you look at the field on the InventDim table, I think batchId, wmsLocationId, InventLocationId which is the warehouse, inventSiteId, inventColor, inventSize, Config and etc.