I need a quick answer here, please. What date is used on the Inventory Transaction History when this aggregation is run? The created date of the transaction or the date applied?
Solved
Date basis for the Aggregate Inventory Transactions per period
+8Best answer by majose
Hi Vernon,
Haven’t really tested this but when I read the code in this job and check how we retrieve statistical periods it uses following code snippet:
…
-- Get period for this transaction
Statistic_Period_API.Get_Statistic_Period (stat_year_no_,
stat_period_no_,
trans_hist_tab_(j).date_applied_);
And this is the Date Applied date from Inventory Transaction History/Mpccom Accounting Table.
-Mats
Hi Vernon,
Haven’t really tested this but when I read the code in this job and check how we retrieve statistical periods it uses following code snippet:
…
-- Get period for this transaction
Statistic_Period_API.Get_Statistic_Period (stat_year_no_,
stat_period_no_,
trans_hist_tab_(j).date_applied_);
And this is the Date Applied date from Inventory Transaction History/Mpccom Accounting Table.
-Mats
+8Hi Vernon,
Haven’t really tested this but when I read the code in this job and check how we retrieve statistical periods it uses following code snippet:
…
-- Get period for this transaction
Statistic_Period_API.Get_Statistic_Period (stat_year_no_,
stat_period_no_,
trans_hist_tab_(j).date_applied_);
And this is the Date Applied date from Inventory Transaction History/Mpccom Accounting Table.
-Mats
Thanks, Mats!!! They never let me look at the code!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.