Format MICROSOFT NAVISION XLS

Introduction

This article provides detailed instructions for configuring the expense export for your expense claims.

The aim is to enable you to configure or find out how to modify the data appearing in the export file generated by Eurécia and intended for your accounting software.

Prerequisites

The export file contains 22 fields, three of which require prior configuration.

  • You must configure the additional fields in the employee records.
  • You must configure the additional fields in the analytical dimensions.

Configuration

Access: Admin area > General settings > Employee record -> Employment tab

1. You need to complete the fields outlined in red in the employee records.

Access: Admin area > General settings > Analytical dimensions

2. You need to complete the fields outlined in red in the analytical dimensions.

 

The procedure is complete

 

anoter-ROSE.png  The export described in this guide allows all the items required for accounting to be sent to Microsoft Navision XLS.

 

File format

  • Excel file (XLS extension)
  • Decimal separator: comma

Header row

A header row will be included in the file and will contain the column labels

File contents

TypeDefault posting entry
Management centrePopulate using the "benefit 1" field in the employee record, renamed "Management centre". Populate on all lines of the expense claim
Posting dateDate of the export.
Document dateExpense date entered in the expense claim dd/mm/yyyy
Document type2 by default
Document no.Expense claim number
External document no.Blank
Account type

"2" for employee third-party accounts.

"0" for the expense accounts in the reimbursement scale

Account no.No VAT account, only expense accounts (reimbursement scale) and third-party accounts (employee record).
DescriptionEurécia label (maximum 30 characters instead of 40). Exclude special characters (-.;":!'_\ / #*...)
Currency codeBlank
Debit amountAmount including VAT 
Credit amountAmount including VAT 
Agency code

"For expense accounts: If the account code of analytical dimension 1 associated with the expense does not begin with ""CV"" or ""CS"" or ""DEV"" or ""CM"", populate using additional field 4, renamed ""agency code"", from the employee record.


Otherwise, populate using the first element (before the |) in the ""Comments"" field, renamed ""Agency code / business code"", present in the analytical account in column ""P"".

Populate all lines of the expense


For third-party accounts: use additional field 4, renamed ""agency code"", from the employee record. "

Service codePopulate using additional field 1 from the employee record. 
Case code

"If the account code of analytical dimension 1 associated with the expense does not begin with ""CV"" or ""CS"" or ""DEV"" or ""CM"", populate using ""additional field 3"", renamed ""department case code"", from the employee record.


Otherwise, populate using the ""Description"" field, renamed ""Case code"", of the account in analytical dimension 1.

Business code

"If the account code of analytical dimension 1 associated with the expense does not begin with ""CV"" or ""CS"" or ""DEV"" or ""CM"", populate using additional field 5, renamed ""business code"", from the employee record.


Otherwise, populate using the second element (after the |) in the ""Comments"" field, renamed ""Agency code / business code"", present in the analytical account in column ""P"".

For third-party accounts: use additional field 5, renamed ""business code"", from the employee record. "

Customer codeBlank
Supplier codeSAL by default
Product codeBlank
Resource codePopulate using additional field 2 from the employee record
VAT %

VAT code present in the reimbursement profile (""supplementary code"" column).

Populate only the expense account lines (not the third-party accounts). Same as column ""P""

 

File examples

Was this article helpful?

2 out of 2 found this helpful

Comments

Please sign in to leave a comment.