Sales Information

Based on primary documents, information is provided about the actual volumes of sold material values, works, and services, their quantities and cost, broken down by sales business transactions. When specifying the transaction type, the conventional designation of the transaction according to the Transaction Type Directory is used.

The data source is Posted Sales Invoices, Posted Sales Credit Memos, Value Adjustment Acts, Posted Service Invoices, and Posted Service Credit Memos. The export includes data from posted documents filtered by Adjustment = No, Corrective = No, Cancelled = No, Quantity not equal to 0, and Source Code not equal to "Deletion". If a retail sale is made without buyer identification (Registration No. (EDRPOU) = BLANK), the system considers such customer as an end consumer and sets the tax number to the conventional code "100000000000", and the counterparty name to "Non-payer".

According to the file structure, the preview table exports the following subsections separately:

• Sales Invoices
• Sales Invoice Lines
• Tax Totals in Sales Invoices

Sales Invoices

When generating the preview table, the following fields are populated:

Field	Description	Source
Document Code	Specifies the unique document identifier defined by the business entity.	Posted sales document number.
Customer ID	Specifies the unique identification number of the legal entity in the Unified State Register / registration number of the taxpayer's card for an individual / non-resident code.	Registration No. (EDRPOU) field from the Customer Card.
Customer Name	Specifies the name (surname, first name, patronymic (if available)) of the buyer counterparty (if retail sale is made without buyer identification, "end consumer" is stated).	Full Name from the customer card.
Account Code	Specifies the accounting account number of the business entity on which transactions with this counterparty (buyer/payee) are performed.	Populated with the Receivables Account for the customer posting group specified in the document header.
Invoice Date	Specifies the transaction date.	Populated from the Document Date field of the Posted Sales Document.
Document Type	Specifies the name of the primary document (contracts with supplementary agreements and specifications, invoice, expense account, receipts, payment orders, certificates, etc.).	The SAF-T Document Type field is populated in the posted sales document header. The default document type is specified in the Audit File Export Setup; in the sales document header, it is possible to change the document type.
Transaction Type	Specifies the conventional transaction designation.	The transaction type is determined before generating the preview table using the First Event Display in Transaction Types function. The first event determination logic follows the VAT Business Posting Group setup. If no determination method is configured for the VAT Business Posting Group, the transaction type is not populated in the line. If the determination method is Payment or Invoice, the corresponding type is set regardless of the balance. For all other methods — according to the determined first event.
Transaction Code	Specifies the unique transaction identifier defined by the automated software used by the enterprise.	The unique transaction identifier consists of the posted sales document number and the posting date.
GL Posting Date	Specifies the date when the state registration object of the accounting entry is created.	Posting Date.
Accounting Period	Specifies the period to which the transaction must be posted.	Month according to the posting date.
Reporting Year	Specifies the period to which the transaction must be posted.	Year according to the posting date.
Batch Code	Specifies the system transaction number for the record.	Transaction Code in general ledger entries for sales transactions.
Amount Excluding Tax and Shipping	Specifies the total amount excluding taxes and shipping costs.	Populated from the Amount Excluding VAT field of the posted sales document in local currency.
Total Amount	Specifies the monetary valuation of the total cost of products (goods/works, services).	Populated from the Amount Including VAT field of the posted sales document in local currency.

Sales Invoice Lines

When generating the preview table, the following fields are populated:

Field	Description	Source
Document Code	Specifies the unique document identifier defined by the business entity.	Posted sales document number.
Line No.	Specifies the document line number.	Line number of the posted sales document.
Account Code	Specifies the account/sub-account number according to the chart of accounts of the business entity.	For the posted sales invoice and posted service invoice — the Receivables Account for the customer posting group specified in the document header. For the posted sales credit memo and posted service credit memo — the account specified in the Sales Credit Memo Account field of the General Posting Setup. If the line type of the posted sales credit memo is GL Account, the account is taken from the No. field of the corresponding posted sales credit memo line.
Corresponding Account Code	Specifies the corresponding account/sub-account number according to the chart of accounts of the business entity.	For the posted sales invoice and posted service invoice — the account specified in the Sales Account field of the General Posting Setup for the given general business posting group and general product posting group. If the line type of the posted sales invoice is GL Account, the account is taken from the No. field of the corresponding posted sales invoice line. For the posted sales credit memo and posted service credit memo — the Receivables Account for the customer posting group.
Order No.	Specifies the agreement/invoice number, etc.	If the Agreement No. field is populated in the sales document header, the External Agreement No. is populated; if External Agreement No. is not populated — Agreement No. is populated. If the Agreement No. field is not populated, the External Document No. of the posted sales document is populated; if External Document No. is not populated — No. of the posted sales document is populated.
Order Date	Specifies the agreement/invoice date, etc.	If the Agreement No. field is populated in the sales document header, populated from the Agreement Date field; if Agreement No. is not populated — populated from the Document Date field of the posted sales document.
Product Code	Specifies the code from the Ukrainian Classification of Foreign Economic Activity Goods (UCT ZED) / State Classifier of Products and Services (DKPP) (if available) or a unique inventory/product identifier used by the business entity.	Populated from the No. field in the posted sales document line — this is the item number, item charge, resource, or fixed asset sold during the report period. If the sales line Type = GL Account, the item number from the Default SAF-T Item Code field of the GL Account card is populated.
Product Description	Specifies the name of the inventory/product (goods/works, services).	Populated from the Description and Description 2 fields of the posted sales document.
Stock Movement Reference	Specifies the unique reference to inventory movement.	Document number of the inventory movement (Posted Sales Shipment, Posted Sales Return Receipt). Lookup through the Item Ledger Entry No. field in Value Entries for the corresponding posted document line.
Quantity	Specifies the numeric value defined in units of measure.	Populated from the Quantity field of the posted sales document.
Unit of Measure	Specifies the physical quantity defined in units of measure for weight, volume, or other natural indicators.	Populated with the numeric code of the sales unit of measure for items/works/services. The numeric code is configured for each unit of measure in the Units of Measure directory. For Item Charges, the unit of measure is populated from the Charges table, from the Default SAF-T UOM field. If this field value is not populated, the default unit of measure is populated from the Audit File Export Setup.
Conversion Factor from Standard to Base UOM	Specifies the conversion factor from the standard unit of measure (UOMStandard) to the base unit of measure (UOMBase). Not populated if only the base unit of measure (UOMBase) is used in accounting and reporting.	Populated if the sales unit of measure differs from the base unit of measure. The conversion factor is configured in the Item Unit of Measure directory on the item card.
Unit Price	Specifies the unit price of inventories/products (goods/works/services).	Populated from the Unit Price field of the posted sales document line in local currency, excluding VAT and including all discounts.
Tax Liability Date	Specifies the date the tax liability arose.	Tax invoice date according to the sales order number.
Debit/Credit Indicator	Specifies whether the amount at the line level is a debit or credit (for the account/sub-account on which transactions with this counterparty are performed).	For sales invoices — D; for sales credit memos — C.
Description	Specifies the source document line description.	Populated from the Description and Description 2 fields of the posted sales document.
Amount	Specifies the amount for this transaction.	Amount in local currency.
Currency Code	Specifies the three-letter currency code.	Currency code, if different from local.
Currency Rate	Specifies the exchange rate used (amount in currency × exchange rate = amount).	Transaction currency rate.
Invoice Line Amount in Currency	Specifies the monetary valuation of the product value after deducting taxes.	Amount in the original transaction currency.
Tax Type	Specifies the tax type according to the directory.	Populated with the tax code for which VAT = Yes in the SAF-T Tax Types directory.
Tax Code	Specifies the tax code according to the directory.	Populated from the SAF-T Tax Codes field in VAT Posting Setup for the given VAT Business Posting Group and VAT Product Posting Group.
Tax Percentage	Specifies the tax rate as a percentage (if an absolute tax rate does not apply).	Populated from the VAT % field in VAT Posting Setup for the given VAT Business Posting Group and VAT Product Posting Group.
Tax Base	Specifies the tax base amount.	Line amount excluding VAT.
Tax Amount	Specifies the tax amount.	Line amount including VAT minus Line amount excluding VAT.

Tax Totals in Sales Invoices

When generating the preview table, the following fields are populated:

Field	Description	Source
Document Code	Specifies the unique document identifier defined by the business entity.	Posted sales document number.
Customer ID	Specifies the unique identification number of the legal entity in the Unified State Register / registration number of the taxpayer's card for an individual / non-resident code.	Registration No. (EDRPOU) field from the Customer Card.
GL Posting Date	Specifies the date when the state registration object of the accounting entry is created.	Posting Date of the sales document.
Tax Type	Specifies the tax type according to the directory.	Populated with the tax code for which VAT = Yes in the SAF-T Tax Types directory.
Tax Code	Specifies the tax code according to the directory.	Unique Tax Code value from the Sales Invoice Lines section.
Tax Percentage	Specifies the tax rate as a percentage (if an absolute tax rate does not apply).	Populated from the VAT % field in VAT Posting Setup for the given VAT Business Posting Group and VAT Product Posting Group.
Tax Base	Specifies the tax base amount.	Sum of Tax Base field values from the Sales Invoice Lines section grouped by a single tax code.
Tax Amount	Specifies the tax amount.	Sum of Tax Amount field values from the Sales Invoice Lines section grouped by a single tax code.