Announcements
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
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
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
Hi
I agree of with what Crispin is pointing out, using table "inventdim" and choose "inventdimid" column as point of reference.
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.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
