You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Fetching Element Entry Values in Fast Formulas as of Specific Date

Received Response
edited Jul 6, 2021 12:45PM in Payroll and Global Payroll Interface (GPI) 1 comment



We'd like to fetch the element entry value for the 'Amount' input value as of a particular date.

For example, an employee has an entry for the element 'X' with the Amount input value as 100 in 01-Jan-21. From 01-Feb-21 onwards, the element entry was updated and the Amount set as 200. In an another fast formula, we'd like to retrieve the element entry information for 'X' as of 01-Jan-21, i.e. 100.

Our assumption was that we could write the fast formula code as below, but unfortunately that appears to fetch only the latest value (In the example, 200)

l_entry_val = 0<br /> CHANGE_CONTEXTS(EFFECTIVE_DATE = &#39;2021/01/01&#39; (date)) (<br /> l_entry_val = X_AMOUNT_ASG_ENTRY_VAL<br /> )

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!