You’re offline. This is a read only version of the page.
Announcements
581
Can anyone tell me what fields do I join to the InventTable in order to link the inventory dimensions?
Steve
*This post is locked for comments
Hi Steve!
The question is "How to link tables from the InventTable to get the Product Category"
Inside the topic you're wrote "Can anyone tell me what fields do I join to the InventTable in order to link the inventory dimensions?". Confuses a little...
BTW, if you're mean the Product Category (EcoResProductCategory), just take a look at Relation node of the table and you can find what you need
InventTable doesn't have direct link to EcoResProductCategory, but EcoResProduct has.
Hope this will help you.
I agree of with what Crispin is pointing out, using table "inventdim" and choose "inventdimid" column as point of reference.
Hi
The product Categories. I am trying to write a report and to sort it by Product Category. I need to use the InventTable table to see what fields/tables I join/fetch in order to get the category
Hi Ludwig
The product Categories. I am trying to write a report and to sort it by Product Category. I need to use the InventTable table to see what fields/tables I join/fetch in order to get the category
Hello Steve,
Do you refer to the storage/tracking dimensions or the product categories?
You header and description do not seem to match.
Would be great if you could clarify what you try to achieve.
Many thanks and best regards,
Ludwig
#1
André Arnaud de Cal...
294,241
Super User 2025 Season 1
#2
Martin Dráb
232,982
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
