++Repost to the right queue
Community,
We are scheduling a Inventory Period Statistic Report, it is scheduled on the 1st day of each month. Our inventory statistical period is created on each month basis.
We would like system to fetch dynamically on Parameter Period. If it is running on Dec.1, 2025, then 12 should be feched to paramter Period field. What function/SQL statement we should us in field Period? Thank you.
Best answer by Tracy Norwillo
I’ve added the api’s to the SQL so you can see how it would work. Adjust as necessary to show your desired fields.
select h.*
,accounting_period_api.get_curr_acc_year(company_site_api.get_company(contract)) curr_year
,accounting_period_api.get_curr_acc_period(company_site_api.get_company(h.contract)) curr_period
from inventory_part_period_hist h
where stat_year_no = accounting_period_api.get_curr_acc_year(company_site_api.get_company(h.contract))
and stat_period_no = accounting_period_api.get_curr_acc_period(company_site_api.get_company(h.contract))
and h.contract = '&Site'
I’ve added the api’s to the SQL so you can see how it would work. Adjust as necessary to show your desired fields.
select h.*
,accounting_period_api.get_curr_acc_year(company_site_api.get_company(contract)) curr_year
,accounting_period_api.get_curr_acc_period(company_site_api.get_company(h.contract)) curr_period
from inventory_part_period_hist h
where stat_year_no = accounting_period_api.get_curr_acc_year(company_site_api.get_company(h.contract))
and stat_period_no = accounting_period_api.get_curr_acc_period(company_site_api.get_company(h.contract))
and h.contract = '&Site'
I have talked to IFS about this dynamic parameters, they suggest me to do the same.
Your input does help.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
