Skip to main content

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?

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

Thanks, Mats!!!  They never let me look at the code!   

Reply


Terms & ConditionsCookie settings