Data export

At the end of every day it is possible to set up export data for bookkeeping and send to email.
The following export formats are available to users:

  • Excel
  • TXT (tab separated)
  • Wings
  • Calculus
  • Pantheon

Export to TXT

Exsporting 2 files, one contains data on documents, and other information about the daily financial report. Columns in the file are separated by tab t

Documents export

The file name for the document data is OCTOPOS_DOC_DATE. txt (the DATE is the date in the YYYYMMDD format, such as OCTOPOS_DOC_20200320. TXT). In case of export for several days, the name of the file is OCTOPOS_DR_DATEFROM_DATETO. txt

# Name Data type Description
1 Organizational unit code string
2  Warehouse code string
3  Warehouse code 2 string If the document is a transfer from one warehouse to another here is the code of the warehouse to which the goods are transferred.
4 Document date date Format YYYYMMDD
5 Date of turnover date Format YYYYMMDD
6 Value date date Format YYYYMMDD
7 Document type code string UF – input invoice, IFU – output invoice services, IF – output invoice products, RP – representation, KS – cash register, OT – write off, PO – inventory, IO – internal delivery
8 Document type name string
9 Internal number int The serial number of the document by type of year. Depending on the setting a special counter can be set for each warehouse.
10 Document number string Combination of ordinal number, type and year, for example: UF 15-2020
11 Number from client string Document number from the supplier code UF
12 Client’s Tax number string
13 Client name string
14 Name of client’s location string If the client has locations and the document is created for a specific location.
15 Product code string Unique product code
16 Product name string
17 Quantity on document decimal(18,4)
18 Quantity to be removed/added to stock decimal(18,4) Some documents make changes to inventory that is not equal to quantity. For example, in the stock checkup , the quantity listed is 10, and the shortage is 1-in this case will write here -1.

Another example is a sales invoice document that is issued with a fiscal account. Because the fiscal account already takes inventory, it will be 0 for all items here.
19 Unit price expressed without VAT. decimal(18,2)
20 Rebate % decimal(18,2) Value between 0 and 100
21 VAT % decimal(18,2)
22 Category name string Example: Bar, Kitchen
23 Hotel bill boolean If it’s a room bill True, otherwise False

Export daily report

The file name for the document data is OCTOPOS_DR_DATE. txt (the DATE is the date in the YYYYMMDD format, such as OCTOPOS_DR_20200320. TXT). In case of export for several days, the name of the file is OCTOPOS_DR_DATEFROM_DATETO. txt

# Name Data type Description
1 Organizational unit code string
2 Date date Format YYYYMMDD
3 Method of payment string Cash, Card, Check, Hotel
4 Amount decimal(18,2)

Export of stock

The file name for the document data is OCTOPOS_STOCK_DATE. txt (the DATE is the date in the YYYYMMDD format, such as OCTOPOS_STOCK_20200320. TXT). In case of export for several days, the name of the file is OCTOPOS_STOCK_DATEFROM_DATETO. txt

Columns in the export of the stock file:

# Name Data type Description
1 Organizational unit code string
2 Warehouse code string
3 Document date date Format YYYYMMDD
4 Document type code string UF – input invoice, IFU – output invoice services, IF – output invoice products, RP – representation, KS – cash register, OT – write off, PO – inventory, IO – internal delivery
5 Internal number int Document ordinal number based on type and year. Based on settings can be split by warehouse as well.
6 Document number string Combination of ordinal number, type and year, eg: UF 15-2020
7 Product code string
8 Quantity decimal(18,4) When stock is removed here will be negative number, otherwise positive number.
9 Product name string
10 Product VAT % decimal(18,2)
11 Sold product code string When stocks are removed based on product components here will be code for product which have been sold. For example Espresso (code 001) removes 8g of ingredient Espresso KG (code 002). If you sell 1 Espresso, in column 7 will be code 002, in column 8 -0.008, in column 11 001, in column 12 1.

This means that 1 Espresso removes 8g Espresso KG ingredient.

When you sell product which is sold as piece, column 7 and 11 will have same product code.
12 Sold product quantity decimal(18,2)