Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Changing Unit of Measure Schedule

Posted on by 85

What do we need to consider and what are best practices when the unit of measure schedule of an item needs to be changed? To give a specific example, the vendor of a specific item are going to start selling to us in units of 12 instead of units of 24. The base unit of measure and the selling unit of measure are the same and not going to change. The good thing is that we have specific unit of measure schedules for each item and so changing this unit of measure schedule will not affect other items.

*This post is locked for comments

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Changing Unit of Measure Schedule

    Mahmoud is absolutely correct.

    Thanks mahmoud for your brief explanation.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Changing Unit of Measure Schedule

    That's right Soma, but not the full picture.

    When changing unit of measurement schedule for an item, it is correct that it doesn't affect other items (that are not associated with it), and it will absolutely delete your price list and purchasing options as an alert message pops up stating so.

    Although, when changing UOM schedule, the last thing I would think of is the above since it is relatively not quite important. Most importantly, what about transactions history !

    Inventory history transactions recorded in IV30300 holds the historical unit at which it was recorded. When printing a "Historical Stock Status" which retrieves data from IV30300, the unit stored in IV30300 will be compared to the master tables IV40201 and IV40202. Improper modifications of unit of measurement schedule or changing the unit of measurement schedule incorrectly will result with the common (divided by zero) error when printing Historical Stock status.

    the bottom line is ... can I change or modify the UOM schedule ? The answer is simply, Yes, but with limitations.

    Further explanation can be illustrated in the example below;

    Current UOM Schedule: X

      • Base UOM: box
      • Case024 = 24 box

    New UOM Schedule : New X

      • Base UOM: box
      • Case06 = 6 Box
      • Case024 = 24 box

    The modification in the example above is correct and will result with no errors since changes have been well applied considering the historical transactions.

    Another Example;

    Current UOM Schedule: X

      • Base UOM: Each
      • Case = 24 Each

    New UOM Schedule : New X

      • Base UOM: Can
      • Pack = 6 Can
      • Case  = 24 Can

    In this example, the relationships between unit of measurement level is corrupted, and therefore further negative ramifications may result when considering the history.

    You may refer to knowledge base article KB Article ID: 878352

    Your feedback is highly appreciated,

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Changing Unit of Measure Schedule

    Changing Unit of Schedule will not affect other items. But, it will delete the item price list and purchasing option. Then you need to recreate the item price list and default purchasing UofM in purchasing option window.

    Hope this helps!!!

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Changing Unit of Measure Schedule

    Can you please provide us with one of the Unit of measurement schedules "screen shot" you have in order to assist you accordingly on a specific case.

    Your feedback is highly appreciated,

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans