Accounting Company Fields

Here is a description of the fields that make up an Accounting company record.

Key: * – Mandatory field; R – Read-only; The number indicates the number of characters that are allowed in this text field, where appropriate.

Field     Description
Acquisition Journal Summarization     The method of summarizing the company's acquisition journals in Fixed Asset Management. The available methods are: Asset Group, Asset Sub-Group, and GLA Configuration.
Allocated Ownership R   Total percentage ownership allocated for this company. Cannot be more than 100%, but can be less.
Depreciation Journal Summarization     The method of summarizing the company's depreciation journals in Fixed Asset Management. The available methods are: Asset Group, Asset Sub-Group, and GLA Configuration.
Disposal Journal Summarization     The method of summarizing the company's disposal journals in Fixed Asset Management. The available methods are: Asset Group, Asset Sub-Group, and GLA Configuration.
Elimination Company     Indicates that this company is an elimination companyClosed A special type of company used when recording intercompany eliminations.. You cannot select (or clear) this checkbox once transactions exist for this company. See About Automated Eliminations for more information.
Intercompany Account     Lookup to the intercompany account that you want to use in intercompany transactions. See About Intercompany Accounts for more information.
Local Chart of Accounts Structure     Lookup to the local chart of accounts structure this company uses (if your org is set up to allow financial reporting to different statutory bodies). For example, if this company is in France, you might have a local chart of accounts structure set up called "Le Plan Comptable". Only active chart of accounts structures are available and a company can only have one active local chart of accounts structure. You cannot change the local chart of accounts structure set on a company if transactions have already been created using the current value. See What is a Chart of Accounts Structure? for more information.
Logo R   Preview of the selected company logo.
Logo URL     Full URL to the location of the logo image stored in the Certinia Documents Folder. A preview of the selected logo is displayed.
Name * 80 Name of the company and primary key.
Org-Wide Effective Date R   Date org-wide exchange rates apply from. Any org-wide exchange rates you create for this company are effective from this date onwards. For internal use only.
Note: If you use Foundations exchange rate groups this field is not needed on your company page layout.
Record Type R   Record type for this company. The record type must be set according to the tax regime in which this company will operate. You must not change the record type once tax amounts have been posted in the company. If your tax regime changes, you will need to migrate your data to a new company. Contact Certinia Customer Support for advice.
Reporting Company R  

Lookup to the reporting company, based on ownership percentage, of the accounting company.

This field is automatically updated if you change the parent company information on the company ownership record.

Note: If you have the Consolidation Structure feature enabled in your org this field no longer automatically updated. Instead, the Reporting Company field is editable and you must update it manually to reflect any structural changes.
Use Org-Wide Exchange Rates    

Indicates that you want this company to use org-wide exchange rates, as opposed to company-specific exchange rates. This is referred to as the company's exchange rate mode. If you want to change the exchange rate mode after company activation, you must use the Change Exchange Rate Mode button on the company detail page. See About Exchange Rates for more information.

Note:

If you use Foundations exchange rates, this field is not needed on your company page layout.

Optional Fields

Field Description
Disable Opportunity Recurring Invoices Indicates that you want to disable the recurring invoiceClosed A special type of sales invoice that you enter only once but that causes several similar sales invoices to be generated automatically. Recurring invoices are typically used to request payment for regular bills, such as an annual maintenance agreement invoiced monthly. Alternatively you can use them to create invoices for scheduled monthly deliveries of products. functionality for this company when a sales invoice is created from an opportunity. If you want to disable this functionality, you must add this field to your company page layout and then select it.
Exchange Rate Group

Lookup to the exchange rate group that you want to use to specify the currency exchange rates for the company. If you want to use Foundations exchange rates, you must add this field to your company page layout.

Note:

The Exchange Rate Group field is listed as an Optional Step. While this field is only applicable when the Foundations Exchange Rates Integration feature is enabled, once the feature is on this field becomes mandatory. Users will not be able to save a new company record without selecting an Exchange Rate Group.

