Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Changing Unit of Measure Schedule

(0) ShareShare
ReportReport
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
    24,410 on at
    RE: Changing Unit of Measure Schedule

    Mahmoud is absolutely correct.

    Thanks mahmoud for your brief explanation.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    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
    24,410 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
    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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans