web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

UOM conversion - Sales forecast and planning worksheet

(0) ShareShare
ReportReport
Posted on by 24

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?

I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    15,529 on at

    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.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,111 Moderator on at

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

  • Suggested answer
    MahGah Profile Picture
    15,529 on at

    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?

  • Guy McKenzie Profile Picture
    1,336 on at

    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

  • MMcdowell Profile Picture
    24 on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,126

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 744 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 674 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans