Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / UOM conversion - Sales...
Small and medium business | Business Central, N...
Answered

UOM conversion - Sales forecast and planning worksheet

(0) ShareShare
ReportReport
Posted on by MMcdowell 20

Hi all,

I have Item A, with a base unit of measure in CASE, there's also each

Case  = 1

EA = 1575

I've created a forecast entry as seen below. It's required that the forecast is entered in EA, so 1575 is entered into the field "Forecast quantity base". Then forecast quantity auto-fils to 1 (which is good).

pastedimage1643916029218v1.png

Then I go to run the planning worksheet against this forecast, and it populates an action message with unit of measure as CASE, but using the 1575, where I would expect to see 1 case as the suggestion.

pastedimage1643916208651v2.png

I can't figure out why the MRP engine isn't converting. Am I missing something?

  • MMcdowell Profile Picture
    MMcdowell 20 on at
    RE: UOM conversion - Sales forecast and planning worksheet

    Hi Inge, yes that was what I was missing. Thanks so much. I tried to respond earlier but I keep getting an error when replying.

  • Guy McKenzie Profile Picture
    Guy McKenzie 1,330 on at
    RE: UOM conversion - Sales forecast and planning worksheet

    As others are alluding to…

    Your each represents 1575 cases if what you have described is how you have actually configured BC.

    If there are 1,575 eaches in one case, the qty per on the each should be 1/1575

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,445 on at
    RE: UOM conversion - Sales forecast and planning worksheet

    Hi

    As Inge mention can you please post the picture of UOM conversion page? I mean for EA do you have 1/1575 case or do you have 1575?

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,029 Moderator on at
    RE: UOM conversion - Sales forecast and planning worksheet

    How is your Item unit of measure set up is the EA defined as 1/1575 of a case?

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,445 on at
    RE: UOM conversion - Sales forecast and planning worksheet

    Hi

    Maybe I am missing something. Usually Base Unit of Measure is the smallest unit of measure that you keep in inventory. Hence, in your case EA should be Base UOM and then Case will be UOM. But you may have a good business reason for it.

    For test, in demand can you populate 1 case and try to planning worksheet?

    I will try to see if I can replicate the same scenario as well.

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June 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 > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans