Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

MTO & Inventory availability

(0) ShareShare
ReportReport
Posted on by 500

Hi , I use NAV 2009 R2.
When Manufacturing policy is set it as MTO in SKU cards, I want to consider available stock also of that items. Is it possible in NAV. Because when manufacturing policy =MTO it will not check available inventory.
Thanks for help.!

*This post is locked for comments

  • Suggested answer
    Aleksandar Totovic Profile Picture
    16,765 on at
    RE: MTO & Inventory availability

    I try to use NAV standard as much as possible. SometimesI get specific requirements and I made customizations. I like to make new functionality for client specific requirement. If I change the standard, maybe he will want to use standard few years later and I could be in problem. I had similar requirements, but as I said, I made new functionality for it.

    Maybe you can try with Order Planning. I don't know all your requirements, but you can try it. Problem maybe is because Order Planning use planning level-by-level.

  • Suggested answer
    Tanya Susan Profile Picture
    500 on at
    RE: MTO & Inventory availability

    Because when i use Manufacturing policy=MTO, system will plan multilevel production orders sequentially (level 1 finish only level2 start like that)

    My client want that requirement. But it wont happen when its Maf.Policy=MTS,

    Client want to check the available inventory when run planning worksheet. that is why i asked to do this this customization.  

    Another advantage of MTO is when i change the due date in first level item it will re-plan whole lines related to main order. If i use MTS that functionality cannot use. It will re-plan selected line only .

    NOTE:- Have you met that kind of situation when implementations. (check the on hand inventory at production planning to multilevel using MTO)

    ******Thanks for the help******

  • Aleksandar Totovic Profile Picture
    16,765 on at
    RE: MTO & Inventory availability

    'Everthing' can be customized, but you need to be very careful with this. You need to test many scenarios.

  • Suggested answer
    Tanya Susan Profile Picture
    500 on at
    RE: MTO & Inventory availability

    Can we customize that option in NAV,

    Check the on hand inventory in item when manufacturing policy=MTO. Even for multiple BOM lines.

  • Verified answer
    Aleksandar Totovic Profile Picture
    16,765 on at
    RE: MTO & Inventory availability

    I looked at your example. Unfortunately, MTS considers just the first level of the BOM and if you have that examples, the everything is OK. If you want to use multilevel BOMs, you have to use MTO. MTO explodes the complete BOM, for each level in the BOM structure where that item's manufacturing policy has also been defined as MTO. This means that if you want to make multilevel production orders in planning, then the manufacturing policy for the parent and components items, must be MTO. It can be used with Lot-for-lot reordering policy, but it can not include inventory.

  • Suggested answer
    Tanya Susan Profile Picture
    500 on at
    RE: MTO & Inventory availability

    Hi Thanks for the reply,

    Scenario; this is the detail scenario,

    I use Dynamics NAV 2009 R2.

    1. Item X, is a FG item.  Its first level BOM is item Y. Item Y is a semi finish item. Item Y BOM called as item Z
    2. a.      Item X=production item
    3. b.      Item Y=Production item
    4. c.       Item Z=Purchase item.

     Item X --> Item Y -> Item Z

    1. SKU cards of those items, (Manufacturing policey=MTS)

    Item No.

    Replenishment System

    Transfer-from Code

    Location Code

    Reordering Policy

    Include Inventory

    Manufacturing Policy

    Inventory

    ITEM-X

    Transfer

    WIP

    DISPATCH

    Lot-for-Lot

    Yes

    Make-to-Stock

    0

    ITEM-X

    Prod. Order

     

    WIP

    Lot-for-Lot

    Yes

    Make-to-Stock

    0

    ITEM-Y

    Prod. Order

     

    WIP

    Lot-for-Lot

    Yes

    Make-to-Stock

    0

    ITEM-Z

    Purchase

     

    RM-STORE

    Lot-for-Lot

    Yes

    Make-to-Stock

    0

    ITEM-Z

    Transfer

    RM-STORE

    WIP

    Lot-for-Lot

    Yes

    Make-to-Stock

    0

    1. I put sales order for 100 of item X. 
    2. When run planning worksheet it was calculated as follows,

    Line No.

    No.

    Action Message

    Accept Action Message

    Due Date

    Starting Date-Time

    Ending Date-Time

    Low-Level Code

    Description

    Transfer-from Code

    Location Code

    Quantity

    Ref. Order Type

    Ref. Order No.

    Ref. Order Status

    10000

    ITEM-X

    New

    Yes

    9/30/2013

    9/30/2013 8:00

    9/30/2013 7:59

    0

    Item-X

    WIP

    DISPATCH

    100

    Transfer

     

     

    20000

    ITEM-X

    New

    Yes

    9/30/2013

    9/30/2013 2:58

    9/30/2013 7:59

    0

    Item-X

     

    WIP

    100

    Prod. Order

    PLN-OR-00337

    Planned

    30000

    ITEM-Y

    New

    Yes

    9/30/2013

    9/30/2013 1:19

    9/30/2013 7:59

    1

    Item Y

     

    WIP

    100

    Prod. Order

    PLN-OR-00338

    Planned

    40000

    ITEM-Z

    New

    Yes

    9/30/2013

    9/30/2013 8:00

    9/30/2013 7:59

    2

    Item- Z

    RM-STORE

    WIP

    200

    Transfer

     

     

    50000

    ITEM-Z

    New

    Yes

    9/30/2013

    9/30/2013 8:00

    9/30/2013 7:59

    2

    Item- Z

     

    RM-STORE

    200

    Purchase

     

     

    1. Here can you see yellow color one. It is not sequenced. It start based on the rout & end normal production end time.
    2. Production start time 8.00.00 AM
    3. Production end time 7.59.59.AM  (Manufacturing setup)
      1. This was happened because of manufacturing policy=MTS, If I change manufacturing policy as MTO, sequence will be align as follows,

    Line No.

    No.

    Action Message

    Accept Action Message

    Due Date

    Starting Date-Time

    Ending Date-Time

    Low-Level Code

    Description

    Transfer-from Code

    Location Code

    Quantity

    Ref. Order Type

    Ref. Order No.

    Ref. Order Status

    10000

    ITEM-X

    New

    Yes

    9/30/2013

    9/30/2013 8:00

    9/30/2013 7:59

    0

    Item-X

    WIP

    DISPATCH

    100

    Transfer

     

     

    20000

    ITEM-X

    New

    Yes

    9/30/2013

    9/30/2013 2:58

    9/30/2013 7:59

    0

    Item-X

     

    WIP

    100

    Prod. Order

    PLN-OR-00339

    Planned

    30000

    ITEM-Y

    New

    No

    9/30/2013

    9/29/2013 20:18

    9/30/2013 2:58

    1

    Item Y

     

    WIP

    100

    Prod. Order

    PLN-OR-00339

    Planned

    40000

    ITEM-Z

    New

    No

    9/29/2013

    9/29/2013 8:00

    9/29/2013 7:59

    2

    Item- Z

    RM-STORE

    WIP

    200

    Transfer

     

     

    50000

    ITEM-Z

    New

    No

    9/29/2013

    9/29/2013 8:00

    9/29/2013 7:59

    2

    Item- Z

     

    RM-STORE

    200

    Purchase

     

     

    1.  
    2. But when Manufacturing policy=MTS it will check inventory on hand. Assume I have 30 of item Y. Then system will say you need to produce 70 only.
    3. Manufacturing policy=MTO, System won’t check inventory on hand?
    4. My requirement is,
    5. Rout lines need be align as manufacturing policy=MTO
    6. Inventory on hand need to be check when run MRP

    If you want any further information please let me know. Thanks again for the help.

  • Suggested answer
    Tanya Susan Profile Picture
    500 on at
    RE: MTO & Inventory availability

    I sent mail to you. thank you.

  • Suggested answer
    Aleksandar Totovic Profile Picture
    16,765 on at
    RE: MTO & Inventory availability

    If you want to use inventory availability on other SKUs, you need to set policy as MTS on other SKUs. If you want it on this same SKU, this is not possible. In this case, better solution is to use policy MTS on all SKUs. If I'm not understand good, please give us better description.

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

Announcing the Engage with the Community forum!

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Microsoft Dynamics NAV (Archived)

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2

#1
mmv Profile Picture

mmv 2

#1
Amol Salvi Profile Picture

Amol Salvi 2

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans