OIM – Accounting Administration Fields

Here is a description of the fields and buttons available in the OIM – Accounting Administration Lightning component. The component provides an easy way of updating the fields on the OIM – Accounting Connector Settings custom setting.

This component is included in the OIM – Accounting Connector Admin page. For more information, see OIM – Accounting Connector Admin Page. You can also add this component to any Lightning app page.

General Settings

OIM – Accounting Administration Fields
Field Description
Default Company

The name of the default Accounting company. This is used to automatically populate the Company field on the following objects:

  • Purchase Order
  • Sales Order
  • Service Contract
Send Emails When selected, the connector sends an email notification after creating documents in the background. This is selected by default.
Send Notifications When selected, the connector sends a Salesforce notification after creating documents in the background. This is selected by default.

Account to Supplier Site Settings

Note:

The fields in the Account to Supplier Site section are reserved for future use in Spring 2024.

Supplier Site to Account Settings

Supplier Site to Account Fields
Field Description
Sync Suppliers to Accounts If selected, when you create a supplier site, a matching vendor account is automatically created. When you update an existing supplier site, the related vendor account is automatically updated with the relevant values. For more information, see Suppliers to Accounts.
Default AP Control GLA The default general ledger account for accounts payable control. This is used to populate the Accounts Payable Control GLA field when creating a supplier.
Default AR Control GLA The default general ledger account for accounts receivable control. This is used to populate the Accounts Receivable Control GLA field when creating a supplier.

AP Voucher to Payable Invoice Settings

Key: * – Mandatory field

AP Voucher to Payable Invoice Settings
Field

 

Description
Payable Invoice Line Limit   The maximum number of line items that a payable invoice created from an AP voucher can contain. If the number of AP voucher lines exceeds the limit, an additional payable invoice is created.
Validate While Matching  

When selected, the fields on AP voucher lines required for the integration are validated. If the fields fail the validation, you cannot match the AP voucher.

When deselected, AP vouchers can be matched even if the required fields are not valid.

This applies to the following fields on the AP Voucher Line object:

  • General Ledger Account
  • Item
  • Product
Automatically Create Payable Invoices  

Determines whether payable invoices are automatically created from eligible AP vouchers. The following options are available:

  • "Disabled"
  • "When Matching the AP Voucher"
  • "Custom Criteria"

For more information, see Setting up Automatic Document Creation.

Custom Criteria Field *

The field on the AP Voucher object used to determine whether a payable invoice is automatically created from an AP voucher as soon as it becomes eligible.

Notes:
  • This setting is only visible when "Custom Criteria" is selected in the Automatically Create Payable Invoices field.
  • You can only select a checkbox or a formula checkbox field.
  • You must have read access for the field in order to see it in the drop-down menu.
Automatically Post Payable Invoices   If selected, when a payable invoice is created from an AP voucher, it is automatically posted in Accounting.
Use Custom Mappings   If selected, Foundations mappings are used when creating payable invoices from AP vouchers. If you have not defined any custom mappings, deselecting this can improve the performance of flow executions.

AP Voucher Credit to Payable Credit Note Settings

Key: * – Mandatory field

AP Voucher Credit to Payable Credit Note Settings
Field

 

Description
Payable Credit Note Line Limit   The maximum number of line items that a payable credit note created from an AP voucher credit can contain. If the number of AP voucher line credits exceeds the limit, an additional payable credit note is created.
Automatically Create Payable Credit Notes  

Determines whether payable credit notes are automatically created from eligible AP vouchers. The following options are available:

  • "Disabled"
  • "When Crediting or Voiding the AP Voucher"
  • "Custom Criteria"

For more information, see Setting up Automatic Document Creation.

Custom Criteria Field *

The field on the AP Voucher Credit object used to determine whether a payable credit note is automatically created from an AP voucher credit as soon as it becomes eligible.

Notes:
  • This setting is only visible when "Custom Criteria" is selected in the Automatically Create Payable Credit Notes field.
  • You can only select a checkbox or a formula checkbox field.
  • You must have read access for the field in order to see it in the drop-down menu.
