Setting up Accounting Journal API Features

Create a dedicated API user in Accounting and assign the following permission sets to them:

• Accounting API - Journal
• FDN Core - Read Only

You must assign the API user to a company. However, you do not need to set a current company for the API user. For more information about creating user company records, see Assigning Users to Companies.

Refer to the Salesforce Help for best practice information on creating API users.

Connect your third-party application to Accounting using a connected app to authenticate and send data to Accounting.

If you intend to send data to Accounting from ADP Workforce Now, you can use the ADP Workforce Now connected app provided. For more information, see Connected Apps.

If you intend to send data from a different third-party application, you can create a connected app specifically for your application.

See the Salesforce Help for more information about connected apps.

The Accounting Journal API splits journal line items into separate journals, based on the Manual Journal Line Limit in Document Line Volume Settings. If you send data that exceeds that limit, Accounting automatically enters a balancing line and creates the remaining data as a separate journal.

Set up or identify a general ledger account that the API can use as a suspense account for the balancing lines. You can specify which general ledger account to use as a suspense account when enabling the feature using the Feature Console.

Decide what information you want to send from your third-party application to Accounting and configure your application to send data via the API. In addition to the standard keys, several custom keys are available to enable you to customize the type of journal line item information you send.

See the Accounting REST API Developer Reference on the Certinia Community for more information.

The Feature Console simplifies the setup tasks for some Certinia features.

To configure Accounting to receive information from your third-party application, follow the Accounting Journal API feature steps on the Feature Console tab.

For more information about using the Feature Console, see Feature Console.

The Accounting Journal API feature uses many components that may be used by other Foundations integrations. If you want to disable this feature after it has been enabled, complete the following steps:

• Manually disable the related subscription on the Foundations Setup page
• Use the Feature Console to mark the feature as disabled

The Feature Console creates data transformation tables (DTTs) for you and adds them to the subscription mappings for Line Type and Bank Account.

When these DTTs have been created in your org, you must create a data transformation for each general ledger account (GLA) that is used when processing payroll data through the Accounting Journal API feature, so that the journal line has the correct line type and bank account.

To create the relevant data transformations, complete the following steps:

1. Select the Data Transformation Tables tab.
2. Click the record name to view the GLA to Line Type DTT.
3. Click New Data Transformation and enter the following details:
   1. Enter the GLA name in the Source Value 1 field.
   2. Enter the line type name in the Target Value field (GLA or Bank Account).
   3. To create additional data transformations for the DTT, click Save & New or, if you have finished, click Save.
4. Select the Data Transformation Tables tab.
5. Click the record name to view the GLA to Bank Account DTT.
6. Click New Data Transformation and enter the following details:
   1. Enter the GLA name in the Source Value 1 field.
   2. Enter the bank account name in the Target Value field, or, if the line type of the general ledger account is GLA, leave the Target Value field blank.
   3. To create additional data transformations for the DTT, click Save & New or, if you have finished, click Save.

Example

The following table displays some examples of how you can use the DTTs to map your GLAs to the correct journal line type and bank account.

Data Transformation Table	Source Value 1	Source Value 2	Target Value
GLA to Line Type	Payroll		General Ledger Account
GLA to Line Type	Current Account USD		Bank Account
GLA to Bank Account	Payroll		Leave blank, as the line type is GLA
GLA to Bank Account	Current Account USD		Bank of America Account

For more information, see Data Transformation Tables and Creating a Data Transformation Table.

If required, you can use Foundations features to customize the default field mappings or add custom mappings to suit your organization’s requirements.

For example, you can create mappings for custom keys to add additional details to journal line items.

For more information, see Adding Mappings to a Messaging Relationship.