Link Receipt from production to delivery note

[Former Member]

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

[former_member187989 · Accepted solution]

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

[Former Member]

thanks, i will try this out

[helen_sun]

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