Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Generate Shop Orders from Gen 1 1

Status
Not open for further replies.

fabyouless

Technical User
Mar 26, 2007
5
US
Progression version 7.6.300b

Each night, MRP What If Analysis is run right after Regenerate Material Plan. Gen 1 does not include the Forecast Orders that Gen 0 does. I have a Buyer/Planner who requires the CP orders from Gen 1 to be used for generation. Is this something Macola can do inherently?

Currently, I do a query into Excel of the Gen 1 CP orders and match the Gen 0 orders while changing the Order Quantity, Release Date and Due Date as necessary.

Thanks for any assistance and insight.
BLS
 
Tek-tips does not charge by the word, please elaborate.

What are you currently getting -- show us some sample data -- and what is it you desire to get?

Also your comment "to be used for generation". Generation of what? POs, POP orders, SFC Order?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry
 
I have never tried what you are trying but I doubt that you can generate anything from a "what if". By its very nature the "what if" is an analysis tool not an action tool. There is no place in the selection criterion to select a "what if" while processing the output.

My rule in MRP is, if you don't like the results that MRP recommend then you haven't defined the rules properly.

Why do you not have the consume forecast set to "customer orders” on the items that you only want the customer orders.

By doing what you are you are kidding yourself as any item that is not a LLC of zero, you are procuring an incorrect amount because they are based on the real generation but the saleable items are not. I bet your exception messages are a mess as well as your inventory is out of balance and probably inflated. to support the forecast and the customers orders.

It sounds like you are trying to purchase the raw material based on your forecast but make the finished goods based on actual sales orders. This calls for a greater understanding of the process than this forum allows, this is true consulting and I would need a lot more information to make a valuable recommendation.


Steve Henley
Trianglepartners.com
Exact Software consulting, sales and implementations.

If the only tool you can use is a hammer then all your problems look like nails.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top