I am new to IFS and want to add the arrival qty to the purchase order lines screen.
This is the column I want
SQL Column: &AO.Receipt_Info_API.Get_Sum_Qty_Arrived_By_Source(ORDER_NO, LINE_NO, RELEASE_NO, NULL, 'PURCHASE_ORDER', NULL)
added to
View: &AO.PURCHASE_ORDER_LINE_ALL
based on purchase order, purchase order line, release number
Best answer by william.klotz
View original
+7
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
+21
Hi
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
