Skip to main content

Notifications

Small and medium business | Business Central, N...
Unanswered

Inhouse Production

Posted on by 20

Hello Community,

I want every operation consume quantity and output quantity in inhouse production. 

suppose i have define 4 operation in routing of FG so how can i receive consume quantity and output quantity after 1st operation (output should be WIP quantity).Is it possible?

  • Shivani Kumari Profile Picture
    Shivani Kumari 20 on at
    RE: Inhouse Production

    Actually i want control inventory of WIP so that i should know how many quantity store in WIP (after 1st operation).

  • Shivani Kumari Profile Picture
    Shivani Kumari 20 on at
    RE: Inhouse Production

    I have only two item code FG and Raw material. without WIP location code can i process this.

  • Shivani Kumari Profile Picture
    Shivani Kumari 20 on at
    RE: Inhouse Production

    I have only two item code FG item code and Raw Material item code. i have not any WIP location code. but i want when i put the quantity in first operation (suppose i have 3 operation) then it's consumption is showing in item ledger entries and value entries table.

  • Jun Wang Profile Picture
    Jun Wang 7,427 Super User 2024 Season 2 on at
    RE: Inhouse Production

    agree with Kaspars that out of box, the consumption and output happen in the same location which is why user needs to move components to the designed bins at the production location.

    you need to explain why you need the above desired behavior and there might be other options to consider.

    one instance of consumption at different locations is through subcontracting, which might not fit your scenario

    Or you might consider to separate the routings into 2 parts. part 1 builds the subcomponent at location A, then user moves the subcomponent to location B to build the final product.

  • Ben Baxter Profile Picture
    Ben Baxter 4,890 Super User 2024 Season 2 on at
    RE: Inhouse Production

    This is still possible.  The need for Item Ledgers complicates the setup a little, but still very possible.

    Your WIP output will need to be setup as individual Items, each with their own BOM and Routing.  You will need Locations defined for your FG Location, WIP Location, and potentially a Raw Material Location, and corresponding SKU records for the products that will be either Output or Consumed from those Locations.  For your FG Location you will need to define "Components at Location" on the Work Center so it knows to consume from your WIP Location rather than the FG Location.

    Each WIP Item is a component of the upper level, such as FG consumes WIP 3, which consumes WIP 2, which consumes WIP 1, which consumes the Raw Materials.  You will likely end up with multiple Production Orders due to the different Locations, but I would still recommend "Make-to-Order" Manufacturing Policy on both the WIP and FG Items to group as much as possible onto a single Production Order (if it makes sense to do so).

    Utilizing the Backflush Flushing Method on the Raw Materials and WIP Items, as well as Routing Link Codes on the Operations and BOMs should allow the consumption to be fairly automated, as long as you process your Output at each level first.

    I would say this can be a fairly tricky setup to get correct on all levels, so I would encourage you to reach out to your Business Central partner to work through the configuration.

  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,907 Super User 2024 Season 2 on at
    RE: Inhouse Production

    Feels like then You would need a customization, as in standard You can only provide 1 location form which all items are consumed for manufacturing (in Manufacturing Setup).

    I would then advise to create a process, that Transfers all required items to the WIP location (either on , and in Manufacturing Setup provide this WIP location as default for all manufacturing - but there might be another solution that suits your exact needs. You should talk this over with Your partner/developer.

  • Shivani Kumari Profile Picture
    Shivani Kumari 20 on at
    RE: Inhouse Production

    Thankyou for answer me.

    But if i put routing link for each operation then its consume quantity each time from raw material but i want first operation consume quantity from raw material and quantity up on WIP Location (i have not WIP Code) and in the 2nd operation it's consume from WIP location and also up in WIP location then in the last operation consume from WIP Location and output goes to the FG location (FG Item code). and i want all operations consumption and output visible in the item ledger entries and value entries table.

  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,907 Super User 2024 Season 2 on at
    RE: Inhouse Production

    Yes it is possible.

    In Routing lines You would need to add Routing Links, and then in Production BOM for each consumable You add the Routing Link (that links to specific operation).

    Then Items are consumed after each operation, instead of only after last operation.

    Watch this short video:
    Using Routing Link Codes to postpone the need for components - Dynamics 365 Business Central (usedynamics.com)

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans