Effects of a change relating to the due date of a purchase and production order

[Former Member]

Hi Experts,

I'm sure we are not the only one strugling with this, that's why I am concerned about this question.

How do you manage changes in the due dates of your orders? Do you know how a change reflects your open sales orders and production?

The reason why I'm asking, because I haven't found anything like this in the system. A few examples:

1. After a MRP run on a manufactured item I get recommendations to buy it's components. Let's say there 5 differents componenets that I have to buy. I turn the recommendtaions to Purchase orders, with due dates of each item's lead time. Life goes on, I can have a demand for another manufactured item, which contains some of the components from the first item. I get recommendations for those also, and turn them into pruchase orders also.

After a few days one of my suppliers indicate that my purchase orders will be delayed by x days. Okay, I change the due dates of the orders, but how do I know how this reflects the production orders of the father items?

I can run MRP again on the fathers with no effect, beacuse I don't get anything, except from maybe a recommendation to order the delayed itmes with an earlier due date, which is wrong.

2. Even in the simpliest "buy-sell" example (i.e.: retailing) I need to know how a delay or a faster delivery related to my purchases affects my sales orders due date.

There could be many examples mentioned, they have the same ending. Of course, maybe in a very simple case you can manually "investigate" your items stock, and "build" / reschedule a new due date to their sales and production orders, but to be honest, that's just not realistic.

I know there is no scheduling in SAP B1, that is why I would like know how you handle these situations. I would be greatfull for some solutions, maybe queries. (primarily we don't want to buy add-on for this).

Any answer would be appreciated.

Thanks in advance,

Ferenc Csépány

[Former Member]

Hi Everyone,

Any ideas for the theme?

I know this is not the easiest question, becasue in B1 there is no link between:

- production order --- produtcion order

- production order --- sales order

- production order --- purchase order

so it's hard to know how a chnage reflects these documents, but I'm sure there is some solution for this.

Waiting for responses.

Thanks,

Ferenc

[kothandaraman_nagarajan]

Hi,

There is relation between production order and sales order,

1. if you create production order directly from sales order through procurement document.

2. If you manually create production order and update SO in production order.

To understand your issue, please give an sample transaction.

Thanks

[Former Member]

Hi Nagarajan,

Thanks for the reply.

I know that there can be a link estabilished between Prod.Or and Sales Or. the way you mentioned. The real problem is that in - standard -  B1 you don't have any connection between Production orders, and neither between Production orders and purchase orders.

What I was trying to say, that this causes difficulties when the due date of a production order or purchase order relating to a lower lever of a product tree changes, and you need to follow these changes.

Example:

I add a sales order for item A0001 with the due date of 2015/07/31, lets say for 5 pcs of it.

Qty is not relevant in this example, I'm just trying to show the problem.

A0001 is a "Make" item with following BOM (It's a multilevel item, containing other "Make" items):

A0001 (Make, Lead time: 1 day)

---B0001 (Buy, Lead time: 1 day)

---C0001 (Make, Lead time: 2 days)

     ----D0001 (Buy, Lead time: 3 days)

     ----E0001 (Make, Lead time: 2 days)

              ---F0001 (Buy, Lead time: 1 day)

              ---G0001 (Buy, Lead time: 4 days)

Let's say none of the above items have stock, so everything is 0. I run MRP on the sales order of A0001, I get recommendations (counting with the lead times), which I add. To be more specific:

- A0001 -  Production order, due date: 2015/07/31

- B0001 - Purchase order, due date: 2015/07/30

- C0001 - Production order, due date: 2015/07/29

- D0001 - Purchase order, due date: 2015/07/26

- E0001 - Production order, due date: 2015/07/27

- F0001 - Purchase order, due date: 2015/07/26

- G0001 - Purchase order, due date: 2015/07/23

Ok, after adding recommendations, I send purchase orders to my suppliers.

Just to be simple, I don't have any other production, and none of the items are included in other BOMs.

Let's say, on 2015/07/20 the supplier of G0001 informs me that - due to some reason - he can't send me G0001 on time (2015/07/23), just on 2015/07/27.

I can't do anything, accept the delay, so i change the due date of G0001's purchase order to 2015/07/27.

BUT, this means that the whole production of A0001 is out of time, it cannot be finished by 2015/07/31.

The problem is that I have to manually "investigate" what this change causes. Maybe in a very simple case (like I wrote above) it can be done, but in a real business case the delayed item can be part of other productions also, not just one item can have a delay, the production can have more levels, etc.

I know this is a hard question to find answer to, because it can have many-many parameters.

I'm trying to gather information about how you - colleagues and experts - handle these situations, is there any better way than the one I wrote.

Hope the example was clear.

Thanks,

Ferenc

[kothandaraman_nagarajan]

Thank you for your clear explanation and sample process.

Let me check and I  will update you.

[Former Member]

Hi Nagarajan,

Thanks in advance.

Ferenc