Skip to main content

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?

 

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:

 


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)


lol, i’m sure one of us is right 


Hi @paul harland  and @VACDBROOKES  

 

Thank you for your help. We were able to figure it out.