GetCalcJEStatus
Use this function to retrieve the status of a calculated journal entry. The variable type is returned as a Num.
Possible return values include the following:
- 0 - Does Not Exist - The calculated journal entry does not exist or cannot be retrieved. Non-shared calculated journal entries will not be retrieved for a user that does not have access to the JE.
- 1 - No Status - The calculated journal has not been validated or posted. This value is not expected for calculated journal entries.
- 2 - Posted - The calculated journal entry has been posted permanently
- 3 - Validated - The calcualted journal entry as been validate
- 4 - Errors - The calculated journal entry did not validate. This values is not expected for calculated journal entries, as calculated journal entries are validated when they are created.
- 5 - Review - The calculated journal entry has been posted temporarily
where:
- AppID is the Application ID of the calculated journal entry.
- PostPeriod is the symbol name of the posted period of the calculated journal entry.
- CreationPeriod is the symbol name of the creation period of the calculated journal entry.
- Type is the type of calculated journal entry and can be one of the following:
- CURRENTPERIOD
- RESTATEMENT
- PPA
- FUTUREPERIOD
Copy
Syntax example
CREATE VARIABLE JEStatus as NUM
SET VARIABLE JEStatus = GETCALCJESTATUS (CalcJE1, P03YTD, P03YTD, CURRENTPERIOD)