OriginNum(SalesOrderNr) as automatic parameter
Martin Cerasuolo
Dear Designer addicts & Phillip,I have created the following query to print all the production orders based on one sales order.
SELECT
T3.ItemName, *
From WOR1 T0
inner join OWOR T1 ON T0.DocEntry = T1.DocEntry
inner join OITM T3 ON T1.ItemCode = T3.ItemCode
left outer join OCRD T2 ON T1.CardCode = T2.CardCode
where
T1.OriginNum=' [%OriginNum]'
------
Furthermore i have created a parameter on the field OriginNum; which is the same as the sales order's field docnum. This is the problem: "Because there can be more than one production orders linked to the sales order and i need to print the lay-out in the production order entry screen, i can't use the parameters from the MarketingDocumentDIN lay-out to get the current sales order number(OriginNum). Is there a way to enter a code in the Design Param SQL to get the sales order number(OriginNum) from the screen?
Please help?Martin Cerasuolo
Solution:
Fill in the id of the OriginNum in the parameter menu!
0
Please sign in to leave a comment.
Comments
0 comments