Difference between revisions of "Accounting export template CegidEcrexcel"

Jump to: navigation, search
(Example of output file)
(Output file description)
Line 1: Line 1:
 
=Introduction=
 
=Introduction=
 
This page described the [[Accounting-export-template-list|accounting export template]] CEGID - ECREXCEL.
 
This page described the [[Accounting-export-template-list|accounting export template]] CEGID - ECREXCEL.
 +
 +
=Default Journal=
 +
ODS
  
 
=Output file description=
 
=Output file description=

Revision as of 18:41, 17 November 2019

Introduction

This page described the accounting export template CEGID - ECREXCEL.

Default Journal

ODS

Output file description

  • Encoding charset: UTF-8
  • Field character separator: ;
  • Fields:
Name Length (in character) Description
Accounting journal 3 OpenFlyers export code
Date Format is DD/MM/YYYY
General export account 17 The first three starting characters of the export account
Auxiliary export account 17 For a "411" export account, it's the characters following it. Otherwise, an empty string
Flow id 35
Description 35
Debit 20
Credit 20

Example of output file

VTE;12/07/2013;411;0189;67;Principal DUPOND DUPOND;99.17;
VTE;12/07/2013;706;;68;Heures de vol F-XXX1;81.67;
VTE;12/07/2013;706;;69;Instruction Vol ;17.50;
VTE;13/07/2013;411;0021;70;Principal JEAN JEAN;81.67;
VTE;13/07/2013;706;;71;Heures de vol F-XXX2;70.00;
VTE;13/07/2013;706;;72;Instruction Vol;11.67;
VTE;13/07/2013;411;0021;73;Principal JEAN JEAN;80.00;
VTE;13/07/2013;706;;74;Heures de vol F-F-XXX2;80.00;
VTE;13/07/2013;706;;77;Heures de vol F-F-XXX2;70.00;
VTE;13/07/2013;411;EXTERNE;78;pilotes heures de vol;70.00;
VTE;14/07/2013;411;0079;83;Principal DUBOIS DUBOIS;77.92;
VTE;14/07/2013;706;;84;Heures de vol F-XXX1;64.17;
VTE;14/07/2013;706;;85;Instruction Vol;13.75;