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 versions
Data types
Conditions
Data must be saved with the code page 1252 Windows Latin 1, otherwise umlauts will not be accepted correctly
An older version of ETRON can be transferred to a newer version of ETRON, but not vice versa
File names are provided with a date / time or a running number
The exchange takes place in a freely definable directory
The field names must be specified as the header line
The order of the fields is arbitrary
Fields that are not needed in any record can be omitted
If the respective configuration requires the presence of certain fields, an appropriate message is output during the import
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
The directory for the data exchange is defined in the basic value ID 612 / Kassendatenaustausch-Verzeichnis
The last value for the journal export is set in the basic value ID 613 / Kassendatenaustausch-Letzte Position
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
The names of the quantity units must match the values stored in ETRON Mengeneinheiten
When the DEP is activated, the format must be updated to version 9
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:
Example
See also product update
Product Groups
Example:
All product groups must always be handed over. Product groups can be seen as a tree structure: Abt → Hwg → Wag.
Example
Customers
Example:
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
Document import
Since the productnames are not taken over from the productmaster, the productnames must be entered in the „Text“ column!
Download:
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
Record type VK / Selling
Record type TX / Textline
Record type RA / product discount
Record type G / Total discount
Record type ZM / means of payment
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
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.
Example 2: Open sale with discount
Open sale means no payment method is given.
Example 3: Open sale with discount and pledge
Open sale means no payment method is given.
Example 4: Closed sale with cash
Closed sale means a payment method is given.
Example 5: Cancellation
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.
Example
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.
Recordtype:
VK = Selling
RT = Cancellation
RA = Discount per product
RG = Discount/overall
TX = Textline
MS = TAX Sum
ZM = Payment method
BZ = Payment
KR = Credit
KB = Credit payment
AG = Deposit / Payment
TA = Daily closing
Example
Error numbers in the response file
Filename: BL*.RES
External invoices
Payments that refer to an external merchandise management must be posted as record type „VK“ and begin with the text specified in the basic value ID 621 / Postionstext externer Belegzahlungen. This is followed by the document number. The maximum length of the text is 25 characters. For longer texts, the document number must be transferred as a text line in the following sentence.
Step 1
Define the article for the external assignment
Create a new article Text1: „Belegzahlung Nr“ VAT: 0
Step 2
Create an export file (BL*.csv) with the entry in the external merchandise management
Sample
Step 3
Select the document in the parked sales
Load parked sales
Step 4
Select the document and go to the checkout with <Enter> / <F10>
External receipt in ETRON
Step 5
Collect the receipt
External receipt as bill
Step 6
Import journaling data to the external merchandise management
The transferred invoice number is then displayed in the journal file with the ETRON document number in the first line of the ETRON document number.
Datum: 08.11.2016 Verfasser: SAM
Importing Products
The AR*.CSV is provided by the WaWi of the customer. To tell ETRON a record change, there are 3 possibilities:
To re-import products and assign a new item number, leave the „Item number“ and „HstEan“ columns blank. ETRON imports these products and creates them with a new article EAN.
To import articles with an existing item number that has less than 7 digits, the item number of the preceding merchandise management system must be entered in the „Artikelnummer“ column.
To import articles with an existing item number that has more than 7 digits, the article number of the preceding merchandise management system is to be entered as EAN in the column „HstEan“.
This article number is entered as a new internal article EAN.
In every case a new product-number will be created.
In order to get the article EANs to the article numbers of the preceding merchandise management system in case 1, it is recommended to make an article export. Open the generated Artikel.dbf with Microsoft® Excel®, read the EAN numbers and add them to the corresponding products of the WaWi.
Examples
Example:
Product-Update
The AR * .CSV is provided by the WaWi of the customer. Before the changed products an additional line with the keyword EANZUORT is entered in the column „Bestellnummer“.
The line with the key value “EANZUORT” in the column “Bestellnummer” above the following product is for updated products only, not for non existing ones!
Download:
Questions
If you have any questions about module „Cashbox Data Exchange“ send an e-mail including a sample file to support@etron.at.
Flowchart
Last updated