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 | When selected: |
|---|---|
| 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 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 EditionThe 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. |
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 have the option to adjust the threshold at which each process switches between being an interactive online process and an asynchronous batch one.
| Field | Description |
|---|---|
| Convert to SCR Lines Threshold | The maximum number of lines on a sales invoice that can be converted to a sales 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. |
| 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 can be discarded interactively (online). Above this number, the process runs as an asynchronous batch job. The default number of lines is 80. |
| Discard Invoice Lines Threshold | The maximum number of lines on a sales invoice that can be discarded interactively (online). Above this number, the process runs as an asynchronous batch job. The default number of lines is 80. |
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 interactive processing
These fields control the maximum number of lines that can be attached to a sales document before it has to be posted asynchronously (by the Background Posting Scheduler). If you post a sales document that exceeds the line limit set here, its status is set to "Ready to Post" and it is batched up for posting by a scheduled job.
When entering sales documents through the user interface, you cannot create a document with more lines that the number specified here except by using Extended Edition and the New Line Item button (not the Manage Lines button). Typically, high volumes are not entered through the user interface.
| Field | Description |
|---|---|
| Sales Credit Note Lines Threshold | The maximum number of lines that can be attached to a sales credit note before the document has to be posted asynchronously (by the Background Posting Scheduler). If not set, defaults to 250. |
| Sales Invoice Lines Threshold | The maximum number of lines that can be attached to a sales invoice before the document has to be posted asynchronously (by the Background Posting Scheduler). If not set, defaults to 250. |
Payable document line thresholds for interactive processing
These fields control the maximum number of lines that can be attached to a payable document before it has to be posted asynchronously (by the Background Posting Scheduler). If you post a payable document that exceeds the line limit set here, its status is set to "Ready to Post" and it is batched up for posting by a scheduled job.
When entering payable documents through the user interface, you cannot create a document with more lines that the number specified here except by using Extended Edition and the New Line Item button (not the Manage Lines button). Typically, high volumes are not entered through the user interface.
| Field | Description |
|---|---|
| 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 that can be attached to a payable invoice before the document has to be posted asynchronously (by the Background Posting Scheduler). If not set, defaults to 250. |
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. |
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. |
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. See Setting up Extended Edition for Sales Invoices and Sales Credit Notes for more information.
| 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 = Balance Sheet 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 may 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 may 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. The default value is 3000 lines (recommended if using three columns). If you use four columns, we recommend a maximum of 2500 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. |