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

Link Receipt from production to delivery note

Hi

Is it possible to automatically link the quantity and description of goods produced to a delivery note using a particular sales order as a reference.

thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Jun 18, 2008 at 08:23 AM

    hi Naeem Patelia,

    Linking delivery note to receipt from production is not possible.

    But you can link sales order to receipt from production.

    1.Create production order linked to a sales order.

    2.Create user defined field and make it visible and acive using

    form setting.

    3.Apply formatted search in user defined field and

    select option search by saved query,make it auto referesh

    when production order number changes.

    Use the below query,

    SELECT T0.[OriginNum] FROM OWOR T0 WHERE T0.[DocNum] = $[61.1.0]

    Hope above answer will solve your problem.

    Jeyakanthan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 18, 2008 at 09:19 AM

    Hi

    Please kindly check the note: 656157 but it is based on lower version of business one. The table OWKO, WKO1 and some fields in the query are used only in the function 'work order', which has been replaced by 'production order' in 2004A or higher version.

    Please have a try :

    1. Create a User defined field on Marketing document header level

    (Tools -> Manage user fields -> marketing documents -> Title.) -

    Make it of type numeric and call it e.g. Production order nr. u2013 Add it to your Delivery Note.

    2. Attach to the field created in step 1 the following Formatted search (first save the query via Query interface -> execute -> save the query under appropriate name):

    SELECT distinct T0.OriginNum, T0.CardCode, T0.ItemCode, T0.PlannedQty, T0.CmpltQty FROM OWOR T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode INNER JOIN ODLN T2 ON T1.CardCode = T2.CardCode WHERE T0.CardCode =$[ODLN.CardCode] AND T0.Status ='L' AND T0.CloseDate = '[%0]'

    In the query above change the user defined field code (which was created in step 1 to replace field U_prodnr with your own user defined field code).

    You are kindly reminded that we wrote the query based on the following scenario:

    (1)You will not create the delivery note until the production order has been closed.If it doesn't in accord with your business, you can change the condition of status.

    (2)You want to find the production order by closing date.

    If you would like not, you can delete the u201CAND T0.CloseDate = '[%0]'u201D

    3. On the Marketing document rows please add the following Formatted search to the Item code field:

    SELECT T2.ItemCode, T2.Dscription, T2.Quantity FROM OWOR T0 INNER JOIN ORDR T1 ON T0.OriginNum=T1.DocNum INNER JOIN RDR1 T2 ON T1.DocNum = T2.DocEntry WHERE T0.OriginNum =$[ODLN.U_Prodnr]

    In the query above change the user defined field code (which was created in step 1) to replace field U_prodnr with your own user defined field code.

    4. Add the following formatted search in the Marketing document to the quantity field:

    SELECT T2.Quantity, T2.ItemCode, T2.Dscription FROM OWOR T0 INNER JOIN ORDR T1 ON T0.OriginNum=T1.DocNum INNER JOIN RDR1 T2 ON T1.DocNum = T2.DocEntry WHERE T0.OriginNum =$[ODLN.U_Prodnr]

    In the query above change the user defined field code (which was created in step 1 to replace field U_prodnr with your own user defined field code.

    Make the following setting on this query: Auto refresh when column "Item code" changes

    With the above setting, it is possible to select the production order from the delivery note and deliver the items from there.

    Hope this can be helpful.

    Best Regards

    Helen Sun

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 12:33 PM

    thanks, i will try this out

    Add a comment
    10|10000 characters needed characters exceeded

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.