Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / manufacturing............
Microsoft Dynamics GP (Archived)

manufacturing..........best course of action

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello Everyone,

I am looking for assistance for running our process through GP.  We have been using a manufacturing order to combine item "A" and item "B" to end up with finished sales item "C".  We now need to further process item "C" before we can sell it.  The only idea we can come up with is to use item "C" as a component of a new item and do an assembly, another MO, or something else to make this change.

  A couple of restrictions are:  we use lot numbers for tracking, we use bins,  we need to receive the "C" on the MO to remove the actual quantities of the components from inventory.

Any comments or suggestions would be very much appreciated. 

*This post is locked for comments

  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at
    RE: manufacturing..........best course of action

    The Mfg Quick MO would be a quick 'little transactional OH' way to process also.   And BOM's are only in 1 place instead of 2.  Otherwise, I don't have any other suggestions that have not already been brought up.

    Dan Liebl, CMA CPIM | Senior Consultant | OTT, Inc.| DLiebl@OTT-inc.com

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,220 Super User 2024 Season 2 on at
    RE: manufacturing..........best course of action

    Larry, could you use an Inventory BOM (Assembly Transaction) to convert C to D?  It would require a little less transactional overhead than an MO, I think.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: manufacturing..........best course of action

    No, this won't work for me......please see my last post.  Thanks for your input.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: manufacturing..........best course of action

    Thanks to everyone for your insight and suggestions..........I have a lot of testing to do!  Maybe all I need to do is change a setting in manufacturing.

    I used the A,B,C,D analogy to simplify but here is the specific reason for our need to close the MO and get the component out of active inventory.  When we release our MO, the components are allocated.  Our components are based upon theoretical usage ( they are actually paints).  When job is completed, we go in and change the theoretical amount to the actual amount used and do a receipt for the finished item "C".   When the usage is less than the theoretical amount that was issued to the MO, that difference sits in the MO until it is closed out.  This messes up our actual inventory.

    This wouldn't be a big problem if I could take item "C" and sell it the way it is (just close the MO in a timely fashion), but item "C"  is going to change after I reprocess it which could take a couple of weeks.

    Two other things, our BOM's are simple and Item "C" does not always get reprocessed.

    I hope this is a bit clearer to understand.    

    Once again thanks!

  • Bron Profile Picture
    Bron 2 on at
    RE: manufacturing..........best course of action

    Hi Larry -

    Does Item C always get heat treated?

    If you want to 'consume' Items A and B before Item C comes back from heat treater - you could use a mfg issue transaction (component transaction entry screen) - that would alleviate a second MO.

    The routing for Item C would be changed - add a sequence for outsourcing.

    When the assembled parts come back from Heat treater - receive against the outsourced PO and close MO - which puts C into inventory with the cost of the putsourced PO.

    Alternatively - if BOM's are simple - your second MO could be an MO fpr Item C which has a pick list of Item C (an item can be part of itself in GP mfg) - you could use BINS or Lot Numbers to easily identify what qty of item C has been Heat treated........just thinking out of the box.

    Have fun - let us know how you decide to handle. Making a good copy of LIVE database into your TEST database really comes in handy in situations like this. Best practice is to have a 'sandbox' to tinker with before making process changes.  

  • Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: manufacturing..........best course of action

    Why wouldn't you create Item D as the intermediate (unfinished C) and leave the C (finished) Item alone?

    A+B=D

    D+processing=C

    Creating a new finished good number may not go well with your customers or customer service.

    I am still not understanding your statement from your initial Post:

    "... and I need to complete the removal of the components from the MO long  before I complete the reprocessing of "C"."

    Are you backflushing A and B?  A and B should be removed from active Inventory when you Issue them to the MO (and placed in WIP).

    Tim

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: manufacturing..........best course of action

    Hi Babu,   That is the only way I came up with but I thought someone might have a better idea than me.  I was trying to avoid another MO for the item.  

    Do you know if I can have a sales order trigger a MO or two MO's in order to make item "C" and than to make item "D" from item "C" provided item "C" is not in stock?

    Thanks for your help!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: manufacturing..........best course of action

    Hi Larry,

    So can you create a MO for item "D" and use "C" as a component on that and use outsource PO for the heat treat and receive the quantity of "D" and invoice it.  If you don't want capture the cost of heat treat leave the PO as zero cost.  

    Thanks,

    Babu

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: manufacturing..........best course of action

    The problem is there is a time lapse of a few weeks between completing "C" and the reprocessing of "C", and I need to complete the removal of the components from the MO long  before I complete the reprocessing of "C".  There are no other materials consumed.  We end up taking the finished quantity of "C" and reworking it (heat treating it) and ending up with a different quantity of "C".

    To summarize....The final quantity of "C" is what we invoice off of and the original quantity form the work order is what our costs are based off of.

  • Tim Foster Profile Picture
    Tim Foster 8,515 on at
    RE: manufacturing..........best course of action

    If you're just "processing" C further, wouldn't that just be another routing step?

    Does the "processing" somehow consume other materials (outside of A and B)?

    TIm

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans