Setup >  Financials >  Accounting interface >  Accounting codes  

Display all Hide all

The purpose of accounting codes is to define the accounting allocation terms for the entries automatically generated by Sage X3.

When associated with the Automatic journals setup, accounting codes are used to specify the accounts to be used on each entry line.
These accounts can be:

  • Fixed: the account is defined as whole in compliance with its setup at the accounts level (e.g.: 601100).
  • Variables: the account includes modifiers (e.g.: 60110x). The modifier (x) is determined by combining the current line with other accounting code lines at the automatic journal setup level. For each automatic journal line set up, the accounting codes to be used and their implementation priority level is defined at the accounting journals level.

SEEREFERTTO See the documentation on the Accounting code lines and Automatic journals.

When an account from the template does not exist in the chart of accounts, it is created automatically by the ERP (if defined in the Chart of accounts setup). Otherwise, the corresponding account record, identified by a title "XXX source document number XXX", will need to be filled in by the user.

Depending on the chosen accounting code entry transaction when entering the function, and on the given accounting codes line, you can enter the account to be allocated to the line for each plan defined in the transaction.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

Presentation

Modifier

The setup of a modifier is meant to specify with "x" the characters to be replaced, with respect to the priorities defined in the automatic journals setup, with the figures related to the other variables.

SEEINFONotes:

  • If no variable has been defined, the "x" are replaced by a 0.
  • It is imperative that the account set up at the Accounts level be not set up with an "x" character, since the "x" character of the account in considered as a modifier.

Example:

  • Coding a purchase of goods account:
    • accounting code,
    • code type,
    • modifier.

Accounting code

Code type

Modifier 

PROD1

Product

607xx05xxxx

France

Supplier

xxxx2xxxxxx

EUR

Currency

xxxxxxxx1xx

20.6

Tax

xxxxxxxxxx1

The purchase account linked to a product PROD1, a French supplier, the EUR currency and a VAT rate of 20.6 will be 60702050101.

Close

 

Fields

The following fields are present on this tab :

Block number 1

  • Type (field TYP)

The type of an account code mentions to which type of data the account code is attached. Each code type is associated with a list of accounts to be set up, in a mandatory way or based on their nature.

For instance:

  • for a "supplier" type code, the purchase collective account must necessarily be entered whereas the collective account of the drafts to be paid is optional, since this payment method is not used systematically.
  • for a "tax" type code, the VAT accounts are mandatory since the VAT posting is generated automatically in some modules.

Similarly, the setup of certain code types, solely intended for the implementation of the account posting templates (accounting modifiers), is left for the user to implement or not.

For instance:

  • the "commercial" type code is only used if a variable referring to the sales person should be integrated to the codification of the sales accounts.
  • the "company" type code is only used if a variable referring to the company concerned should be integrated to the codification of the sales, purchase and inventory accounts.

Based on their requirements, the user creates one or several account codes of a similar type, that will be assigned to the database records concerned.

For instance:

  • a "product" type code by inventory category (raw materials, goods etc.),
  • a "customer" type code by geographical zone (France, EU, Export),
  • a "tax" type code by VAT rate, etc.

When saving the automatic entry, the assignment is performed as follows:

  • search of the "code type" to be retained at automatic journal setup level,
  • search of the "code " to be retained in the database record concerned.

The code is the basic identification key for the account code in the table.

  • Description (field DESTRA)

Standard title of the current record.

  • Short description (field SHOTRA)

The short description replaces the standard description when display or print constraints require it.

By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
You can add your translation in another language using the Translation function:

  • Click Translation from the Actions icon in the corresponding field.
  • In the Translation window, add a new language code with the translation in this language.

A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

SEEINFO The connection language must be defined as a default language for the folder.

Grid Details

  • Account type (field CPT)

Depending on the proposed account type, it is necessary to enter:

  • a collective account,
  • a modifier,
  • a normal account.
  • Description (field ADESIG)

The code is completed by a descriptive title, used for print-outs and entry masks.

  • Mandatory (field OBL)

For the accounting code line, the account entry can be set as mandatory or optional for the displayed charts of accounts.

  • field ACC1

For each of the charts of accounts displayed in column, enter the account to use for the accounting code line.

A line can contain accounts of charts of accounts belonging to different models. Provided a single accounting code can be used for Companies belonging to a different model.

For instance:

Case of a folder having a French and an Italian company, each having its own model (with different social Chart of Accounts):

At the level of the Customer management, the two Companies make a distinction between Customers being: National / EEC / Outside EEC.

For the Customer accounting code Outside EEC, it is possible to plan a transaction to enter accounting codes containing FRA and ITA charts: the accounting line "Customer-Sales" containing the collective account information for France (FRA chart) and for Italy (ITA chart) as well.

Close

 

Reports

By default, the following reports are associated with this function :

  GACCCODE : List of accounting codes

This can be changed using a different setup.

Specific Buttons

The following fields are included on the window opened through this button :

Block number 1

  • field OBJET

 

  • field CLES

 

Block number 2

  • From folder (field DOSORG)

Use this field to define the folder from which the record will be copied. The possible syntaxes are described in the Dedicated appendix.

  • All folders (field TOUDOS)

Use this option to copy the record to all the folders defined in the dictionary (ADOSSIER table of the current solution).

  • To folder (field DOSDES)

Use this field to define the folder to which the record will be copied. The possible syntaxes are described in the Dedicated appendix.

Close

This button is used to copy the accounting code to another folder.

This function is used to change the Entry transaction, provided that the user has the correct access codes.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

 Mandatory field

An account must be entered for this code type. This message opens when Yes is specified in the Mandatory field of the line concerned.

Noncontrol account

This message opens when a standard account has been entered on a line linked to a control account.

Nongeneral account

This message opens when a control account has been entered on a line linked to an account of the account type.

IAS account 411000IAS: No tracking on the plan XXX

This warning message is displayed when entering the account of the chart of accounts XXX, provided that the 411000IAS is not defined as propagating to the chart of accounts XXX.

Tables used

SEEREFERTTO Refer to documentation Implementation