Description

Returns invoice and customer account data for a given date range in DATEV-compatible format for accounting export. Results can be returned as detailed line data or as summary totals only. This API call requires the DATEV API Calls system setting (BookExportDatevActive) to be enabled. If the setting is disabled, an error result is returned instead of invoice data.

Request Parameters

#	Name	Type	Required	Example	Description
1	DateFrom	datetime	1	2024-01-01 00:00:00	Invoice date or customer account event date range start (inclusive).
2	DateTo	datetime	1	2024-01-31 23:59:59	Invoice date or customer account event date range end (inclusive).
3	ShopId	string	0	WEB	Filter results to a specific pixi shop ID. If NULL, all shops are included.
4	ShowOnlySums	bit	0	0	Controls the level of detail returned. 0 = detailed line data (default), 1 = summary totals only.
5	Country	string	0	DEU	Filter results to customers from a specific country code. If NULL, all countries are included.
6	InvoiceNr	string	0	INV-2024-001	Filter results to a specific invoice number. If NULL, all invoices are included.
7	OrderNrExternal	string	0	EXT-12345	Filter results to a specific external order number. If NULL, all orders are included.
8	BookKeepingAccount	string	0	8400	Filter results to a specific bookkeeping account number. If NULL, all accounts are included.
9	CostCenter	string	0	KST01	Filter results by cost center (Kostenstelle). If NULL, all cost centers are included.

Request body

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:dem="https://api.pixi.eu/soap/demosandbox/">
   <soapenv:Header/>
   <soapenv:Body>
      <dem:pixiGetDatevExportInvoices>
         <dem:DateFrom>2024-01-01 00:00:00</dem:DateFrom>
         <dem:DateTo>2024-01-31 23:59:59</dem:DateTo>
         <dem:ShopId>WEB</dem:ShopId>
         <dem:ShowOnlySums>0</dem:ShowOnlySums>
         <dem:Country>DEU</dem:Country>
         <dem:InvoiceNr>INV-2024-001</dem:InvoiceNr>
         <dem:OrderNrExternal>EXT-12345</dem:OrderNrExternal>
         <dem:BookKeepingAccount>8400</dem:BookKeepingAccount>
         <dem:CostCenter>KST01</dem:CostCenter>
      </dem:pixiGetDatevExportInvoices>
   </soapenv:Body>
</soapenv:Envelope>

Response

Body 1: Invoice and Customer Account Data

Returned when the BookExportDatevActive setting is enabled. One row per invoice line or summary entry.

#	Name	Type	Description
1	Source	string	Source of the record: invoices, vouchers, shipping costs, or customer account events.
2	OrderCurrency	string	Currency code of the order.
3	InvDate	datetime	Invoice creation date.
4	Country	string	Country code from the shipping address.
5	MwstSatz	int	VAT rate code: 1 = high VAT, 2 = low VAT, 3 = no VAT.
6	Sign	string	Sign of the amount: positive or negative.
7	Price	money	Absolute amount.
8	PriceInCents	bigint	Absolute amount in cents.
9	VatCode	int	Bookkeeping account for VAT.
10	BookKeepingAccount	string	Bookkeeping account number.
11	AccountNrItems	string	Bookkeeping account number for items.
12	InvoiceNr	string	Invoice number.
13	Empty1	string	Not used. Reserved for DATEV format compatibility.
14	InvoiceDate	datetime	Invoice creation date.
15	CustomerNr	string	Internal pixi customer number.
16	Empty2	string	Not used. Reserved for DATEV format compatibility.
17	Empty3	string	Not used. Reserved for DATEV format compatibility.
18	Empty4	string	Not used. Reserved for DATEV format compatibility.
19	Skonto	int	Not used. Reserved for DATEV format compatibility.
20	InvText	string	Invoice note text.
21	OrderNrExternal	string	External (shop) order number.
22	CustomerName	string	Customer name.
23	Firstname	string	Customer first name.
24	Lastname	string	Customer last name.
25	VatID	string	Customer VAT ID from billing address.
26	Gegenkonto	string	Contra account number for the shop.
27	IsEU	bit	EU country flag: 1 = EU country, 0 = non-EU country.
28	CntCodeISO2	string	ISO 3166-1 alpha-2 country code.
29	ExchRate	decimal	Currency exchange rate applied to the invoice. Empty if home currency was used.
30	CostCenter	string	Cost center number for the shop.

Body 2: Error Information

Returned instead of Body 1 when the BookExportDatevActive setting is disabled.

#	Name	Type	Description
1	Status	string	Always "ERROR" when the DATEV setting is not enabled.
2	StatusMessage	string	Always: "Setting "DATEV API Calls" (BookExportDatevActive) is not enabled."

Additional Notes

This API call requires the system setting BookExportDatevActive to be enabled.
If disabled, Body 2 is returned and no invoice data is exported.

ShowOnlySums controls the result granularity:
  - 0 (default): returns one row per invoice line (detailed data).
  - 1: returns summary totals only.

Empty1, Empty2, Empty3, Empty4, and Skonto fields are always empty.
They are included to maintain DATEV file format column positions.

InvDate and InvoiceDate both refer to the invoice creation date and will typically have the same value.