MRP purchased/consigned inventory

[rsbyers]

Hello, I have what I think is a sticky MRP issue. I have an item that is a component of a BOM. We are now going to acquire this item, stock and ship as a FG item as well as continue to include as a component of the BOM. There is a kicker… When this item is in FG, the item is acquired as a consigned item with no standard cost, while the component item will continued to be purchased, owned and valued in inventory with a standard cost. These items are ordered on separate PO’s from the same vendor and are the same part number. These items will be carried in two different Macola Locations and NEVER co-mingled.

Question: Is there any way to set up Macola so that the Computer Planned Order reflects the requirements specific to both the purchased component item and consigned FG item?

Any help greatly appreciated!

 

[dgillz]

If both item location records have an order policy code, and both locations are MRP locations, then MRP will create CPOs. However it will create a different one for each MRP location.

Is there some reason why you want the total requirement on one CPO?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[rsbyers]

Thanks, I appreciate the quick response. I'm a first time poster here. Well actually I don't want to combine these into one CPO. If the CPO for each location is only considering demand and supply for that location, then that is exactly what i'm looking for.

 

[dgillz]

No problem then. Just make sure that both item-location records are properly defined and both locations are MRP locations.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[MacolaHelp]

One caveat: the customer order for the FG that you are purchasing as a consigned item from a different stocking location must have that location on the sales order to create the demand to generate the CPO.

In addition, I have had some situations where the costed bill roll up is blowing through a purchased part & picking up the component costs, but I think your post indicates that, if used in a higher level FG, you are building the FG subassembly, therefore using component inventory with a cost. If so, you are fine. Just be sure your BOM for the higher level FG uses the location code of the built subassembly, particularly if the item master record defaults to the purchased/consigned location.

One clarification: order policy code is at the item master level, not the item location level.

 

[rsbyers]

Thanks for the help. I'll be testing today. I'll be back to provide the sucess story!

 

[TLeaders]

Another thought, because you want two separate orders you will probably need to run the regen twice. Once for the location that you are carrying with cost and a second time for the consignment inventory. For the second run you can change the locations at run time or use one of the “What-If” occurrences.
If you run the regen for both locations at the same time the regen will combine this into a single computer planned order.

Good luck with your test.
Tom

 

[dgillz]

I am pretty sure that if you have 2 item location records and both location are MRP locations, one regen will create 2 CPOs.

I am not able to test this today but I will later this week and post my results.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[rsbyers]

I really want to just run MRP once and generate the two CPO's, and avoid running two regens or 2 "what-ifs" I'm testing today. Will let you know.

 

[rsbyers]

Finished my testing. ERP created a single CPO with no Location noted and included all requirements and replinishments. My solution looks to be regen MRP for Location A (excluding Location B). Then run What If Analysis 1 for Location B (excluding Location A). Macola then created the appropriatly calculated CPO's for each location.

Thanks for all your input. And Merry Christmas!