Solved

Dynamics GP - Inventory Item Base Unit of Measure

Posted on 2011-02-15
1
2,098 Views
Last Modified: 2012-06-27
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
Comment
Question by:jnikodym
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 18

Accepted Solution

by:
Victoria Yudin earned 500 total points
ID: 34898536
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question