Skip to main content

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,'*')

 

Hi @Rpauley,

 

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