Hi,
I want to add a custom field to the Shipment Lines.
This field needs to refer to the field ‘Customer PO No’ on the header of a customer order.
I did build a SQL query to fetch desired field:
SELECT c.customer_po_no
FROM Customer_Order c, Shipment_Line s
WHERE c.order_no = s.source_ref1
I don’t know what I need to add in the field ‘Arguments’. Can someone help?
Best answer by paul harland
View original
+24
Hello,
If you want to use SELECT format then the most efficient form would be this:
You can also use the Expression format, in which case it would be this:
+7
You shouldn’t need to join the tables in the select statement.
In the argument section add the variable as v.source_ref1
Then in your SQL section try
select customer_po_no from customer_order where order_no =:source_ref1
you may also be able to run this as an expression using the IFS Customer order API
customer_order_api.get_customer_po_no(source_Ref1)
+24
lol, i’m sure one of us is right
Hi
Thank you for your help. We were able to figure it out.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
