Third-Party to Accounting Journal

You can use Foundations to connect third-party applications to Certinia applications.

You can create journals in Accounting directly from the information stored in your third-party applications using the Accounting Journal API.

This feature enables you to:

  • Securely integrate your third-party application with Accounting
  • Create journals and journal line items using data from your third-party application, such as payroll data
  • Automatically derive the period of a journal, based on the date and company provided
  • Specify the general ledger account to which you want to add your line items
  • Send details for up to four analysis dimensions
  • Create up to five custom mappings to send additional information from your third-party application to journal line items
  • Automatically add a custom description to all journals created via the API to help identify third-party data
  • Specify how Accounting splits journals, based on maximum line limits, and designate a general ledger account to use as a suspense account
  • Specify the custom description to add to all balancing lines automatically created via the API
  • Review the journal and journal line items in Accounting before posting the journal
  • Use the data transformation features in Foundations to convert data received via the API so that it is appropriate for the target field in Accounting

Journals created through the API are of type Manual Journal.

Splitting Journals

When you send data that exceeds the Manual Journal Line Limit in Document Line Volume Settings, Accounting automatically enters a balancing line and creates the remaining data as a separate journal.

The Manual Journal Line Limit can only be updated by Certinia. To do this, contact Customer Support.

Example 1

If the Manual Journal Line Limit is 250 and you send data that equates to 400 journal line items, Accounting does the following:

  • Creates one journal containing lines 1-249
  • Creates a balancing line in that journal, which is associated with the suspense account specified in FDN Accounting Messaging Settings, to ensure the Journal Total is zero
  • Creates a second journal that contains lines 250-400
  • Creates a balancing line in the second journal, if required, to ensure the Journal Total is zero

Example 2

If the Manual Journal Line Limit is 250 and you send data that equates to 250 journal line items, Accounting creates only one journal.

These features use off-platform REST APIs. Authentication and authorization are provided by Salesforce. For more information, see the Salesforce Developer API documentation.

For more information about the APIs available, see Accounting REST API Developer Reference on the Certinia Community.