@mmoss  Please refer the steps given in the following post.

Hope that helps and if you need any further clarifications, please get back.

Best Regards,

Sangeetha Jayamaha.

/

I don’t completely understand. The column names are not the same in each table. what expression would I use to just get the qty arrived by po line?

select  source_ref1, source_ref2, source_ref3, sum(source_qty_arrived) from IFSAPP.receipt_info group by source_ref1, source_ref2, source_ref3

select order_no, line_no, release_no from IFSAPP.purchase_order_line

Hi @mmoss ,

Below you’ll find screenshots of the custom field we have on the purchase order lines called arrival_qty.   We use this API call in the expression of the read only field.  Receipt_Info_API.Get_Sum_Qty_Arrived_By_Source(v.order_no, v.line_no, v.release_no, NULL, 'PURCHASE_ORDER', NULL)

In your API example you were missing the v. in front of the variables you were passing to the API call.

Hope this helps you out.

Receipt_Info_API.Get_Sum_Qty_Arrived_By_Source(v.order_no, v.line_no, v.release_no, NULL, 'PURCHASE_ORDER', NULL)

Regards,

William Klotz

@william.klotz Worked perfectly. Thanks!