Good Afternoon,
I am trying to figure out how to get columns that are available from the page in IFS in the Data Source Designer, can any one help with this, See screen shot below
Columns Needed
-System Even Description
-Transaction Qty
-On Hand QTY After Transaction
What i have tried &AO.INVENTORY_TRANSACTION_HIST_API.Get_Transaction_QTY(CONTRACT,PART_NO,'*')
Best answer by Charana Udugama
Hi
First of all, although there is a column named ‘Transaction Qty’ shown in the IEE, there is no Get_Transaction_QTY Function in the ‘INVENTORY_TRANSACTION_HIST_API’.
The view ‘INVENTORY_TRANSACTION_HIST’, which is used here in the ‘Inventory Part on Hand Development’ has the column ‘QUANTITY’. Which is the one you see as ‘Transaction Qty’.
So the function you should be using is, ‘INVENTORY_TRANSACTION_HIST_API.Get_Quantity(transaction_id)’.
As you can see, the argument that is used here is the transaction_id.
PS: You might need to look into the function Get_Transaction_Id_Tab in the same API if you need to get the transaction_id.
Hope this answers your query.
Best Regards,
Charana Udugama
+12Hi
First of all, although there is a column named ‘Transaction Qty’ shown in the IEE, there is no Get_Transaction_QTY Function in the ‘INVENTORY_TRANSACTION_HIST_API’.
The view ‘INVENTORY_TRANSACTION_HIST’, which is used here in the ‘Inventory Part on Hand Development’ has the column ‘QUANTITY’. Which is the one you see as ‘Transaction Qty’.
So the function you should be using is, ‘INVENTORY_TRANSACTION_HIST_API.Get_Quantity(transaction_id)’.
As you can see, the argument that is used here is the transaction_id.
PS: You might need to look into the function Get_Transaction_Id_Tab in the same API if you need to get the transaction_id.
Hope this answers your query.
Best Regards,
Charana Udugama
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
