I sell a product that has many standard lengths. ( 1 to Many)
I have a table for products e.g (48.3x3.2)
I have a table for the standard lengths stocked for each product. e.g (7500 or 10000 or 12000 or 15000mm)
a std order looks for example 48.3x3.2 / 10 lengths / 10000mm /price / del date/ notes
I have a problem and I cannot get my head around it and I need your help.
If.. a customer orders a non standard length it has to be cut from a standard length and the off cut must go back in to the stock profile.
I am not sure where to start. When entering an order for standard lengths I have a OrderForm and a subOrderLines.
I need to show the cut lengths required and the material it is going to be cut from as well as showing the off cut that is going to be returned to stock and from this I need to raise an invoice for the material despatched.
Any Idea would be greatfully received.
I have a table for products e.g (48.3x3.2)
I have a table for the standard lengths stocked for each product. e.g (7500 or 10000 or 12000 or 15000mm)
a std order looks for example 48.3x3.2 / 10 lengths / 10000mm /price / del date/ notes
I have a problem and I cannot get my head around it and I need your help.
If.. a customer orders a non standard length it has to be cut from a standard length and the off cut must go back in to the stock profile.
I am not sure where to start. When entering an order for standard lengths I have a OrderForm and a subOrderLines.
I need to show the cut lengths required and the material it is going to be cut from as well as showing the off cut that is going to be returned to stock and from this I need to raise an invoice for the material despatched.
Any Idea would be greatfully received.
Last edited: