Dynamics GP - Inventory Item Base Unit of Measure

I am looing for the SQL table that stores the Base Unit of Measure for an inventory item.  I don't want the unit of measure schedule id or the selling unit of measure.  The Quanties/Sites window shows a Base U of M.  I need the table that has that info for that item.
jnikodymAsked:
Who is Participating?
 
Victoria YudinConnect With a Mentor Owner / Dynamics GP ConsultantCommented:
The base unit of measure is always the same for all items with the same UofM Schedule, because the base is defined as part of the UofM Schedule setup.  So you do want the unit of measure schedule for this - IV40201.

Here is an example of a view I posted using this table to show the base U of M for items: http://victoriayudin.com/2009/12/04/sql-view-for-inventory-items-and-dates/.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.