Journal Import Functions

The following methods are available for the Journal component:

Import

This is the main component and performs all the stages of Ledger Import:

  1. Loading all lines into the posting tables
  2. Validating data
  3. Posting validated lines into the Actual Ledger tables.

Ledger Update

This component updates two columns on the ledger based on the content of two other columns. A very limited input payload is required to use this method. See Journal Update Functionality for more information.

Ledger Update Process Posting Details

This method performs the first stage of the Ledger Update; to load the data into the posting tables.

Load

This method performs the first stage of the Ledger Update; to load the data into the posting tables.

LoadAndPost

Note: Warning: This method always posts to the actual ledger even if the validation fails. Therefore it is recommended you do not use this method, but use the Import method instead.

ProcessPostingDetails

This method allows to validate the lines within the posting tables and posts them into the actual ledger.

Note: The ProcessPostingDetails method is not recommended, as it is likely to return a status of 'success', regardless of whether the posting is successful or not. Additionally, the posting tables are not cleared down afterwards, which could potentially cause problems in subsequent reruns.

Query

This method allows you to extract the ledger transactions from the actual ledger tables.

ValidateOnly

This method allows you to validate your journal lines before posting them.