Automatically Post Payable Credit Notes   If selected, when a payable credit note is created from an AP voucher credit, it is automatically posted in Accounting.
Use Custom Mappings  

If selected, Foundations mappings are used when creating payable credit notes from AP voucher credits. If you have not defined any custom mappings, deselecting this can improve the performance of flow executions.

OIM Invoice to Sales Invoice Settings

Key: * – Mandatory field

OIM Invoice to Sales Invoice Settings
Field

 

Description
Sales Invoice Line Limit   The maximum number of line items that a sales invoice created from an Order and Inventory Management invoice can contain. If the number of invoice line items exceeds the limit, an additional sales invoice is created.
Automatically Create Sales Invoices  

Determines whether sales invoices are automatically created from eligible inventory invoices. The following options are available:

  • "Disabled"
  • "When Completing the Shipment Related to the Invoice"
  • "Custom Criteria"

For more information, see Setting up Automatic Document Creation.

Custom Criteria Field *

The field on the Invoicing object used to determine whether a sales invoice is automatically created from an inventory invoice as soon as it becomes eligible.

Notes:
  • This setting is only visible when "Custom Criteria" is selected in the Automatically Create Sales Invoices field.
  • You can only select a checkbox or a formula checkbox field.
  • You must have read access for the field in order to see it in the drop-down menu.
Automatically Create Drop Ship Sales Invoices  

Determines whether sales invoices are automatically created from eligible drop ship invoices. The following options are available:

  • "Disabled"
  • "When Billing a Drop Ship Sales Order"
  • "Custom Criteria"

For more information, see Setting up Automatic Document Creation.

Custom Criteria Field *

The field on the Invoicing object used to determine whether a sales invoice is automatically created from a drop ship invoice as soon as it becomes eligible.

Notes:
  • This setting is only visible when "Custom Criteria" is selected in the Automatically Create Sales Invoices field.
  • You can only select a checkbox or a formula checkbox field.
  • You must have read access for the field in order to see it in the drop-down menu.
Automatically Post Sales Invoices   If selected, when a sales invoice is created from an Order and Inventory Management invoice, it is automatically posted in Accounting.
Use Custom Mappings   If selected, Foundations mappings are used when creating sales invoices from invoices. If you have not defined any custom mappings, deselecting this can improve the performance of flow executions.
Automatically Calculate Tax in the Scheduled Job  

If selected, tax is auto-calculated for invoices using Avalara as part of the Create Sales Invoices from OIM Invoices scheduled job. Tax is calculated before the sales invoices are created and the tax invoice line items are exported to Accounting.

Note:

This checkbox is displayed only when tax calculation using Avalara is enabled. For more information, see Setting up External Tax Calculation using Avalara AvaTax.

Enable Tax Calculation from the Record Page  

If selected, when you click the Create Sales Invoice button on the Invoicing record page, the Calculate Tax checkbox displays. This enables you to calculate tax for the invoice using Avalara before the sales invoice is created. The tax invoice line item is automatically exported to Accounting.

Note:

This checkbox is displayed only when tax calculation using Avalara is enabled. For more information, see Setting up External Tax Calculation using Avalara AvaTax.

Enable Tax Calculation from the List View  

If selected, tax is auto-calculated using Avalara when you click the Create from OIM Invoices button on the Invoices list view. Tax is calculated before the sales invoices are created and the tax invoice line items are exported to Accounting.

Note:

This checkbox is displayed only when tax calculation using Avalara is enabled. For more information, see Setting up External Tax Calculation using Avalara AvaTax.

Credit Invoice to Sales Credit Note Settings

Credit Invoice to Sales Credit Note Settings
Field

 

Description
Sales Credit Note Line Limit   The maximum number of line items that a sales credit note created from a credit invoice can contain. If the number of credit invoice line items exceeds the limit, an additional sales credit note is created.
Automatically Create Sales Credit Notes  

Determines whether sales credit notes are automatically created from eligible credit invoices. The following options are available:

  • "Disabled"
  • "When Crediting or Voiding the Invoice"
  • "Custom Criteria"

For more information, see Setting up Automatic Document Creation.

Custom Criteria Field *

The field on the Credit Invoice object used to determine whether a sales credit note is automatically created from an credit invoice as soon as it becomes eligible.

Notes:
  • This setting is only visible when "Custom Criteria" is selected in the Automatically Create Sales Credit Notes field.
  • You can only select a checkbox or a formula checkbox field.
  • You must have read access for the field in order to see it in the drop-down menu.
Automatically Post Sales Credit Notes   If selected, when a sales credit note is created from a credit invoice, it is automatically posted in Accounting.
Use Custom Mappings   If selected, Foundations mappings are used when creating sales credit notes from credit invoices. If you have not defined any custom mappings, deselecting this can improve the performance of flow executions.
Automatically Calculate Tax in the Scheduled Job  

If selected, tax is auto-calculated for credit invoices using Avalara as part of the Create Sales Credit Notes from Credit Invoices scheduled job. Tax is calculated before the sales credit notes are created and the tax credit invoice lines are exported to Accounting.

Note:

This checkbox is displayed only when tax calculation using Avalara is enabled. For more information, see Setting up External Tax Calculation using Avalara AvaTax.

Enable Tax Calculation from the Record Page  

If selected, when you click the Create Sales Credit Note on the Credit Invoice record page, the Calculate Tax checkbox displays. This enables you to calculate tax for the credit invoice using Avalara before the sales credit note is created. The tax credit invoice line is automatically exported to Accounting.

Note:

This checkbox is displayed only when tax calculation using Avalara is enabled. For more information, see Setting up External Tax Calculation using Avalara AvaTax.

Enable Tax Calculation from the List View  

If selected, tax is auto-calculated using Avalara when you click the Create from Credit Invoices button on the Sales Credit Notes list view. Tax is calculated before the sales credit notes are created and the tax credit invoice lines are exported to Accounting.

Note:

This checkbox is displayed only when tax calculation using Avalara is enabled. For more information, see Setting up External Tax Calculation using Avalara AvaTax.

Inventory Transaction Perpetual Record to Journal Settings

Inventory Transaction Perpetual Record to Journal Settings
Field

 

Description
Journal Line Limit   This field is not used.
Batch Size  

The maximum number of inventory transaction perpetual records processed in a single batch. Decreasing this number can reduce performance but ensures that Salesforce limits are not reached.

The default value is 50.

Automatically Create Journals  

Determines whether journals are automatically created from eligible inventory transactions. The following options are available:

  • "Disabled"
  • "When Inventory Transactions are Created"
  • "Custom Criteria"

For more information, see Setting up Automatic Document Creation.

Custom Criteria Field *

The field on the Inventory Transaction Perpetual Record object used to determine whether a journal is automatically created from an perpetual record as soon as it becomes eligible.

Notes:
  • This setting is only visible when "Custom Criteria" is selected in the Automatically Create Journals field.
  • You can only select a checkbox or a formula checkbox field.
  • You must have read access for the field in order to see it in the drop-down menu.
Automatically Post Journals   If selected, when a journal is created from an inventory transaction, it is automatically posted in Accounting.
Create COGS Journals for Drop Ship Accounting Items  

If selected, cost of goods sold inventory transactions are created from invoice line items that originated from accounting AP voucher lines in drop ship scenarios. This enables you to create journals in Accounting that represent certain charges as cost of goods sold, for example freight charges.

This can be useful if freight charges are not known until the AP voucher is recorded. After creating an accounting line for freight on the AP voucher and then receiving the AP voucher, Order and Inventory Management automatically creates a new line item on the sales order. When you bill the sales order, you can include the freight charges as a line on the invoice. With this option enabled, the connector creates an additional inventory transaction perpetual record that classifies the freight charges as cost of goods sold. The connector can then create a journal for this inventory transaction.

Buttons

OIM – Accounting Administration Buttons
Button Description
Manage Scheduled Jobs Enables you to schedule background executions of each flow, view, and delete scheduled jobs. For more information, see Managing Scheduled Jobs.
Manage Mappings Enables you to view and customize the field level mappings for each flow. For more information, see Viewing Mappings.
Save Saves the changes that you have made to the connector settings.