Skip to Content
author's profile photo Former Member
Former Member

Allocation production order to delivery note?

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jun 06, 2012 at 11:15 AM


    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.



    Add a comment
    10|10000 characters needed characters exceeded

    • 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.



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.