Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Function of U of M?

Posted on by Microsoft Employee

Hello,

Not sure if I'm asking this in the correct place or if the U of M can even do this but.....

Wondering if you can create a Base Unit of Measure that when you select Qty 1 in a purchase order, it would be received in at a different quantity such as 6. 

Example:

I create a PO for qty 1 of item X but when received, it goes into inventory as 6 of item X.

 

Currently we purchase certain items that are 6 packs but the PO is cut for qty 1. While we ordered 10 of these items we actually have 60 physically on hand which makes things a bit off in inventory. Unfortunately, the easy solution of cutting a po for qty 6 and only get 1 pack of 6 doesn't work for us.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Function of U of M?

    Again thanks Sanjay, gave it a whirl just a bit ago on our test DB and it worked as intended.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Function of U of M?

    Thanks Sanjay. I'll give this a shot on our test DB to make sure it works today but i believe this is what we are looking to do

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Function of U of M?

    In fact, this is the main purpose of having a "unit of measurement schedule" in Dynamics GP. You may have several unit of measurement levels along with conversion rates. This is visible to all supply chain module; Sales, Inventory and Purchasing.

    Let us know if you have any further inquiries or concerns,

  • Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at
    RE: Function of U of M?

    Hi Longlive,

    You would want to create a UOM Schedule as Sanjay shows above.

    ~Thomas Newcomb

    ------------------------------------------

    Microsoft Dynamics GP Support

    ------------------------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Function of U of M?

    Create UOM Schedule  as follows:

    po1.JPG

    Setup   Purchasing Unit of Measure  at item vendor maintenance as follows:

    6378.Untitled.png

    When purchase order is created, the default UOM would be PCK.   (1 PCK)

    po.JPG

    The receiving will also be done in default purchasing UOM PCK.     (1 PCK)

    Inventory will be maintained at Base UOM which would be PCS     ( 6 PCS)

    po1.JPG

    Is this what you are looking for ?

    Cheers!

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans