POS Data Exchange
General
The module Kassendatenaustausch (POS Data Exchange) is the easy option to exchange data (master data or document data) with an external merchandise management system and our cash register software.
Features
- Import of product groups, products and customer data
- Import and booking of voucher data
- Export of cash data
The field can also be left empty as start value. The export starts with the current day.
Goods, categories, products, customers, order numbers and supplier numbers are imported. The cash journal and in / out payments are exported.
In the case of document importation in the POS data exchange, the data are parked if no payment is specified. Texts beginning with #IT are information texts and are only displayed in the selection, but are not accepted into the document.
In the training version, no test bookings with the POS Data Exchange are possible.
Format version
9
Format
CSV
Delimiter
Tabulator
Decimal separator
.
Thousands
none
Codepage
1252 Windows Latin 1
Format versions
Format version
ETRON Version
Changes
1
5.694
Basic functions
1
5.696
Validation of various import fields and return of corresponding error number
7
5.697
Document import record type „EA“ / deposits/payouts
Example set „EA“ in BL4716.csv
Order number in product import
Supplier number in product import
Extension of the error numbers ERR 11 to ERR 17
8
5.698
The position price and discounts can have the maximum decimal places set for sales.
Extension of ERR 18
9
The RKSV is supported as of this version
In the BL * .RES file, a message with „MSG“ can be displayed in the text field if the status is OK. This message must be displayed to the user and requires an action by the user.
Enhancements to feedback ERR19
The text field for feedback is extended to 150 characters
Data types
type
decimal places
Description
num
0..3
Number with decimal places
date
Date in yyyy-mm format
char
Alphanumeric
bool
Logical: J / N
Conditions
- 1.Data must be saved with the code page 1252 Windows Latin 1, otherwise umlauts will not be accepted correctly
- 2.An older version of ETRON can be transferred to a newer version of ETRON, but not vice versa
- 3.File names are provided with a date / time or a running number
- 4.The exchange takes place in a freely definable directory
- 5.The field names must be specified as the header line
- 6.The order of the fields is arbitrary
- 7.Fields that are not needed in any record can be omitted
- 8.If the respective configuration requires the presence of certain fields, an appropriate message is output during the import
- 9.The values of the department Department/Main Equipment Group/Department (Abt/Hwg/Wag) must be indicated in two digits Update in Version 5.710: The values can now also be 1-digit
- 10.The directory for the data exchange is defined in the basic value ID 612 / Kassendatenaustausch-Verzeichnis
- 11.The last value for the journal export is set in the basic value ID 613 / Kassendatenaustausch-Letzte Position
- 12.The exchange of the document data takes place automatically in the background. For this purpose, the base value ID 619 / Kassendatenaustausch-Autom. Verarbeitung has to be activated
- 13.
- 14.When the DEP is activated, the format must be updated to version 9
- 15.Always use the latest format version
Recommendations
If the document data is to be automatically posted - the payment medium is transferred, then the basic value ID 122 / Centausgleich to Nein (No) and the basic value ID 626 / Standardbeleg automatisch drucken to Ja (Yes).
Master data
General
In order for the master data to be automatically updated, the file STM.RDY must be created with no or any content after creating the data files. After the master data has been posted, the import files are deleted from the import. The next data provision is not allowed until the file has been deleted. To import the ma
Products
Example:
ar.csv
340B
Binary
no.
Description
Max length
Type
Required
Value(s)
Description
Record
1
Artikelnummer
6
num
no
Item number
2
Artikeltext
50
char
yes
Item name
3
Ekp
13/2
num
no
Purchase price / piece
4
Vkp
13/2
num
no
Selling price / piece
5
MwSt
5/2
num
no
VAT
6
Abt
2
num
yes
Department
7
Hwg
2
num
yes
Main product group
8
Wag
2
num
yes
Product group
9
Meh
3
char
no
Unit of measure
9
HstEan
140
char
no
Distributor EAN (with : separated)
10
Bestellnummer
16
char
no
Order number of the supplier
11
Lieferantennummer
5
num
no
Supplier number
12
Zusatztext
64000
char
no
Additional text (up to 50 characters / line)
13
Lgb
9/2
num
no
Stock
14
Aktiv
1
num
no
0, 1
0=Inactive, 1=Active
Example
Artikelnummer
Artikeltext
Ekp
Vkp
MwSt
Abt
Hwg
Wag
Meh
Bestellnummer
Lieferantennummer
HstEan
Zusatztext
Lgb
Aktiv
500
Golden Delicius
0.5
12.00
10
12
1
2
Stk
ABC
0
4050300003061:9002219040304
7
1
502
Birne Forelle
0.7
15.45
10
12
2
2
Stk
DEF
0
9001888100289
Textzeile
Textzeile 2
12
1
505
Umlaute ÖÄÜöäüß
0
0
10
12
2
2
Kg
0
0
Product Groups
Example:
wg.csv
230B
Binary
All product groups must always be handed over. Product groups can be seen as a tree structure: Abt → Hwg → Wag.
no.
Description
Max length
Type
Required
Value(s)
Description
Record
1
Abt
2
num
yes
Department
2
Hwg
2
num
yes
Main product group
3
Wag
2
num
yes
Product group
4
AbtText
20
char
yes
Department-text
5
HwgText
20
char
yes
Main product group-text
6
WagText
20
char
yes
Product group-text
Example
Abt
Hwg
Wag
AbtText
HwgText
WagText
10
02
03
Abteilung 10
Hwg 02
Warengr. 03
10
02
04
Abteilung 10
Hwg 02
Warengr. 04
12
01
01
Obst
Apfel
Rot
12
01
02
Obst
Apfel
Grün
12
02
01
Obst
Birnen
Williams
12
02
02
Obst
Birnen
Forelle
Customers
Example:
ku.csv
379B
Binary
no.
Description
Max length
Type
Required
Value(s)
Description
Record
1
Kundennummer
6
num
no
Customer number
2
Anrede
7
char
no
Hr., Fr., Fa, …
Salutation
3
Titel
30
char
no
Dr., Ing, …
Title
4
Vorname
30
char
no
Given Name
5
Nachname
30
char
yes
Surname
6
Name2
30
char
no
Name2
7
Name3
30
char
no
Name3
8
Adresse
30
char
no
Adress
9
Plz
10
char
no
ZIP
10
Ort
30
char
no
Town
11
Land
30
char
no
Country
12
E-Mail
70
char
no
E-mail-adress
13
UID
20
char
no
UID
Title + Given Name + Surname may be maximum 30 characters long.
For companies, the company name is written under surname. If the space is not sufficient, the fields Name2 and Name3 can be used.
If a 6-digit customer number is to be transmitted, the fieldlength in ETRON must be changed by default from 5 to 6 digits.
Example
Customer number
Anrede
Titel
Vorname
Nachname
Name2
Name3
Adresse
Plz
Ort
Land
E-Mail
Telefon
Mobil
2
Fa.
Testsystem GmbH
Abteilung XYZ
Computerstraße 1
40502
Berlin
Deutschland
+49 1 4423423
Document import
Since the productnames are not taken over from the productmaster, the productnames must be entered in the „Text“ column!
Download:
bl4711.csv
817B
Binary
bl4712.csv
238B
Binary
bl4713.csv
297B
Binary
bl4714.csv
337B
Binary
bl4715.csv
301B
Binary
bl4716.csv
199B
Binary
bl4717.csv
317B
Binary
no.
Description
Max length
Type
Required
Value(s)
Description
Record
1
Satzart
2
char
yes
Header line
2
Kundenummer
6
num
no 1)
Customer number
3
Mitarbeiter
5
num
yes
Employee numer
4
RaAnr
10
char
no
Billing address Salutation
5
RaNa1
30
char
no
Billing address Surname
6
RaNa2
30
char
no
Billing address Name2
7
RaNa3
30
char
no
Billing address Name3
8
RaStr
30
char
no
Billing address Adress
9
RaPlz
10
char
no
Billing address ZIP
10
RaOrt
30
char
no
Billing address Town
11
RaLnd
30
char
no
Billing address Country
12
RaUid
30
char
no
Billing address UID
13
Artikelnummer
6
num
no 2)
Productnumber
14
Menge
9/3
num
no 3)
Sold units
15
Meh
3
char
no
Quantity unit
16
Vkp/Stück
13/2
num
no 4)
Selling price / piece
17
MwSt
5/2
num
no 5)
VAT
18
Text
50
char
yes 6) 7)
Posting-, productname
1) Required for record type KZ
2), 3), 4), 5), 6) Required for record type VK
7) Record type ZM: a cash entered in the means of payment
Record type VK: the productname
Record type TX: the additional text
Record type KZ / Header line
Field
Note
Kundenummer
The customer number must be a valid number entered in the customer master or 0.
Mitarbeiter
The employee number must be a valid number entered in the employee's ID.
Ra*
If a valid customer number is specified, the invoice address data is not required.
RaLnd
The country must be registered in German: „Österreich, Deutschland, Ungarn, …“. For „Austria“/„Österreich“ the field can remain empty.
Menge
Formatversion, Value 8
Record type VK / Selling
Field
Note
Artikelnummer
The item number must be a valid number entered in the item master.
Menge
Sold quantity, returns are posted with negative quantity.
Meh
Quantity unit „STK“, „KG“, …
Vkp/Stück
Price per piece including VAT
MwSt
VAT as percentage
Text
Booking text. Maximum of 25 characters.
Since the productnames are not taken over from the productmaster the product description has to be entered!
Record type TX / Textline
Field
Note
Text
Booking text
Record type RA / product discount
Field
Note
Vkp/Stück
Discount. Negative value including VAT
Text
Booking text
Record type G / Total discount
Field
Note
Vkp/Stück
Discount. Negative value including VAT
Record type ZM / means of payment
Text
Vkp/Stück
Paid value
The payment method „BAR“ is used to indicate the amount paid in cash. If too few means of payment are indicated, the remainder is considered as bar. The means of payment are all the means of payment indicated in the basic value definitions Zahlungsmitteln (Payment methods).
If no payment method is specified, the import is parked and can be loaded and booked in the cash desk. Texts beginning with #IT are in this context infotexts which are displayed when loading but are not accepted to the document.
Cancellation bookings
If a cancellation is sent, the amount and the amount of the payment medium must be negative values.
Record type EA / Deposit/Payout
Text
Valid payment method entered in Zahlungsmitteln (Payment methods). A note can be specified in brackets. The maximum length of the note is 22 characters.
Vkp/Stück
Value (Deposit positive, payout negative)
An EA booking can not be mixed with a normal document.
There can only be one EA booking per file.
Examples
Example 1: Open sale
Open sale means no payment method is given.
Satzart
Mitarbeiter
Customer number
RaAnr
RaNa1
RaNa2
RaNa3
RaStr
RaPlz
RaOrt
RaLnd
RaUid
Artikelnummer
Menge
Meh
Vkp/Stück
MwSt
Text
KZ
1
0
Kunde1
Strasse1
2082
Hardegg
Österreich
8
VK
1
1
Stk
18,26
0
Belegzahlung Nr 104371
Example 2: Open sale with discount
Open sale means no payment method is given.
Satzart
Mitarbeiter
Customer number
RaAnr
RaNa1
RaNa2
RaNa3
RaStr
RaPlz
RaOrt
RaLnd
RaUid
Artikelnummer
Menge
Meh
Vkp/Stück
MwSt
Text
KZ
1
0
Fa.
Test & Co
Hr. Testmann Hermann
Sonstwogasse 10/12
1010
Wien
Österreich
ATU123456
8
VK
1
0
0
Rechnung Nr. 123456
VK
1002
2
Stk
12.00
20
Testartikel 1
RA
-2.00
Discount
VK
1001
3
Kg
9.00
10
Testartikel 2
Example 3: Open sale with discount and pledge
Open sale means no payment method is given.
Satzart
Mitarbeiter
Customer number
RaAnr
RaNa1
RaNa2
RaNa3
RaStr
RaPlz
RaOrt
RaLnd
RaUid
Artikelnummer
Menge
Meh
Vkp/Stück
MwSt
Text
KZ
1
0
Fa.
Test & Co
Hr. Testmann Hermann
Sonstwogasse 10/12
1010
Wien
Österreich
ATU123456
8
VK
1002
1
STK
100
20
Testartikel 1
RG
-2,5
0
Skonto
TX
VK
3504
2
0,5
20
pledge
Example 4: Closed sale with cash
Closed sale means a payment method is given.
Satzart
Mitarbeiter
Customer number
RaAnr
RaNa1
RaNa2
RaNa3
RaStr
RaPlz
RaOrt
RaLnd
RaUid
Artikelnummer
Menge
Meh
Vkp/Stück
MwSt
Text
KZ
1
0
8
VK
1
2
Stk
12.00
20
Testartikel 1
ZM
30.00
BAR
Example 5: Cancellation
Satzart
Mitarbeiter
Customer number
RaAnr
RaNa1
RaNa2
RaNa3
RaStr
RaPlz
RaOrt
RaLnd
RaUid
Artikelnummer
Menge
Meh
Vkp/Stück
MwSt
Text
KZ
1
0
8
VK
1
-2
Stk
12.00
20
Testartikel 1
ZM
-24.00
BAR
Import result
Filename: BL*.RES
After the BL*.csv file is written, a file with the same filename and any content or null must be created with the .RDY extension. When this file is created, the data is imported. After the import the .RDY file will be deleted. From this point, the result of the import is available in the same file name with the extension .RES.
Nr.
Description
Max length
Typ
Value(s)
Description
Record
2
Belegnummer
15
num
Document number in the ETRON system
3
Text
50
char
Result / error
Example
Status
Belegnummer
Text
OK
1600070
OK
Journal
Filename: JO*.CSV
In order to get the journal data from automatic processing, the file JRN.RDY must be created with any content or null and written to the exchange directory. After the journal file has been created, the JRN.RDY file is deleted. From this point, the data may be accessed.
If a retroactive export is to be carried out, the desired date must be entered in the basic value-ID 613 / Kassendatenaustausch-last position
The format for this is: yyyymmddssssssssss year/month/day/sequencenumber. Example: 20160801000000000.
Since a separate exchange of data can be carried out in each ETRON, no entry of the station or branch is included in the journal file. It is therefore not possible to carry out the exchange for branches in a central office or to assign branches to the journal files.
Nr.
Description
Max length
Typ
Value(s)
Description
Record