Address Information

Key: The number indicates the number of characters that are allowed in this text field, where appropriate.

Field     Description
City   40 City portion of company address.
Contact Email   255 Email address of the company contact. Must be a valid email address in the form: jsmith@acme.com.
Country   40 Country portion of company address.
Fax   20 Fax number.
Phone   20 Primary phone number for the company. See "Entering Phone Numbers" in the Salesforce Help for more information.
State/Province   20 State or province portion of company address
Street   255 Street address of the company.
Website   255 URI of company website.
Zip/Postal Code   20 Zip or postal code portion of company address.

External Tax Calculation

These fields are included in the relevant tax section depending on the company's record type (VAT, GST, Combined or SUT).

Key: The number indicates the number of characters that are allowed in this text field, where appropriate.

Field     Description
External Tax Company Code   50 If your org and this company are enabled for external tax calculation, you must enter the code that identifies this company in the external tax calculation system.
External Tax Calculation     Set to Enabled if you want to configure this company for external tax calculation. You must also complete the setup described in Setting up External Tax Calculation.

Sales Tax Information

These fields are relevant when the record type is "SUT".

Key: * – Mandatory field
The number indicates the number of characters that are allowed in this text field, where appropriate.

Field     Description
Tax Code     If set, the selected default tax code is applied to each new account created in this company.
Taxpayer Identification Number   20 Federal tax ID number or Employer Identification Number. There is no format validation on this field.

VAT/GST Information

These fields are relevant when the record type is "VAT", "GST" or "Combined".

Key: * – Mandatory field; R – Read-only; The number indicates the number of characters that are allowed in this text field, where appropriate.

Field     Description
Avalara VAT Reporting Start Date R  
Note:

Only applies if the record type is "VAT" and the Avalara VAT Reporting integration is enabled.

Date when this company started sending transaction data to Avalara VAT Reporting using the integration. Any transactions that occurred before this date were not automatically sent to Avalara VAT Reporting.

Enable Place of Supply Rules    

Indicates that you want this company to use the place of supply and reverse charge tax functionality on payable invoices and payable credit notes. Default is deselected.

If selected, all new documents have the Reverse Charge checkbox selected in the document header. Existing documents are not changed.
If this is not checked on a company, you can still enter reverse charge values on a payable document by selecting Enable Reverse Charge on the document header.

Tax Code     If set, the selected default tax code is applied to each new account created in this company.
Tax Country Code *   Code for the European Union country in which this company operates. You can update the entries in this custom picklist.
If you want to specify Greece in this field, note that for the purpose of EU VAT, the correct country code for Greece is "GR". In other situations, you might select the ISO-3166 code "EL" instead.
The country code does not control tax calculations. It is required for the correct reporting of VAT on cross-border trades within the EU. For non-EU countries, it can be used as a memo field.
Tax Registration Number * 20 Identifying number used for tax purposes. There is no format validation on this field.
Tax Registration Number    

Identifying number used for tax purposes. Required for digital submission of UK VAT Return Reports.

VAT/GST Group     Indicates that this company is part of a VAT/GST group. The value of this checkbox is used when deciding where to get the default tax code to use on a sales or payable invoice or credit note. See About Tax for more information.

Default Information

The following bank account and year end defaults can be set for this company.

Key: * – Mandatory field.

Field   Description
Bank Account   Company bank account to use as a default when creating a new cash entry or bank statement. You must select a bank account that belongs to this company.
Retained Earnings GLA   The general ledger account to use as a default retained earnings account during the year end process. You can amend this default at year level. The selected GLA must be of type "Retained Earnings" .
Suspense GLA   The general ledger account to use as a default suspense account during the year end process. There are no residual values in this account when the year end process completes. You can amend this default at year level. The selected GLA must be of a type other than "Retained Earnings" .
Year End Mode   The default processing mode for the year end process. "Full Accounting Code" or "GLA Only". This mode controls the detail and size of the resulting year end journal line items. The default value is "Full Accounting Code".
Note:

You cannot specify the default bank account when setting up a new company – the company bank account records do not exist yet. You can return to this field once the company has been activated and its bank accounts assigned.

Electronic Invoicing

These fields are relevant when your org is enabled for electronic invoicing. For more information, see Sending Sales Invoices as Electronic Invoices.

Key: The number indicates the number of characters that are allowed in this text field, where appropriate.

Field Label

 

Description

E-Invoicing Legal Entity Identifier 255

The identifier generated by your electronic invoicing provider when registering this company (or legal entity) as a sender of electronic invoices.

E-Invoicing Tax Category   A tax category such as standard, zero rated, or exempt. Set it to "standard" unless advised otherwise by Storecove. For the list of possible values, see Storecove's API documentation for tax category:
https://www.storecove.com/docs/#_openapi_tax

Matching Details

The following matching defaults can be set for each company. Matching field defaults are used for both cash and background matching. These fields are only available if you have enabled the Matching from Cash Entry feature using the Feature Console.

Key: * – Mandatory field. B - Used by background matching. C - Used by cash matching

Field  

 

 

Description
Allow Partial Payment When Matching   B   Indicates that Allow Partial Payments is selected when matching.
If you leave this field blank, Allow Partial Payment is not selected by default.
First Match By   B   Customer Reference or Invoice Number. If set to None, defaults to Customer Reference when matching.
Include in Background Matching Scheduler   B   Indicates that company documents can be included in the Background Matching Scheduler. This checkbox is not selected by default.
Matching Date   B   Specifies the default value of the Matching Date field for matching. If you leave this field blank, defaults to Cash Entry Date. Cash Entry Date is only used by matching from the Cash Entry page.
Match Up To   B   Specifies the default value of the Match Up To field when matching for this company. You can select Date, Period or None. If you select None, the Match Up To field defaults to Date when matching.
Matching Currency Mode * B C Currency mode to use as a default for cash and background matching. Can be set to either "Account" or "Document". This custom picklist must remain fixed. Do not add or amend its values.

If you leave this field blank, the currency mode defaults to Account when matching. This is a change from the existing default of Document for background matching.

Then Match Remaining By

  B   Optional secondary matching criteria. If set to None, only the criteria specified in the First Match By field are used when matching.

Accounts Receivable Analysis

The following accounts receivable defaults can be set for this company.

Field   Description
Currency Write-Off GLA   Default general ledger account updated when a user posts a currency write-offClosed Generated when there is a difference in the exchange rate between the date of the invoice and the date of the payment. The invoice and the payment are each converted from the document currency to account, home, and dual currency on the date they are created. Differences are posted to a currency write-off account. to a customer's accountClosed In this context, accounts are organizations or people that you conduct business with, such as customers or vendors. Account is a standard Salesforce object. Certinia accounts can be any Account Record Type.. This field supports corporate and local GLAs.
Currency Write-Off Loss GLA   The currency exchange loss GLA. Required for some countries where currency gains and losses must be differentiated. This field supports corporate and local GLAs.
Dimension 1 to 4   Up to four default analysis dimensionsClosed Custom objects that allow you to analyze the activity in your business in additional ways, such as by cost center, project, employee, or any other business entity important to you. related to each of the default general ledger accounts.
Settlement Discount   Default general ledger account updated when a user posts a settlement discountClosed A discount agreed with the purchaser for payment within an agreed period of time. The value of the discount is posted to a settlement discount account. to a customer's account. This field supports corporate and local GLAs.
Use Currency Write-Off Loss GLA   Checkbox used to enable the Currency Write-Off Loss GLA field to use a specific GLA when the currency exchange results in a loss. Default is deselected.
Write-off   Default general ledger account updated when a user posts a write-offClosed An outstanding, but usually small, amount of money not collected from a customer, typically as a result of a small variance between the cash submitted and the value of the documents matched to it. Differences are posted to a write-off account. to a customer's account. This field supports corporate and local GLAs.

None of the specified general ledger accounts can be of type "Retained Earnings", but the same general ledger account can be specified more than once.

Unrealized Gains/Losses Analysis

The following unrealized currency defaults can be set for this company.

Field   Description
Unrealized Gains/Losses GLA  

The GLA that the unrealized gains and losses are posted to. However, if for the accounting company you select the Use Unrealized Losses GLA checkbox, only use this field for the unrealized gains.

Unrealized Losses GLA   The GLA that the unrealized losses are posted to.
Use Unrealized Losses GLA   If selected, you can choose a GLA in the Unrealized Losses GLA field that unrealized currency losses are posted to.

Credit Terms

From Fall 2019, credit terms are held in Foundations and are editable via a related list. Contact your Administrator if the Credit Terms related list is not available.

See How Accounting uses Credit Terms for an example of how credit terms are applied.

Note:

If credit terms are defined on the customer account they will override the standard terms defined on the company.

If you specify an offset or a discount, you must provide an equivalent base date.

Field Description
Base Date
(1–4)
The base date used to calculate the credit terms.
Days Offset
(1-4)
The number of days past the base date for the described credit terms during which the stated discount will be deducted from payments.
Description
(1-4)
A free text field used to describe up to four sets of credit terms.
Discount
(1-4)
The percentage discount to be deducted if payment is made within these terms.

Audit File

These fields are relevant when you have Localization enabled. For more information, see Using Localization.

Field Label

 

Description

Period From   Lookup to return transactions from a specific date.
Period To   Lookup to return transactions to a specific date.
Year   Lookup to specify which year to return transactions for.

Consolidation

These fields are relevant for your consolidation process.

Key: The number indicates the number of characters that are allowed in this text field, where appropriate.

Field   Description
Short Name 15 The short name identifier for a company within the consolidation group structure chart.
Consolidation Adjustment Company   Indicates that you want this company to be flagged as a consolidation adjustment company. Defaults to unchecked.

Buttons

Button Description
Activate Activates the company, and creates a corresponding company queueClosed A location within the underlying Salesforce platform used to represent a company. When you activate a new company, a corresponding company queue is created. to represent and "own" that company. This is an essential step you must perform before using the company. 

When you click Activate on a new company record, you must enter a unique and meaningful queue name (using no more than 37 characters).
Change Exchange Rate Mode Changes the company's exchange rate mode (company-specific or org-wide exchange rates). You will be prompted to specify the date you want the exchange rates to apply from (the default is today's date). You must use this button after the company has been activated. You cannot edit the checkbox on the company detail page directly after the company has been activated.
Validate Address Validates the company's address to see if it is recognized by the US Postal Service (typically only US and Canadian addresses are recognized). This button is only available if the organization is enabled for external tax calculation and this company's record type is SUT. See Validating Addresses for External Tax Calculation for more information. The Address Validated checkbox is selected if the current address has been validated. This checkbox is read only.
Generate File

Generates the audit file required for localization purposes.

Note: Only when you have Localization enabled. For more information, see Using Localization.
Note:

When you click Activate for the first company record in a single-currency organizationClosed An organization that is not enabled for multiple currencies. If you are unsure, contact your Salesforce administrator., you must enter the ISO code for the company's working currency. When you click OK, the application automatically creates a single, predefined accounting currencyClosed The currency in which your company does business. A company can have more than one accounting currency. record and associates it with the new company. All subsequent companies created within this organization automatically inherit this accounting currency.

Ensure that the currencies of the specified Retained Earnings GLA and the Suspense GLA are set up as one of the accounting currencies of the company.

Foundations Company Fields

The Foundations Company object is a core component of Foundations. Other Certinia apps use this object and add fields, buttons, and functionality to it.

Here is a description of the fields that Accounting adds to the Foundations Company object. For more information about the Foundations Company object, see Companies.

Field Name

Description

Accounting Company

Lookup to the Accounting company to which this Foundations company record relates.