CSV export formats, Overview
Export | Description | File format | Selection criteria |
---|---|---|---|
Customers |
Exporting customer data with details on contact person |
GBAC15 |
All customers |
Invoice Journal |
Exporting invoice journals only. |
GBAT10 |
All invoices, or just invoices generated since last export |
All Journal Types |
Exports all journal entries including Purchase entries. |
GBAT10 |
All entries, or just entries generated since last export |
Orders |
Exporting orders |
GBAO10 |
All orders, or just orders generated since last export |
Products |
Exporting products |
GBAP15 |
All products |
Suppliers |
Exporting suppliers |
GBAV15 |
All suppliers |
Notes for all formats
The decimal separator for all numerical fields is a full stop: ‘.’
All lines in the formats separated by a semi-colon should be finished with a semi-colon.
If errors occur during import/export, a file named ‘GBAe2apiErrors.txt’ will be created (usually in the folder C:\Documents and Settings\USERNAME\My Documents\). This file contains error messages that can provide information on the nature of the error and when in the process the error occurred.
Read more about: