SAGE LIGNE 1000 format

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 displayed in the export file generated by Eurécia and intended for your accounting software.

Prerequisites

The export file contains 21 fields, none of which require prior configuration.

  • You can define the journal code. 
  • You can enter the auxiliary account and third-party account.
  • You must set the VAT profile to "yes" in the toolbox.

Configuration

Access: Admin Area > General settings > Company record > Subscription tab

1. You can define the journal code for the company, department or structure.

2. You can define the journal code.

3. You can define the analytical code in the employee record.

4. You must set the VAT profile to "Yes".

 

The procedure is complete

 

anoter-ROSE.png  The export described in this guide allows all the items required for accounting to be sent to Sage Ligne 1000 Std.

 

File format

  • PNM file

  • One header line (optional)

  • Date format: DDMMYY

  • Decimal separator: "full stop"

File content

order

field

position

length

comment

1journal code13To be configured in the toolbox
2document date46Posting date to be selected at the time of export
3document type102To be configured in the toolbox
4general account1213 
5account type251G = general; A = analytical; X = auxiliary
6auxiliary or analytical account2613 
7entry reference3913Eurécia document number
8entry description5225  

Prefix from the toolbox + defined in the application's translation file:

{0}=expense claim description,

{1}=surname,

{2}=first name,

{3}=period start,

{4}=period end,userCurre

{5}=period end,userCurre

{6}=expense type

{7}= analytical code2

{8}= expense claim month and year

{9}= document number 
9payment method771S = none; C = cheque; V = bank transfer; E = cash
10due date786Blank
11direction841D = debit; C = credit
12amount in euros8520 
13entry type1051N = normal (hard-coded)
14document number1067Blank
15reserved area11326Blank
16ISO currency code1393EUR = euro (hard-coded)
17amount in currency14220Amount converted into the accounting currency
18ISO currency code of the entry1623Blank
19analytical plan/axis16510 To be configured in the toolbox
20analytical section17525 To be configured in the toolbox
21VAT profile20050 The VAT profile is configured in the supplementary code for the expense type
 

Specific features

  • The header line is optional and the code returned to identify the company can be customised
  • All lines are exported in euros
    • If an expense is entered in another currency, Eurécia converts the amount into euros
  • The export generated from Eurécia may or may not contain analytical lines (selected during configuration)
  • Fields 6, 19 and 20 relating to analytics are populated with values specific to each employee and entered in Eurécia
  • Field 21 relating to VAT is populated using the supplementary code in the expense type

File examples

Was this article helpful?

2 out of 12 found this helpful

Comments

Please sign in to leave a comment.