OIM – FinancialForce Connector Data Dictionary

SCM_FFA_Connector_Settings__c

Label: OIM – FinancialForce Connector Settings

Settings that control the behavior of the connector between Order and Inventory Management and Accounting. Do not change these settings directly. Use the OIM – FinancialForce Connector Admin tab instead.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
APVC_Auto_Post_Payable_Credit_Note__c APVC Auto Post Payable Credit Note Pre-Winter 2024 If selected, when a payable credit note is created from an AP voucher credit, it is automatically posted in Accounting.

Checkbox false
APVC_Create_PCN_Custom_Criteria_Field__c APVC Create PCN Custom Criteria Field Pre-Winter 2024 API name of the field on the AP Voucher Credit object used to determine whether a payable credit note is automatically created from the AP voucher credit once it becomes eligible. The field is only used when APVC Create PCN When Crediting is deselected. This must be a checkbox or a formula checkbox field.

Text(255)
APVC_Create_PCN_When_Crediting__c APVC Create PCN When Crediting Pre-Winter 2024 If selected, when you void or credit an AP voucher, a payable credit note is automatically created from the newly created AP voucher credit.

Checkbox false
APVC_Payable_Credit_Note_Line_Limit__c APVC Payable Credit Note Line Limit Pre-Winter 2024 The maximum number of lines to create on a single payable credit note. If the number of AP voucher line credits exceeds this number, additional payable credit notes are created.

Number(18,0) 1000
APVC_Use_Custom_Mappings__c APVC Use Custom Mappings Winter 2024 If selected, Foundation mappings are used when creating payable credit notes from AP vouchers credit. If you have not defined any custom mappings, deselecting can improve performance.

Checkbox true
APV_Create_PIN_Custom_Criteria_Field__c APV Create PIN Custom Criteria Field Pre-Winter 2024 API name of the field on the AP Voucher object used to determine whether a payable invoice is automatically created from the AP voucher once it becomes eligible. The field is only used when APV Create PIN When Matching is deselected. This must be a checkbox or a formula checkbox field.

Text(255)
APV_Use_Custom_Mappings__c APV Use Custom Mappings Winter 2024 If selected, Foundation mappings are used when creating payable invoices from AP vouchers. If you have not defined any custom mappings, deselecting can improve performance.

Checkbox true
Auto_Post_Journal__c ITRP Auto Post Journal Pre-Winter 2024 If selected, when a journal is created from an inventory transaction, it is automatically posted in Accounting.

Checkbox false
Auto_Post_Payable_Invoice__c APV Auto Post Payable Invoice Pre-Winter 2024 If selected, when a payable invoice is created from an AP voucher, it is automatically posted in Accounting.

Checkbox false
Auto_Post_Sales_Invoice__c INV Auto Post Sales Invoice Pre-Winter 2024 If selected, when a sales invoice is created from an invoice, it is automatically posted in Accounting.

Checkbox false
Auto_Push_PIN__c APV Create PIN When Matching Pre-Winter 2024 When selected, payable invoices are automatically created when matching AP vouchers.

Checkbox false
Auto_Push_SIN__c INV Create SIN When Completing Shipment Pre-Winter 2024 If selected, sales invoices are automatically created when completing a shipment related to an invoice.

Checkbox false
CRINV_Auto_Post_Sales_Credit_Notes__c CRINV Auto Post Sales Credit Note Pre-Winter 2024 If selected, when a sales credit note is created from a credit invoice, it is automatically posted in Accounting.

Checkbox false
CRINV_Calculate_Tax_From_The_Record_Page__c CRINV Calculate Tax from the Record Page Winter 2024 If selected, when you click 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.

Checkbox false
CRINV_Calculate_Tax_In_The_Scheduled_Job__c CRINV Calculate Tax in the Scheduled Job Winter 2024 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 note line items are exported to Accounting.

Checkbox false
CRINV_Calculate_Tax_When_Pulling__c CRINV Calculate Tax from the List View Winter 2024 If selected, tax is calculated when Create from Credit Invoices button is clicked.

Checkbox false
CRINV_Create_SCN_Custom_Criteria_Field__c CRINV Create SCN Custom Criteria Field Pre-Winter 2024 API name of the field on the Credit Invoice object used to determine whether a sales credit note is automatically created from the credit invoice once it becomes eligible. This must be a checkbox or a formula checkbox field.

Text(255)
CRINV_Create_SCN_When_Crediting__c CRINV Create SCN When Crediting Pre-Winter 2024 If selected, when you void or credit an invoice, a sales credit note is automatically created from the newly created credit invoice.

Checkbox false
CRINV_Use_Custom_Mappings__c CRINV Use Custom Mappings Winter 2024 If selected, Foundation mappings are used when creating sales credit notes from credit invoices. If you have not defined any custom mappings, deselecting can improve performance.

Checkbox true
Check_for_Duplicate_Suppliers__c Check for Duplicate Suppliers Winter 2024 When selected, if you try to create or update a vendor account that would result in a duplicated supplier site, an error occurs.

Checkbox false
Create_COGS_Journals_for_DS_Acct_Items__c Create COGS Journals for DS Acct Items Pre-Winter 2024 This custom setting allows the creation of inventory transaction records (financial and inventory records) in order to create a COGS Journal for the freight costs associated with drop ship transactions. The freight cost line is added manually to the AP Voucher related to the drop ship sales order.

Checkbox false
Default_AP_Control_GLA_Reporting_Code__c Default AP Control GLA Reporting Code Pre-Winter 2024 Reporting Code for the default Accounts Payable Control GL Account. This is used to create an Account from a Supplier Site when "Sync Supplier to Account" is enabled.

Text(24)
Default_AR_Control_GLA_Reporting_Code__c Default AR Control GLA Reporting Code Pre-Winter 2024 Reporting Code for the default Accounts Receivable Control GL Account. This is used to create an Account from a Supplier Site when "Sync Supplier to Account" is enabled.

Text(24)
Default_Company__c Default Company Name Pre-Winter 2024 The name of the default Accounting company. This is used to populate the Company Name field when creating a purchase order, sales order, and a service contract.

Text(80)
Duplicate_Supplier_Custom_Criteria_Field__c Duplicate Supplier Custom Criteria Field Winter 2024 The API name of a field on the Supplier Site object used to check whether two suppliers sites are duplicates. This is only used when Check for Duplicate Suppliers is selected.

Text(255)
Enable_Manual_Deposits__c INV Enable Manual Deposits Pre-Winter 2024 If deselected, deposits are automatically applied when creating a sales invoice. If selected, you can manually apply a deposit on the resulting sales invoice.

Checkbox false
INV_Calculate_Tax_From_The_Record_Page__c INV Calculate Tax from the Record Page Winter 2024 If selected, when you click Create Sales Invoice 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.

Checkbox false
INV_Calculate_Tax_In_The_Scheduled_Job__c INV Calculate Tax in the Scheduled Job Winter 2024 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.

Checkbox false
INV_Calculate_Tax_When_Pulling__c INV Calculate Tax from the List View Spring 2024 If selected, tax is calculated when Create from OIM Invoices button is clicked.

Checkbox false
INV_Create_DS_SIN_Custom_Criteria_Field__c INV Create DS SIN Custom Criteria Field Pre-Winter 2024 API name of the field on the Invoicing object used to determine whether a sales invoice is automatically created from a drop ship invoice once it becomes eligible. The field is only used when INV Create DS SIN When Billing SO is deselected. This must be a checkbox or a formula checkbox field.

Text(255)
INV_Create_DS_SIN_When_Billing_SO__c INV Create DS SIN When Billing SO Pre-Winter 2024 If selected, sales invoices are automatically created when billing a drop ship sales order.

Checkbox false
INV_Create_SIN_Custom_Criteria_Field__c INV Create SIN Custom Criteria Field Pre-Winter 2024 API name of the field on the Invoicing object used to determine whether a sales invoice is automatically created from the Invoice once it becomes eligible. The field is only used when INV Create SIN When Completing Shipment is deselected. This must be a checkbox or a formula checkbox field.

Text(255)
INV_Use_Custom_Mappings__c INV Use Custom Mappings Winter 2024 If selected, Foundation mappings are used when creating sales invoices from invoices. If you have not defined any custom mappings, deselecting can improve performance.

Checkbox true
ITPR_Create_JNL_Custom_Criteria_Field__c ITPR Create JNL Custom Criteria Field Pre-Winter 2024 API name of the field on the Inventory Transaction Perpetual Record object used to determine whether a journal is automatically created from the perpetual record once it becomes eligible. The field is only used if the ITRP Create Journal When ITPR is Created field is deselected. This must be a checkbox or a formula checkbox field. This must be a checkbox or a formula checkbox field.

Text(255)
ITRP_Create_Journal_When_ITPR_Is_Created__c ITPR Create Journal When ITPR is Created Pre-Winter 2024 When selected, as soon as an eligible inventory transaction perpetual record is created, the connector creates a journal for the perpetual record.

Checkbox false
JournalImportBatchSize__c ITPR Journal Import Batch Size Pre-Winter 2024 The number of Perpetual Transactions Imported per batch Apex execute (Default: 50).

Number(4,0) 50
Max_Credit_Note_Lines__c CRINV Sales Credit Note Line Limit Pre-Winter 2024 The maximum number of lines to create on a single sales credit note. If the number of credit invoice lines exceeds this number, additional sales credit notes are created.

Number(18,0) 900
Max_Journal_Lines__c ITPR Journal Line Limit Pre-Winter 2024 The maximum number of journal lines to create on a single journal. If the the number of lines required exceeds this number, additional journals will be created.

Number(18,0) 150
Max_PIN_Lines__c APV Payable Invoice Line Limit Pre-Winter 2024 The maximum number of lines to create on a single payable invoice. If the number of AP voucher lines exceeds this number, additional payable invoices are created.

Number(18,0) 1000
Max_SIN_Lines__c INV Sales Invoice Line Limit Pre-Winter 2024 The maximum number of lines to create on a single sales invoice. If the number of invoice line items exceeds this number, additional sales invoices are created.

Number(18,0) 600
Send_Emails__c Send Emails Pre-Winter 2024 When selected, the connector sends an email notification after creating documents in the background.

Checkbox true
Send_Notifications__c Send Notifications Pre-Winter 2024 When selected, the connector sends a Salesforce notification after creating documents in the background.

Checkbox true
Sync_Accounts_to_Suppliers__c Sync Accounts to Suppliers Winter 2024 If selected, when you create a vendor account, a matching supplier site is automatically created. When you update an existing vendor account, the related supplier site is automatically updated with the relevant values.

Checkbox false
Sync_Supplier_to_Account__c Sync Suppliers to Accounts Pre-Winter 2024 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.

Checkbox false
Validate_AP_Voucher_Lines_When_Matching__c APV Validate While Matching Pre-Winter 2024 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 General Ledger Account, Item, and Product fields on the AP Voucher Line object.

Checkbox false


© Copyright 2009–2024 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.