Accounting Settings

Some aspects of 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.
Accounting Settings
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.
Warning:

If you disable this setting and duplicate vendor document numbers already exist, they will not be identified.

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.

Note: We recommend the following batch sizes:
  • If the number of lines of the invoice documents does not exceed 200 lines then specify a default batch size of 10.
  • If the number of lines of the invoice documents is less (for instance, less than 10), then increase the batch size up to 200. This will help to minimize the consumption of 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.

Note:  
  • If the payable invoices and credit notes belong to many different companies, reduce the batch size to less than 25 to avoid encountering query limits.
  • If only a small number of companies in the org will be receiving electronic invoices, you can increase the batch size to minimize the consumption of resources.

Allow Deletion of Account and Products in Use

Accounting Settings
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

Accounting Settings
Field When selected:
Allow Modification of Print Status Indicates that the print status of sales invoices and sales credit notes can be modified.

Use Your Own Visualforce Page as a Print Template

If the format of a printed sales invoice or credit note does not suit your requirements, you can override it by developing your own Visualforce pages. See the Force.com platform documentation for more information about Visualforce.

Accounting Settings
Field Description
Custom Sales Invoice Print Template

Specify the name of the Visualforce page you want to use for sales invoices.

When specifying the name, do not use a full URL, but use the following format instead: /apex/xxxxxxxxxxx. For example: /apex/codasalesinvoiceprint.

Custom Sales Credit Note Print Template Specify the name of the Visualforce page you want to use for sales credit notes.

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.

Accounting Settings
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 mappingClosed 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.

Accounting Settings
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 EditionClosed 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.

Warning: Do not switch this custom setting when journals with currency overrides are in progress. Post all journals with currency overrides and then change the custom setting.
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.

Note: When there are journals with the status "In Progress" ensure you do not deselect this setting because the journals might fail to post.

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.

Accounting Settings
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.

Accounting Settings
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.

Accounting Settings
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:

  • Lightning: 800
  • Custom Input Forms: 80
  • Classic: 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 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.

Cash Entry Line Threshold for Synchronous Processing

These fields control the maximum number of lines that you can add to a cash entry for processing:

  • Synchronously (immediately)
  • Asynchronously (as a scheduled batch)
Accounting Settings

Field

Description

Cash Entry Cancel Sync Line Limit The maximum number of cash entry line items that can be canceled synchronously. The default is 150.
Intercompany CE Lines Threshold

The maximum number of lines you can add to an intercompany cash entry for posting immediately (synchronously). Above this number, the posting process runs as an asynchronous batch job. If not set, the default maximum number is:

  • Lightning: 600
  • Custom Input Forms: 250
  • Classic: 80
Post Cash Entry Lines Threshold The maximum number of lines you can add to a cash entry for posting immediately (synchronously). Above this number, the document is posted as part of a scheduled batch (asynchronously). If not set, the default maximum number is:
  • Lightning: 1,000
  • Custom Input Forms: 250
  • Classic: 80
Post CE Lines with Line Charges Sync

The maximum number of lines with line charges that a cash entry can include for posting immediately (synchronously). Above this number, the posting process runs as an asynchronous batch job. If not set, the default maximum number is:

  • Lightning: 500
  • Custom Input Forms: 250
  • Classic: 80
Note:

The maximum number of lines that you can add to a cash entry both for creating and for posting asynchronously might vary. It depends on the Cash Entry Batch Line Limit field in the Document Line Volume Settings protected custom setting.

To change the maximum number, contact Customer Support.

For more information, see Document Line Volume Settings.

For more information about the supported volumes, see Cash Entry Line Volumes.

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.
Accounting Settings
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:

  • Lightning: 800
  • Custom Input Forms: 250
  • Classic: 80

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:

  • Lightning: 800
  • Custom Input Forms: 250
  • Classic: 80

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:

  • Lightning: 800
  • Custom Input Forms: 80
  • Classic: 80

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:

  • Lightning: 800
  • Custom Input Forms: 80
  • Classic: 80

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:

  • Lightning: 1,000
  • Custom Input Forms: 250
  • Classic: 80

For more information about posting documents asynchronously using the Background Posting Scheduler, see About the Background Posting Scheduler.

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:

  • Lightning: 1,000
  • Custom Input Forms: 250
  • Classic: 80

For more information about posting documents asynchronously using the Background Posting Scheduler, see About the Background Posting Scheduler.

Note:

The maximum number of lines that you can add to a sales credit note or sales invoice both for creating and for posting asynchronously might vary. It depends on the following fields in the Document Line Volume Settings protected custom setting:

  • Sales Credit Note Batch Line Limit
  • Sales Invoice Batch Line Limit
  • Intercompany A/R SCR Batch Line Limit
  • Intercompany SCR Batch Line Limit
  • Intercompany A/R SIN Batch Line Limit
  • Intercompany SIN Batch Line Limit

To change the maximum number, contact Customer Support.

For more information, see Document Line Volume Settings.

For more information about the supported volumes, see Sales Credit Note Line Volumes and Sales Invoice Line Volumes.

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.
Accounting Settings
Field Description
Intercompany A/P PCR Lines Threshold

The maximum number of lines that an intercompany A/P payable credit note can include for posting immediately (synchronously). If not set, the default maximum number is:

  • Lightning: 600
  • Custom Input Forms: 250
  • Classic: 80
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:

  • Lightning: 600
  • Custom Input Forms: 250
  • Classic: 80

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:

  • Lightning: 1,000
  • Custom Input Forms: 250
  • Classic: 80

For more information about posting documents asynchronously using the Background Posting Scheduler, see About the Background Posting Scheduler.

Note:

