Notifications
Announcements
No record found.
Hi,
Where can I find inventory item length, width, height info ?
Thanks
*This post is locked for comments
Sounds like you have a modification or Extender giving you some extra fields there in your install of GP.
Apologies, but As this does not sound like standard fields, it is tricky to predict where the backing table for them is.
To be more helpful, you could get a SQL trace set up, edit the field and study the trace to see what got updated in the database, it would be a quick way without guessing.
Tim.
You could use the Item Category Fields in the Item Options Window.
The Labels can be created in the Inventory Control Setup Window, and you can add Values on the fly.
There are 6 Fields available.
Mick
..so to pull it back to the question, if it is those user defined fields Mick mentioned, that you are using, then they will be found in table IV00101 as USCATVLS_1 thru to USCATVLS_6
However you may have extender or a customised solution in place.
Tim
Posted above without reading all the attached posts - the posts prior to mine all lead to the same place as I was thinking, and Tim has the correct names.
Sorry to be redundant.
the dimension data found on the Item Master Card >> Options>>Additional>>Item Additional Options. Could the data be store in the eCommerce tables? Which tables contain eCommerce data?
Good morning - do you know if - as commented by Tim - you have any customization to the GP product? It is difficult to identify the location of a data field if you have customizations. It is not impossible, but it sure helps to know.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
