• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2284
  • Last Modified:

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.
0
jnikodym
Asked:
jnikodym
1 Solution
 
Victoria YudinCommented:
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now