Allocating the production orders to the Sales order lines

(1) Share

Report

Posted on by Adineh Negahdari

807

Hi,

We need some help for designing a solution for the below requirement.

Consider a Make-to-stock fashion industry. We create production orders (coming from firming planned orders, created by MRP run for the item forecast). Then we create sales orders and fixe the delivery date.

**Now we need to find a best solution for finding and allocating the best fulfilment (on-hand stock or production order) for the sales lines as per the sales delivery date. (Allocating means reserving, marking, or any other way that we are sure we are not counting on a positive stock twice.)

1. We can not use shipping date control reservation in Item model Group be cause we are using Advanced WM.

2. we ca not use manual marking against sales order, because we are using standard cost.

I have the same question (0)

All responses (10)

Answers (0)

Aparisi82 2,190 on at

Like (0)

Report
Copy link

Link copied!

If you are using MRP and including open sales orders on the demand , MRP would reduce the forecast and avoid double-counting.

Can you confirm that you would have sales orders in W1,W2 whilst producing on the same weeks from the forecast?

Was this reply helpful? Yes No
Adineh Negahdari 807 on at

Like (0)

Report
Copy link

Link copied!

Dear Alessandro,

Thanks for your answer.

The requirement is allocating the production orders to the sales order so that we are sure we have fulfilled that sales order in the maximum sales coverage.

Yes, MRP would reduce the forecast, but we want also the production orders be somehow mapped to the sales order as per their delivery date.

we would have sales orders in W1,W2 whilst producing on the same weeks from the forecast, But we may not fulfill those Sale order form the productions. may be from Stock!

BR,

Was this reply helpful? Yes No
Aparisi82 2,190 on at

Like (1)

Report
Copy link

Link copied!

I am not sure I understand the requirement here but if you want to hard-link SO with PB one thing you can do is create a work order from the sales order line.

This will create a work order marking the sales line with the work order line ( even if using STD cost).

Once the PB is placed, next MRP run would take that PB into account.

You do this from the sales order line/ Product Supply/ Work order or Batch order.

Was this reply helpful? Yes No
Adineh Negahdari 807 on at

Like (0)

Report
Copy link

Link copied!

Thanks. the problem is the production order is first created! sales order are the next!

Was this reply helpful? Yes No
Aparisi82 2,190 on at

Like (1)

Report
Copy link

Link copied!

Sure, but in the make-to-stock model the assumption is that you produce on forecast( plus potential SO reduction) so that once the stock is ready can be allocated to SOs so you should not be linking SOs to PBs as you would have already produced the stock.

E.G.

when in W2 you would have already all the stock as already produce via PBs generated by Forecast in the previous production weeks , so you would not naturally have any links to SOs and PBs and reserve stock based on delivery date ascending..

Was this reply helpful? Yes No
Juan Montoya 15 on at

Like (0)

Report
Copy link

Link copied!

Dear Adineh, I wanted to see if you were able to get a solution on your allocation process, In our company, we're moving to D365 F&O and we have the same questions about allocation as you do, so I wanted to see how you resolved it

thanks

Was this reply helpful? Yes No
Adineh Negahdari 807 on at

Like (0)

Report
Copy link

Link copied!

Dear Juan,

Unfortunately not a standard one.

Regards,

Adineh

Was this reply helpful? Yes No
Weaveriski 23,620 Moderator on at

Like (1)

Report
Copy link

Link copied!

You could write a report that does this from the net requirements etc. I imagine from the response from Adineh Negahdari that they wrote a routine to link them to give them visibility. The challenge with this, a bit like reservations in FO is the fluid nature of the supply chain and what you then have to do when the picture changes to rebalance the supply to the demand. I would go down the report route initially, but it would be interesting to hear more on how this was solved and whether this is how they would approach it today with hindsight!

Was this reply helpful? Yes No
Juan Montoya 15 on at

Like (0)

Report
Copy link

Link copied!

Dear Adineh,

Would you be able to provide more details, I would want to hear more about how this was solved and whether the Report routine is how you approached it

Was this reply helpful? Yes No
Adineh Negahdari 807 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Actually as it has been said above, creating a link seems to be a little bit complicated. On the other hand the report is not enough to garantee the delivery.

So we did dome developments simultaneously:

1. We create a function on the slaes order creation so that the user can put the qty just as per the availability stock, and the delivery date is choses automatically as per the date in which the stock is availble. Still, there is no link between the sale sline and the availabe stock. but at least we are sure we are ordering as per the avaible stock qty in the correct date and not more.

2. We put the control on the sale sorder confirmation not to confirm orders without reservation.

3. we create the report to show this data so that as time passes and we have chnages on th eorders, the overbooked lines are shown.

Thanks

Adineh

Was this reply helpful? Yes No