Allocation production order to delivery note?

[Former Member]

Hello together,

I hope you can help me with a simple problem.

My English is not very good but I hope you understand the

following problem:

I have a sales order with 2 or more positions of the same article.

The articles have different date of shipments and each position has

it’s own production order.

Sales Order:

Frist Position: Article A, Quantity 1000 pieces, delivery date: 08.06.2012

Second Position: Article A, Quantity 1000 pieces, delivery date: 20.06.2012

Production order:

First Order: Article A, Quantity 1000 pieces

Second Order: Article A, Quantity 1000 pieces

Delivery note:

Frist Delivery: Article A, Quantity 1000 pieces, date: 08.06.2012

Second Delivery: Article A, Quantity 1000 pieces, date: 20.06.2012

The problem with a query is that the query doesn’t know which

production order refers to which delivery note and so the query mixes

all production orders with all delivery notes…instead of the correct

2 allocations (one production order has one delivery note) I get 4 “wrong” allocation.

I will solve the problem with a additional query on the Batchnumber-

Each production order gets a system batchnumber

and to add a delivery note I have to declare the batchnumber.

My problem is – where can I find the system Batchnummer in the delivery note data fields after adding the delivery note? I couldn’t find a field to analyze it 😞

The column “Batchnumber” in the position line is unfortunally empty and not analyzeable. I hope you can help me!!

Greetings from Germany

[christophe_averous]

Hi,

For me the best solution is to add a user fields on the document line where you will store the docnum or the docentry of the production order just after the generation of the production order. As user fiels are copy from sales to delivery you query wil be more simple.

regards

Christophe

[Former Member]

Thank you for the answer. I hope I unterstand it right...you mean I have to create a new user-defined field

and store the production docentry in die sales order. Sounds good but I have no idea how to do this 😞

Actuelly there is the user-defined field "Batchnumber" which a collegue filled after completition of the production

but I have no idea to save these Batchnumber or to store it in the delivery note.Problem is that 1 delivery could

contain more than one Batchnumber.

On the other hand the Sales order is the first created document. Second is the associated production order.

In die alliance plan you can see the allocation from sales order, delivery note and invoice but there is no

connection with the production order 😞

My only allocation from sales order and production order is

T0=ORDR

T1=RDR1

OWOR T6 on T6.OriginNum=T0.DocNum and T6.[Status] <>'C' and T6.ItemCode=T1.ItemCode

Do you know a better connection?

Thank you for you help and sorry for the terrible english 😞

[christophe_averous]

Hi Katharina,

My idea is as follow:

1) on RDR1 create an UDF call U_OWOR for example.

2) When a sales order is created, you generate after the production order. I don't know if you do that by hand or by MRP or by the new function of 8.82 which allow to generate production order from sales order? Personnaly, I wrote an add on which generate the production order from the sales order, and in this case I know which line of the sales order I'm working on and I update the U_OWOR with the DocEntry of production order created by my add on.

3) I think that you could link also the due date in your query. I mean a query like

Select owor.docnum from owor inner join ordr on owor.originnum=ordr.docnum inner join rdr1 on rdr1.ItemCode=owor.ItemCode and rdr1.Docentry=ordr.docentry and owor.duedate=rdr1.Shipdate and owor.status<>'C' should restrict the numbre od production order.

Regards

Christophe