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
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
+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
+21Hi
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 E-mail address. We'll send you an e-mail with instructions to reset your password.
