Configure the label and description in the customised expense report export
This article is intended for:
Related module:
Are you setting up a custom expense report export for accounting, and you want to modify the contents of the label and description columns for each expense in the exported file?
In this article:
Customize the label and description
Access: Admin area > General settings > Custom exports > Export type: accounting
When you set up a custom export of type 'Expense reports > Accounting', fields allow you to define the content of the labels and descriptions for each expense, for both debit and credit.
This field can contain keys that will be interpreted by Eurécia during export, as well as special characters, spaces, fixed values.
In the 'Accounting options' section, you can define how these fields are constructed:
List of usable keys
| {DESCR} | Expense report description |
| {NOM} | Expense report user's last name |
| {PRENOM} | Expense report user's first name |
| {DEBUT} | Start of the expense report period in DD/MM/YYYY format |
| {FIN} | End of the expense report period in DD/MM/YYYY format |
| {TD} | Expense type |
| {CAU} | Employee record analytical code |
| {CAU2} | Employee record analytical code 2 |
| {CPT_TIERS} | Third-party account of the selected payment method |
| {EXPORT_DD} ou {EXPORT_JJ} | Day of the date entered at the time of export in DD format (#1060390) |
| {EXPORT_MM} | Month of the date entered at the time of export in MM format |
| {EXPORT_MM+X} |
Month + X (X = number of offset months) of the date entered at the time of export in MM format (#1065437). The offset is possible from 0 to 9 months. Negative offset using – instead of + in the key. Warning: if the {EXPORT_YY} key is used in the same field, it is affected by the month offset. |
| {EXPORT_YY} | Year of the date entered at the time of export in YY format |
| {EXPORT_YYYY} | Year of the date entered at the time of export in YYYY format (#1055130) |
| {INITIALE_PRENOM} | First letter of the first name |
| {DEBUT_JJMMAAAA} | Start of the expense report period in DDMMYYYY format |
| {FIN_JJMMAAAA} | End of the expense report period in DDMMYYYY format |
| {MOYEN_PAIEMENT} | Label of the payment method used (#1053606) |
| {DEBUT_JJ} | Start day of the expense report in DD format (#1066547) |
| {FIN_JJ} | End day of the expense report in DD format (#1066547) |
| {DEBUT_MM} | Start month of the expense report in MM format (#1066547) |
| {FIN_MM} | Start month of the expense report in MM format (#1066547) |
| {DEBUT_YY} | Start year of the expense report in YYYY format (#1066547) |
| {FIN_YY} | Start year of the expense report in YYYY format (#1066547). |
| {DEBUT_MM+X} |
Month + X (X = number of offset months) of the date entered at the time of export in MM format (#1066547). The offset is possible from 0 to 9 months. Negative offset using – instead of + in the key. Warning: if the {DEBUT_YY} key is used in the same field, it is affected by the month offset. |
| {FIN_MM+X} |
Month + X (X = number of offset months) of the date entered at the time of export in MM format (#1066547). The offset is possible from 0 to 9 months. Negative offset using – instead of + in the key. Warning: if the {FIN_YY} key is used in the same field, it is affected by the month offset. |
| {LIBELLE_DEPENSE} | Expense label |
| {NUM_NDF} | Expense report number (#1055130) |
| {DEPENSE_JJ} | #1079118 Expense day |
| {DEPENSE_MM} | #1079118 Expense month |
| {DEPENSE_AA} | #1079118 Expense year in YY format |
| {COMMENT_DEPENSE} | Expense comment field #1107281 |
| {REF_JUSTIFICATIF} | Receipt number field #1107281 |
| {CAAX} | Analytical axis code. X being the analytical axis number. |
| {CRAX} | Grouping code. X being the analytical axis number. |
| {CODE_PROFIL_NDF} | Expense report profile code |
Example of label construction:
{NOM} {PRENOM} _ {DEBUT} - {FIN} will give “BERGSON John _ 01/01/2018 - 31/01/2018”
⚠️ Warning!
Certain keys will not be interpreted depending on the data groupings defined for the export. For example, the expense label will not be interpreted if grouping by accounting account is enabled, as multiple expenses with different labels will correspond to a single line.
Keywords associated with this article:
export - label - expense report - expense reports - accounting - description - construct - keys - field
Comments
Article is closed for comments.