Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Validating the UOM

Posted on by 900

Is the IV40202 Table the right place to find all the UOM's for an item?

Thanks,

Q

*This post is locked for comments

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Re: Re: Validating the UOM

    That's what I would do.

  • Q Profile Picture
    Q 900 on at
    Re: Re: Validating the UOM

    ok, so I should query the table IV00106 and exclude UMPUROPT =1? Rather than using IV00101 and IV40202 ?

     

    I appreciate your answers

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Validating the UOM

    Yes but keep in mind that this table will have ALL of the UOM relationships for all items.  In the Item Master (IV00101) is a field that specified the UOM Schedule assigned to the item.  Then using this table you can find the possible UOMs that are part of the assigned schedule.

     However, some items may be assigned to a UOM schedule that includes inappropriate UOMs.  In the table IV00106, a copy of the UOMs is created already tied to each inventory item.  In this table is a field called UMPUROPT that is used to restrict the use of selected UOMs.  1 means this UOM is not authorized for use for this item.  2 indicates that only whole numbers are to be used, fractional quantities cannot be ordered.  3 indicates fractional quantities may be ordered.

     So, while the table you listed has the definitions of the UOM Schedules, IV00106 has the UOMs assigned to items and you have a way of eliminating any the firm does not want to use.

     Stuff like this is found in our Information Flow and Posting manual, available from www.AccoladePublications.com

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans