web
You’re offline. This is a read only version of the page.
close
Skip to main content
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 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
    MahGah 15,529 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.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,045 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,529 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?

  • Guy McKenzie Profile Picture
    Guy McKenzie 1,332 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

  • MMcdowell Profile Picture
    MMcdowell 24 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.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 3,808

#2
Sumit Singh Profile Picture

Sumit Singh 2,554

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,140

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans