Some aspects of FinancialForce Accounting are controlled by custom settings. From Setup, click Develop | Custom Settings. You must be signed in with system administrator permissions to perform these tasks. See the Salesforce Help for information on how to maintain custom settings.
Validate vendor document numbers
You can use the Accounting Settings custom setting to control the validation of the following fields:
- On a payable invoice: Vendor Invoice Number
- On a payable credit note: Vendor Credit Note Number
The default validation on these fields is to warn the user when they have entered a document number that is used on another payable document. This check is performed on:
- All documents of the same type
- For the same vendor account
- For all years and periods
- Across all companies in your organization.
| Field | Description |
|---|---|
| Disable Vendor Document Number Check | Indicates that you want to disable this validation altogether. If selected, all validation on these fields is disabled and the associated checkbox is ignored. If deselected, the application will check for duplicates. |
| Duplicate Vendor Document Number Allowed | Indicates that you want to allow duplicate vendor document numbers. If selected, the user is warned (in Classic View only) when a duplicate document number exists. If deselected, the document cannot be saved when a duplicate document number exists. |
Validation is not case sensitive.
Allow auto sending of sales invoices and sales credit notes as electronic invoices
You can use these custom settings to configure automatic sending of sales invoices and sales credit notes as electronic invoices.
Accounting Settings
|
Field |
Description |
|---|---|
|
Earliest Date to Auto Send E-Invoices |
Specify a cutoff date so that sales invoice and credit notes with an invoice date earlier than this date are not included for automatically sending as electronic invoices. |
|
Queue SIN/SCR to Auto Send as E-Invoices |
If selected, you can queue the sales invoices and sales credit notes and automatically send them as electronic invoices. |
|
E-Invoice automatically send batch size |
Specify maximum number of sales invoices and sales credit notes that can be sent in a single batch. This setting allows you to fine tune batch processing to balance the risk of timeouts during processing with Salesforce governor limits. |
Allow auto sending of payable invoices and payable credit notes as electronic invoices
You can use these custom settings to configure automatic sending of payable invoices and payable credit notes as electronic invoices.
Accounting Settings
|
Field |
Description |
|---|---|
|
E-Invoice Notify Status batch size |
Specify the maximum number of payable invoices and payable credit notes that can be notified to the electronic invoicing provider Storecove in a single batch. If not set, the default value is set to 25. |
Allow deletion of account and products in use
| Field | When selected: |
|---|---|
| Allow Deletion of Accounts in Use | Indicates that you want to allow the deletion of accounts in use. |
| Allow Deletion of Products in Use | Indicates that you want to allow the deletion of products in use. |
Allow modification of print status on sales invoices and credit notes
| Field | When selected: |
|---|---|
| Allow Modification of Print Status | Indicates that the print status of sales invoices and sales credit notes can be modified. |
Control the editing of dimensions and custom sub-analysis fields on posted documents
Use these custom settings to control the editing of dimensions and custom sub-analysis fields on posted documents.
| Field | When selected: |
|---|---|
| Enable Edit Dimensions (after posting) | Indicates that you want to enable the ability to edit analysis dimensions on posted documents. In the case of posted journals, this ability is disabled when one or more currency override values exist on the journal. |
| Enable Edit Sub-Analysis (after posting) | Indicates that you want to enable the ability to edit custom fields that have been set up for sub-analysis mapping Mapping of custom fields at header and line level for the purpose of profitability reporting. on posted documents. |
Control aspects of journal entry
Use these custom settings to control aspects of journal entry.
| Field | When selected: |
|---|---|
| Allow Override when Value is Zero | When a journal line has a value of zero, an override of the Dual and/or an override of the Home or other value on a journal line will be saved. If you subsequently edit the journal line, any override Dual value and/or Home value or other value on a journal line will be saved. When deselected, when a journal line has a value of zero, an override of the Dual value and/or an override of the Home value or other value will not be saved when the journal line is saved. If you subsequently edit the journal line, any override Dual value and/or override Home value or other value on a journal line will not be saved when the journal line is saved. |
| Override Currency Values on Journal Line | Indicates that you want to override currency values at journal line item level rather than at journal header level. By default this custom setting is deselected meaning that you can override currency values at journal header level. Do not switch this custom setting while journals with currency overrides remain In Progress. If you need to change this custom setting from one level to another, post all journals with currency overrides first. |
| Show Debit Credit Indicator | Displays a Debit/Credit indicator on journal line
items so that you can enter all values as positive amounts then specify
whether the line is a debit or credit by selecting the appropriate option
from the Debit/Credit picklist. When deselected, credit values must be
entered with the minus sign (-). By default this custom setting is deselected. You can switch this setting on and off at any time without affecting existing journals. In Extended Edition The view of the application that you see when you install one of the extension packages (such as the Cash Entry Extension package). For invoices, credit notes, and journals Extended Edition is integrated into the main package, but must be configured., the Debit/Credit field must also be included in the Manage Lines field set for the picklist to be displayed. |
| Disable concat GLA-Reporting Code (CIF) |
If selected, disables the concatenation of GLA name and reporting code for Local GLA in the Journal line items. If unselected, concatenates the GLA name and reporting code for Local GLA in the Journal line items. This checkbox is unselected by default. |
| Show Single Debit/Credit column (LWC) |
If selected, it shows a Values column, which consists of both the debit and credit values in the Journal Lightning page. The debit value appears as an integer number and the credit value is prefixed with a “-” sign. If unselected, it shows the Debit and Credit columns separately in the Journal Lightning page. This checkbox is unselected by default. |
| Enable Edit Dimensions (after posting) | If selected, allows you to edit the dimensions in a Journal after it is posted. This checkbox is unselected by default. |
| Override Currency Values on Journal Line (after posting) |
If selected, allows you to override currency values at the journal line item level. When this custom setting is selected, the Journal Rate and Dual Rate fields are displayed on the Journal Line Items Lightning page. This checkbox is unselected by default. This means you can override currency values at the journal header level. For more information, see Journal Fields. |
| Mass Actions Settings |
You can configure the duplicate journal mass actions by updating the following custom fields: Parallel Run - This checkbox is unselected by default. Scope Size - The default scope size is 20. For more information about duplicating journals mass action, see Viewing Journal Lists. |
| Allow use of Local GLAs |
If selected displays the General Ledger Account field along with the Local GLA field in the Journal Line Items tab of the Lightning page provided the Local GLA is configured for the selected company. This checkbox is unselected by default. For more information, see Journal Fields. |
Control the ability to override the product GLA on sales documents
Use this custom setting to enable the ability to override the product general ledger account on opportunities, sales invoice and sales credit note lines. By default, the relevant fields are hidden on the Visualforce pages.
| Field | When selected: |
|---|---|
| Enable Override Product GLA | Indicates that you want to show the Override Product GLA field on opportunity, sales invoice and sales credit note Visualforce pages. |
Exclude selected Apex job classes from company validation
If when trying to change the current company you get an error message telling you that you can't continue while one or more specific batch Apex Jobs are in progress, you have the option of adding a list of Apex Job class names to this field. This has the effect of excluding these batch Apex jobs from this validation. In other words, if the name of a batch Apex job is on this exclude list, you will be allowed to switch company while this process is running. If a batch Apex Job not on this list is running, then you will be prevented from changing company until it finishes.
| Field | Description |
|---|---|
| Disable Select Company Validation List | A list of batch Apex Job class names to exclude from the Select Company validation. The class name must be as displayed on the Apex Jobs monitoring page. Class names must be separated by a comma. |
Adjust enterprise document line thresholds
When working with enterprise documents, you can adjust the threshold at which each process switches between immediate (synchronous) processing and asynchronous batch processing.
| Field | Description |
|---|---|
| Convert to SCR Lines Threshold |
The maximum number of lines on a sales invoice that allows you to convert the invoice to a sales credit note immediately (synchronously). Above this number, the process runs as an asynchronous batch job. If not set, the default maximum number is:
|
| Convert to PCR Lines Threshold | The maximum number of lines on a payable invoice that can be converted to a payable credit note interactively (online). Above this number, the process runs as an asynchronous batch job. The default number of lines is 80. The adjusted threshold must be lower than 80. |
| Discard Credit Note Lines Threshold |
The maximum number of lines on a sales credit note that allows you to discard the note immediately (synchronously). Above this number, the discard process runs as an asynchronous batch job. If not set, the default maximum number is 80.
This setting doesn't apply to Lightning. You can discard sales credit notes of up to 9,980 lines immediately (synchronously). |
| Discard Invoice Lines Threshold | The maximum number of lines on a sales invoice that allows you to discard the invoice immediately (synchronously). Above this number, the discard process runs as an asynchronous batch job. If not set, the default maximum number is 80.
This setting doesn't apply to Lightning. You can discard sales invoices of up to 9,980 lines immediately (synchronously). |
To monitor the progress of an asynchronous batch job, navigate to Setup, then click Monitoring | Apex Jobs. The queue lists any batch jobs that have not finished execution. The Total Batches column lists the total number of batches for the job. The Batches Processed column lists the number of batches that have been processed. See the Salesforce Help for more information.
Sales document line thresholds for synchronous processing
These fields control the maximum number of lines that you can add to a document for processing:
- Synchronously (immediately).
- Asynchronously by the Background Posting Scheduler. If you post a sales document that exceeds the line limit set here, its status changes to "Ready to Post" and the Background Posting Scheduler processes it as part of a scheduled batch.
| Field | Description |
|---|---|
| Intercompany A/R SCR Lines Threshold |
The maximum number of lines you can add to an intercompany A/R sales credit note for posting immediately (synchronously). Above this number, the Background Posting Scheduler posts the document as part of a scheduled batch (asynchronously). If not set, the default maximum number is:
For more information about:
|
| Intercompany A/R SIN Lines Threshold |
The maximum number of lines you can add to an intercompany A/R sales invoice for posting immediately (synchronously). Above this number, the Background Posting Scheduler posts the document as part of a scheduled batch (asynchronously). If not set, the default maximum number is:
For more information about:
|
| Intercompany SCR Lines Threshold |
The maximum number of lines you can add to an intercompany sales credit note for posting and post the note immediately (synchronously). Above this number, the Background Posting Scheduler posts the document as part of a scheduled batch (asynchronously). If not set, the default maximum number is:
For more information about:
|
| Intercompany SIN Lines Threshold |
The maximum number of lines you can add to an intercompany sales invoice for posting immediately (synchronously). Above this number, the Background Posting Scheduler posts the document as part of a scheduled batch (asynchronously). If not set, the default maximum number is:
For more information about:
|
| Sales Credit Note Lines Threshold |
The maximum number of lines you can add to a sales credit note for posting immediately (synchronously). Above this number, the Background Posting Scheduler posts the document as part of a scheduled batch (asynchronously). If not set, the default maximum number is:
For more information about posting documents asynchronously using the Background Posting Scheduler, see |
| Sales Invoice Lines Threshold |
The maximum number of lines you can add to a sales invoice for posting and then post the invoice immediately (synchronously). Above this number, the Background Posting Scheduler posts the document as part of a scheduled batch (asynchronously). If not set, the default maximum number is:
For more information about posting documents asynchronously using the Background Posting Scheduler, see |
Payable document line thresholds for synchronous processing
These fields control the maximum number of lines that you can add to a document for processing:
- Synchronously (immediately).
- Asynchronously by the Background Posting Scheduler. If you post a payable document that exceeds the line limit set here, its status changes to "Ready to Post" and the Background Posting Scheduler processes it as part of a scheduled batch.
| Field | Description |
|---|---|
| Intercompany A/R PIN Lines Threshold |
The maximum number of lines that you can add to an intercompany A/R payable invoice for posting immediately (synchronously). If not set, the default maximum number is:
For more information about intercompany A/R payable invoices, see Using Intercompany Accounts Payable. |
| Payable Credit Note Lines Threshold | The maximum number of lines that can be attached to a payable credit note before the document has to be posted asynchronously by the Background Posting Scheduler. If not set, defaults to 250. |
| Payable Invoice Lines Threshold |
The maximum number of lines you can add to a payable invoice for posting and then post the invoice immediately (synchronously). Above this number, the Background Posting Scheduler posts the document as part of a scheduled batch (asynchronously). If not set, the default maximum number is:
For more information about posting documents asynchronously using the Background Posting Scheduler, see |
Control the minimum number of days between reminders in Collections Plus
The following custom setting can be used to control the frequency you send reminders for an invoice.
| Field | Description |
|---|---|
| Offset Days for Collections Reminders |
The minimum number of days between sending reminders for an invoice. The default value is 5. For example, if you have an invoice that meets two reminder rules, a reminder is sent for the rule closest to the due date. You cannot send a reminder for the send rule until 5 days after the first reminder. |
Control the Collections Reminder Email batch size
The following custom setting can be used to control the number of reminder emails processed in a batch when sending email reminders.
If there are errors when sending emails you can try reducing the batch size to 50.
| Field | Description |
|---|---|
| Collections Reminder Email Batch Size |
The number of emails that are processed in a batch by the Send Email process for collections reminders. The default value is 100. |
Control the Clickjacking Protection for Collections Plus and Payments Plus
This setting controls the loading of a Conga-based document in a new tab in Collections Plus and Payments Plus.
| Field | Description |
|---|---|
| Clickjacking Protection Setting |
Controls the opening of the following documents in a new tab:
This checkbox is disabled by default. For more information, see Collections Plus Fields and Payments Plus - 4. Pay Fields. |
Choose batch Apex Job notification settings
The following fields are used to choose the destination for notifications arising from selected batch Apex jobs, such as the Cancel Payments and Reverse Allocation Transaction processes. You can select more than one.
| Field | Description |
|---|---|
| Chatter Notifications | Create a Chatter post. |
| Email Notifications | Send an email message. |
| Task Notifications | Create a Salesforce task. |
| Generate BPS Email Notifications | Create email notifications for the Background Posting Scheduler. |
| Notification on Objects | Used by the Background Processing Scheduler only. You can enter a list of user emails, separated by semicolons. If the User Group Notifications setting in Background Posting Settings (FF) is set to True, email, task or Chatter notifications are sent to the users in the list. |
Control the handling of batch Apex Jobs
This setting affects selected batch Apex jobs such as the Cancel Payments process.
| Field | Description |
|---|---|
| Maximum Queue Size | Sets the maximum number of batches to process at the same time. By default Salesforce sets this to 5. The minimum value you can enter is 1. |
Set the batch size when calculating Average Days to Pay and Days Sales Outstanding (Annual)
These fields allow you to set a maximum batch size when calculating the values for the Average Days to Pay and Days Sales Outstanding (Annual) fields on account records.
| Field | Description |
|---|---|
| Average Days to Pay Batch Size | The maximum number of accounts that can be processed in one batch. The default is 35. |
| Days Sales Outstanding Batch Size | The maximum number of accounts that can be processed in one batch. The default is 35. |
Control the Year End process
| Field | Description |
|---|---|
| Split Year End into Periods | Indicates that the Year End process runs one period at a time. This is the default behavior. If the number of transactions processed in a year is relatively small (less that one million) you can clear this checkbox to run the year end process for the whole year at once. |
Customize Manage Lines
If your users are using the Extended page layouts when entering sales invoices and sales credit notes, you can create custom field sets to be applied when using Manage Lines. Once you have created a custom field set, you must specify its API name in the appropriate setting below. If you leave a field blank, the default field set will be used in that context. For more information, see Setting up Extended Edition for Sales Invoices and Sales Credit Notes.
| Field | Description |
|---|---|
| CRN Manage Lines (SUT) Field Set | The field set to apply when using the Manage Lines functionality to enter sales credit note line items in an SUT company. |
| CRN Manage Lines (VAT/GST) Field Set | The field set to apply when using the Manage Lines functionality to enter sales credit note line items in a VAT/GST company. |
| CRN Manage Lines (COMB) Field Set | The field set to apply when using the Manage Lines functionality to enter sales credit note line items in a Combined Tax company. |
| Invoice Manage Lines (SUT) Field Set | The field set to apply when using the Manage Lines functionality to enter sales invoice line items in an SUT company. |
| Invoice Manage Lines (VAT/GST) Field Set | The field set to apply when using the Manage Lines functionality to enter sales invoice line items in a VAT/GST company. |
| Invoice Manage Lines (COMB) Field Set | The field set to apply when using the Manage Lines functionality to enter sales invoice line items in a Combined Tax company. |
You can also reduce the time it takes for the Manage Lines page to be displayed by reducing the number of lines that are preloaded. The default is 80 but if users typically enter only a few lines, reducing this number will allow the page to be loaded more quickly. This does not reduce the number of lines that can be added to the document.
| Field | Description |
|---|---|
| CRN Manage Lines Preload | The number of lines that are preloaded when using Manage Lines to enter sales credit note line items. Enter a value between 1 and 80. If any other value is entered, the default of 80 is assumed. |
| Invoice Manage Lines Preload | The number of lines that are preloaded when using Manage Lines to enter sales invoice line items. Enter a value between 1 and 80. If any other value is entered, the default of 80 is assumed. |
Control GLA Filtering on the Payment Selection Page and in Payments Plus
When using the Payment Selection page or the filters in Payments Plus to retrieve transactions for payment, you can search by General Ledger Account. By default, only general ledger accounts of type Balance Sheet where Trial Balance 1 = Liabilities and Trial Balance 2 = Current Liabilities or Long Term Liabilities are retrieved. If necessary, you can remove this restriction so that your GLA search criteria are applied to all GLAs, or all GLAs except those where Type=Profit and Loss.
| Field | Description |
|---|---|
| GLA Filtering in Payment Selection | NO FILTERING (your search criteria will be applied to all GLAs) or EXCLUDE P&L (your search criteria will be applied to all GLAs except those where Type=Profit and Loss). If this custom setting is blank, or any other value is entered, the default behavior applies. This setting is not case-sensitive. |
Hide Dimension Filter Criteria Fields on the Allocation Page
You can hide unused Dimension fields on the Allocation page.
| Field | Description |
|---|---|
| Hide Allocation Dimension 1–4 | Select to Hide Allocation Dimension 1, 2, 3 or 4 depending on what you use. Any Dimensions that you hide will not only be hidden from the filter page but also the allocation screen and the Values Retrieved pop up. Hidden dimensions will not be saved on the template and you will not be able to load a template that has dimension values for hidden dimensions. |
Profitability Reporting
| Field | Description |
|---|---|
| Profitability Report ID | The ID of the profitability report that you want to view for individual accounts and products by using the profitability reporting widget. |
Manage User Access
| Field | Description |
|---|---|
| Disable Permissions on Visualforce Pages | If you are implementing permission sets, once you are ready to go live you must deselect this custom setting. Users will then have access to buttons on Visualforce pages only if their permission sets allow. If you do not deselect this custom setting, users will be able to view buttons on Visualforce pages even if their permission sets do not permit them access. |
Avalara Tax
| Field | Description |
|---|---|
| Avalara Tax calls use account number | If your org is configured to use Avalara for the calculation of Sales and Use Tax (SUT), this setting determines whether the account name or account number is passed to the Cust/Vendor Code in Avalara. By default this custom setting is OFF meaning that account names are passed to Avalara. If you want to pass account numbers instead, turn this custom setting ON and ensure that all account numbers are populated. Avalara will report an error if it is triggered when the account number is blank. |
Avalara VAT Reporting
These fields allow you to set the maximum batch size for the Avalara VAT Reporting integration background processes.
| Field | Description |
|---|---|
| Avalara VAT Reporting Batch Size |
Maximum number of transactions that can be processed in a single batch chunk when generating XML documents for the Avalara VAT Reporting integration. A new XML document is created per batch chunk. For more information on this process, see The default value is 75. |
| Avalara VAT Set Start Date Batch Size |
Maximum number of transactions that can be processed in a single batch chunk when setting the start date for the Avalara VAT Reporting integration. For more information, see The default value is 200. |
Handle Long Product Descriptions on Documents
If your products have long descriptions, you van have problems when they are copied to a line description. Use these custom settings to customize this transition.
| Field | Description |
|---|---|
| Copy Product Description to Line | Copies the product description to the document description, if empty. The default is true. |
| Truncate Description from Left Side | Truncates the copied product description from the left. The default (false) truncates from the right. |
Amend SUT Tax Values on Sales Documents
You can control whether or not it is possible to amend the tax value on a sales document for an SUT company.
| Field | Description |
|---|---|
| Allow Override of SUT Tax Values | Enables/disables the ability to amend SUT tax values on sales invoices and sales credit notes. The default is false. |
Local General Ledger Accounts
You can control whether or not it is possible to configure your org to enable financial reporting to different statutory bodies.
| Field | Description |
|---|---|
| Allow Use of Local GLAs | Enables the ability to set up your org to allow financial reporting to different statutory bodies using local general ledger accounts (also known as alternate GLAs). The default is false. Do not switch this setting off when there are journals with the status "In Progress" because they can fail to post. |
Limit the Number of Transaction Lines When Reconciling Bank Statements
To improve performance, you can limit the number of transaction lines that are displayed when you are reconciling a bank statement.
| Field | Description |
|---|---|
| Maximum Bank Reconciliation Transactions |
The maximum number of transaction lines displayed when reconciling a bank statement. Using Classic The default value is 3000 lines (recommended if using three columns). If you use four columns, we recommend a maximum of 2500 lines. When Using Lightning Experience the default value is 3000 lines and we recommend a maximum of 10000 lines. |
Allow the creation of sales invoices containing inactive products
You can control whether users can create, save and post sales invoices that contain products that have not been marked as Active.
| Field | Description |
|---|---|
| Allow Posting of Inactive Products | If selected, allows you to create, save and post sales invoices that contain inactive products. The default is False. |
Email Invoices or Credit Notes to Senders
If you send invoices or credit notes by email, you can send a copy of the attached PDF to the person that sends the email.
| Field | Description |
|---|---|
| Send a copy of Email PDF to Sender | If selected, a copy of the Email PDF is sent to the sender. |
Multiple Dual Currencies
If you use multiple currencies in your org, you can control whether or not multiple Dual currencies can be defined.
| Field | Description |
|---|---|
| Multiple Dual Currencies | If selected, enables you to define more than one currency as a Dual currency. |
Control the Bulk Posting of Journals
If you have configured an action view to allow you to post journals in bulk, you can control the number of journals that are posted in each batch using this setting. If your journals contain multiple lines, you can reduce the scope size to increase the efficiency of the posting process.
|
Field |
Description |
|---|---|
| Scope Size - Schedule Journal Post | Determines the number of journals that are processed in each batch when scheduling journals to post. The default value is 200. |
Enable Supported Countries for the Plaid Bank Integration
If you are using the Plaid bank integration, you can specify the supported countries to enable using this field.
|
Field |
Description |
|---|---|
| Supported Plaid Country Codes | Stores the regions supported by Plaid, separated by a comma. For more information, see Setting up Plaid Bank Integration. |
Use Multiple Companies Configuration
You can define default tax information for multiple companies. Instead of retrieving the information from the Tax Status field on the Account object, this information is retrieved from the Tax Status field of the Multiple Companies Account Config custom object.
|
Field |
Description |
|---|---|
| Use Multiple Companies Configuration |
If selected, uses the multiple companies configuration to calculate tax on sales and payable documents. The default is deselected. |