Configure the analytical code in the customised expense report export

This article is intended for: 

Admin

Module concerned:

Eti_Module_02.svg

Are you configuring a customised expense report export for accounting and would like to modify the analytical codes for each expense in the exported file?

When configuring a customised export of the type 'Expense reports > Accounting', a field allows you to define the content of the 'Analytical code' column.

This field can contain keys that will be interpreted by Eurécia during the export, as well as special characters, spaces and fixed values.

Contents of this article:

 

Customise the analytical code in your export

Access: Admin area > General settings > Customised exports > Export type: accounting

In the 'Accounting options' section, you can define how this field is constructed:

List of keys that can be used

{CAU} Analytical code from the employee record
{CAU2} Analytical code 2 from the employee record
{REF} Reference field from the General tab of the expense report
{CAAX} Analytical code of the analytical account for the selected X axis
{CRAX} Grouping code of the analytical account for the selected X axis
{NOM_CAAX} Name of the analytical account for the selected X axis
{CAAX_LVLY} Analytical code of the analytical account at level Yq of the selected X axis
{CADDUX} Additional X field from the employee record
{CPT_TIERS} Third-party account from the employee record (This option does not exist for the Sage Ligne 100 connector)
{TRIGRAMME} First letter of the first name and the first 2 letters of the surname.
If the surname is double-barrelled: first letter of the first name + first 2 letters of the first surname
TRIGRAMME_COMPOSES} For single first names and surnames: same behaviour as the {TRIGRAMME} key
For double first names: first letter of each first name + first letter of the first surname
For single first names and double-barrelled surnames:
First letter of the first name + first letter of each surname
{MATRICULE} Employee number of the employee associated with the expense report
{DATE_CPTA_JJMMAAAA} Date selected at the time of export in the DDMMYYYY format
{CPTTVA} VAT account
{TAUXTVA} VAT rate: 2 decimal places, full stop as the separator, right-aligned. E.g.: 10.00
{CODE_CPL} Additional code for the selected expense type
{DPT_LVLX} Employee's department at level X
{STR_LVLX} Employee's structure at level X
{DPT} Employee's department
{STR} Employee's structure
{CPT_GENERAL} Expense account for expense lines
VAT account for VAT lines
Centralising or third-party account for third-party lines
{CODE_EXP_REP_TYPE} Expense report type code
{CODE_PROFIL_NDF} Expense report profile code

Other keys will soon be added to these options.

Example of analytical code construction:

NDF {CAU} - {DATE_CPTA_JJMMAAAA} will produce « NDF BERGSONJ - 31052018 »

⚠️ Warning!

Please note that some keys will not be interpreted depending on the data groupings defined for the export. For example, an expense description will not be interpreted if grouping by accounting account is enabled, because several expenses with different descriptions will correspond to a single line.

Was this article helpful?

2 out of 5 found this helpful

Comments

Article is closed for comments.