The maximum number of lines that you can add to a payable invoice both for creating and for posting asynchronously might vary. It depends on the following fields in the Document Line Volume Settings protected custom setting:

  • Payable Invoice Batch Line Limit
  • Intercompany A/R PIN Batch Line Limit

To change the maximum number, contact Customer Support.

For more information, see Document Line Volume Settings.

For more information about the supported volumes, see Payable Invoice Line Volumes.

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.

Accounting Settings
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.

DEPRECATED Control the Collections Reminder Email Batch Size

Note:

This field has been deprecated in AccountingSummer 2023. It has been replaced by the Reminder Batch Scope Size field in Collections Plus Settings.

Accounting Settings
Field Description
DEPRECATED: Collections 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.

Accounting Settings
Field Description
Clickjacking Protection Setting

Controls the opening of the following documents in a new tab:

  • Payments Plus print checks page.
  • Collections Plus Conga Add Attachments page.

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.

Accounting Settings
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 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.

Accounting Settings
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.

Accounting Settings
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

Accounting Settings
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.
Enable Year End by Document Currency If selected, the automated year end process creates the year end journals based on the document currency. If it is deselected, the year end journals are created in the home currency.

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.

Note:

These custom setting fields are not used by the line item grid components in Lightning Experience.

Accounting Settings
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.

Accounting Settings
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.

Accounting Settings
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.

Payments Lightning and Payments Plus Settings

Accounting Settings
Field Description
Maximum Transactions Add to Proposal It controls the size of the chunks when preloading transactions. You can reduce this maximum limit if the preloading process is resulting in some timeout errors.
Create Media Data Batch Line Limit It controls the transaction limit to perform the Prepare Electronic action. If there are more transactions than this limit, then the process will be performed asynchronously in the background. If the transactions are within the batch line limit then the process executes instantly.
Maximum Transactions Retrieve It controls the maximum transaction lines that can be retrieved and added to the proposal. It affects the preloading process, add to proposal, and edit proposal processes.

Hide Dimension Filter Criteria Fields on the Allocation Page

You can hide unused Dimension fields on the Allocation page.

Note:

These custom setting fields are not supported in Lightning.

Accounting Settings
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

Accounting Settings
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. See Using the Profitability Reporting Widget for more information.

Manage User Access

Accounting Settings
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

Accounting Settings
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.
Use Mappings Component for External Tax

If selected, the configuration in the related FDN Mappings component is used for external tax calculation. This option is specified on the Tax Calculation Settings page.

You can view or update the mappings from the following tabs:

  • External PCR Tax Mappings
  • External SCR Tax Mappings
  • External PIN Tax Mappings
  • External SIN Tax Mappings

For more information about mappings, see Customizing External Tax Calculation Mappings.

Avalara VAT Reporting

These fields allow you to set the maximum batch size for the Avalara VAT Reporting integration background processes.

Accounting Settings
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 Sending Transaction Data to Avalara VAT Reporting.

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 Setting the Start Date for Sending Transactions to Avalara VAT Reporting.

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.

Accounting Settings
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.

Accounting Settings
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.

Accounting Settings
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.

Accounting Settings
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.

Specify Recipients of Import Statements Schedule Notification Emails

You can specify the email addresses for the recipients who will receive Import Statements Schedule notification emails sent when you connect your bank accounts in Accounting to the physical accounts held at your financial institution using either the Plaid integration or Envestnet integration.

Accounting Settings
Field Description
Import Statements Email Recipients

Stores the email addresses for the recipients who will receive Import Statements Schedule notification emails, separated by either commas or semicolons.

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.

Accounting Settings
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.

Accounting Settings
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.

Accounting Settings
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.

Accounting Settings

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 using this field.

Accounting Settings

Field

Description

Supported Plaid Country Codes Stores the regions supported by Plaid, separated by a comma. For more information, see Setting up the Plaid Bank Integration.

Use Multiple Companies Configuration

You can define default tax, finance contact, credit terms, and accounts payable control and accounts receivable control GLA information for multiple companies.

Instead of retrieving this information from the Account object, it is retrieved from the following fields on the Multiple Companies Account Config custom object:

  • Accounts Payable Control
  • Accounts Receivable Control
  • Input VAT/GST Code
  • Multi-Account Credit Terms
  • Output VAT/GST Code
  • Tax Status

The contacts are retrieved from the multi-account contact records that are associated with the multiple companies account config.

Accounting Settings

Field

Description

Use Multiple Companies Configuration

If selected, uses the multiple companies configuration to:

  • Calculate tax on sales and payable documents
  • Define the following information for multiple companies:
    • Accounts payable control and accounts receivable control GLAs
    • Multi-account credit terms
    • Finance contact

This field is deselected by default.

Notes:
  • For this functionality you must ensure you have enabled the Multiple Companies Configuration feature. For more information, see Enabling Multiple Companies Configuration.
  • Two buttons, Validate Customer and Validate Vendor, validate the Tax Status field on the Account object. However, if you select this custom setting, it is the Tax Status field on the Multiple Companies Account Config object that is validated. For more information, see Custom Account Fields.

Controlling GLA Balance Journal Limits and Scope Size

These settings allow you to control aspects of the creation of balance-based currency revaluation journals.

Field Description
GLA Balances Maximum Journal Lines

Specifies the maximum number of CRV journal lines that can be created before the process creates the balancing journal lines for unrealized gains/losses and currency translation and then creates a new journal. Transaction lines belonging to the same general ledger account will not be split across journals.

The default value is 9,000.

Scope Size - GLA Balances

Specifies the maximum number of transaction lines that can be processed at a time when revaluing general ledger account balances.

The default value is 1,000.