If you know the SQL query tool in IFS you can see in the System Info in which view you need to look. When you execute Select * from INVENTORY_PART_PLANNING you will get all the data in the table which you can export to excel using a regular output channel. (Figure 1)

If you do not want all you can use the query dialog box to add a WHERE clause. (figure 2.1&2)

Select * from INVENTORY_PART_PLANNING WHERE planning_method = 'N’

Figure 2.1

Hi, thanks but I’m not that familiar with the SQL query tool. Can you show some more screenshots for a SQL query on the info that’s on the IPAP/Planning Info tab? I really want to just dump this data for all parts (just for parts that have an In/Out >0).

Hi, 

This is the Query tool;

And I think you need to use the following query in the SQL statement box;

This selects the parts that have in OR out > 0.

select *
from INV_PART_CONFIG_PROJECT_1
where 
(Inventory_Part_Period_Hist_API.Get_Total_Issued(CONTRACT, PART_NO, CONFIGURATION_ID, Statistic_Period_API.Get_Previous_Year(Statistic_Period_API.Get_Stat_Year_No(SYSDATE)), null) > 0) OR (Inventory_Part_Period_Hist_API.Get_Total_Received(CONTRACT, PART_NO, CONFIGURATION_ID, Statistic_Period_API.Get_Previous_Year(Statistic_Period_API.Get_Stat_Year_No(SYSDATE)), null) > 0)

Hi, thank you, that is really helpful. I can see what that is doing. Sorry to ask another question. If I just wanted to use that query (>0 transactions) but only list Part No and the values for LastYearOut, LastYearIn, YearOut and YearIn, how would I modify the SQL query to display that?

Thanks!