Jump to content
Sign in to follow this  

Auto allocate production

Recommended Posts

Hi, I feel I should be able to work this out but it is not happening for me.

We take orders for and manufacture product; we may take orders for 200 units but only manufacture 150. I need to automatically allocate product to a weeks production list.

We have an [color:red]Orders file populating an Items file; a record in the [color:red]Items file may show Qty = 20 Model = A Color = Blue. There will be multiple records linked to each Order.

We also have a [color:red]Production file with a record for each week and the number of each model can be produced in that week; numbers are normally consistent but some weeks have holidays or scheduled maintenance.

I want to create a production list each week with the breakdown of models and colors which equals the production of that week. The trick is some orders will cross the cutoff of production and need to be carried over to the next week [ie 5 being manufactured this week and the remainder next week].

The other requirement which should come from resolving the above is to be able to project when a customer will recieve their order.

I hope that is clear and thanks for any advice


Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.