Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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

Syntax:

GETCALCJESTATUS (AppID, PostPeriod, CreationPeriod, Type)

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

Syntax example:

CREATE VARIABLE JEStatus as NUM

SET VARIABLE JEStatus = GETCALCJESTATUS (CalcJE1, P03YTD, P03YTD, CURRENTPERIOD)

Published:

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

Syntax:

GETCALCJESTATUS (AppID, PostPeriod, CreationPeriod, Type)

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

Syntax example:

CREATE VARIABLE JEStatus as NUM

SET VARIABLE JEStatus = GETCALCJESTATUS (CalcJE1, P03YTD, P03YTD, CURRENTPERIOD)

For an optimal Community experience, Please view on Desktop