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 :
Microsoft Dynamics NAV (Archived)

Lot Sizes for Production Orders (MRP)

(0) ShareShare
ReportReport
Posted on by

Hi, I'd like to check if the standard NAV is able to fulfil the following scenario.

MRP: My planners need NAV to break down the suggested inventory to build to be based off an item's Lot Size. For example: Item A has a lot size of 500... so if there is an order of 2800 items, I need the system to recommend 6 production orders. Or at the very least round-up the recommendation to 3000.

Appreciate any advice.

*This post is locked for comments

I have the same question (0)
  • NavTech Profile Picture
    2,390 on at
    RE: Lot Sizes for Production Orders (MRP)

    Yes There is Lot Size fields on item table .Use that.

  • Verified answer
    Community Member Profile Picture
    on at
    RE: Lot Sizes for Production Orders (MRP)

    Hi,

    you can use the field Maximum order size and set it to 500. If the requirement exceeds 500 (i.e. 700) , MRP will propose you to create 2 orders, one for 500 and one for 200.

    Additionally, you can use the minimum order size and set it to 500, to round up de the last one to 500 also.

    You could also use the field order multiple and set it to 500 (without setting the Min and Max). in this case, MRP will propose an order of 1000, because the proposed quantity will Always be a multiple of 500.

    My advice is Always to work in steps when learning these parameters. Start by using one parameter, investigate the result, and then you can start finetuning with the other parameters.

    I hope this helps you.

    Francis

  • Community Member Profile Picture
    on at
    RE: Lot Sizes for Production Orders (MRP)

    Hi Francis, thanks for explaining how Lot Sizes work. I managed to fulfil my user's requirements. Just a little curious though, what happens when the Production Bom cascades down? Say for example Product A needs item B to be built and item B needs item C to be built. Will the Lot Size also work in this instance?

  • Suggested answer
    Saurabh Shah Profile Picture
    4,560 on at
    RE: Lot Sizes for Production Orders (MRP)

    You need to set the Lot size on respective item card accordingly.

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Lot Sizes for Production Orders (MRP)

    Hi,

    yes it will, as long as you use the planning worksheet. The planning worksheet calculates all levels of your items.

    Francis

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 > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans