Report “Inventory Item Series Statement” (Trade Management for Kazakhstan 3.4.5.21)

1. Identification

Purpose. The report generates a statement of inventory balances and movements by inventory item series (batches/expiration dates/serial attributes) as of a specified date or for a period. It answers the questions “which series and quantities are recorded at warehouses,” “how did the series balances change during the period,” and “which documents recorded the movement of a particular series.” This is a service/analytical report: it only reads data from accounting registers and does not modify accounting records or generate documents.

2. Report “attributes” — DCS parameters and fields

A DCS report has no header attributes or tabular sections in the sense applicable to a document. The role of “attributes” is performed by schema parameters, filters, and dataset fields. The typical composition for a report of this class in Trade Management for Kazakhstan is provided below.

2.1. Composition parameters

2.2. Dataset fields (resources and dimensions)

Depending on the report variant, an amount/cost may be added to the resources (for example, valuation of the series balance under account 1330 “Goods”). When value indicators are displayed, amounts are shown in tenge (₸).

3. Forms

DCS reports generally use a single universal form and do not contain their own list/object forms:

If no custom form is defined for the report, the platform uses the default generated DCS report form with the “Report Variant” mechanism of the SSL “Report Variants” subsystem.

4. Key module procedures

The attached evidence does not include the BSL source code or form structure (only the “purpose” facet is available). Therefore, the following is a typical set of handlers for a DCS report in Trade Management; the specific names/lines must be checked in the object module and form module of this distribution.

Report object module:

• ПриКомпоновкеРезультата(ДокументРезультат, ДанныеРасшифровки, СтандартнаяОбработка) — overrides the composition process: programmatic layout generation, substitution of calculated fields, and post-processing of the result (conditional formatting of expired series, etc.).
• НастройкиДляТехническойПоддержки() / variant initialization procedures — registration of predefined report variants.

Report form module:

• ПриСозданииНаСервере(Отказ, СтандартнаяОбработка) — sets the initial period/filter values and restores user settings.
• ПриОткрытии(Отказ) — performs additional command interface configuration.
• ПередФормированием/“Generate” command handler — validates parameters (whether the period is filled in) before composition.

General logic: the report retrieves the composition settings → the layout composer builds a layout from the schema → the composition processor executes a query against the registers → the result is output to a spreadsheet document.

5. Data sources (the report does not generate movements)

The report is not posted and does not create movements—this is fundamental for this object type. It reads register entries already generated by other documents (Purchase of Goods and Services, Sale, Transfer, Goods Receipt/Write-off, etc.).

Main report data sources:

The connection with the Chart of Accounts of the Republic of Kazakhstan appears only indirectly—through inventory balance valuation. Series inventory balances correspond to the debit of account 1330 “Goods”. When analyzing series movement for a sale, the related entries are generated by the recorder documents, not by the report:

• Cost of the disposed series—Dr 7010 “Cost of Sales” — Cr 1330 “Goods”.
• Revenue from the sale of the series—Dr 1210 “Short-term Trade Receivables” — Cr 6010 “Revenue from Sales” and Cr 3130 “VAT Payable” (the Kazakhstan VAT rate from 2026 is 16 %).

Example (to illustrate a value row in the statement). A series of 10 units was sold at a price of 5 000 ₸/unit, with a cost of 3 000 ₸/unit:

• Revenue excluding VAT: 50 000 ₸; VAT 16 %: 8 000 ₸; amount payable: 58 000 ₸ → Dr 1210 58 000 / Cr 6010 50 000 / Cr 3130 8 000.
• Series write-off: Dr 7010 30 000 / Cr 1330 30 000.

The report will only reflect a decrease in the series balance by 10 units and, in the value-based variant, by 30 000 ₸.

6. Related objects and create based on

Reports do not participate in the “create based on” mechanism and have no subordinate objects. Functionally, the report is related to:

• The СерииНоменклатуры catalog—the source of the “Series” analytical dimension; drill-down from report cells to a series item is available.
• Movement documents (Receipt/Sale/Transfer/Goods Receipt/Write-off)—recorders displayed when viewing series turnover details; a turnover row can be drilled down to the document.
• Electronic documents of the Republic of Kazakhstan—ESF (ESF IS) and SNT are generated based on sales/transfer documents; series/batches in them are matched with item lines. The report helps reconcile actual series balances with issued SNT data.
• The SSL “Report Variants” subsystem—storage of variants and settings.

7. Extension points

• Report variants (DCS). Additional predefined/user variants: “Balances as of Date,” “Turnover for Period,” and “Series Approaching Expiration”—without code changes.
• Configuration extension. Addition of custom datasets/fields and parameters through a DCS schema extension; overriding ПриКомпоновкеРезультата for custom formatting.
• Conditional formatting. Highlighting series with zero/negative balances and expired series (based on the expiration-date attribute of the СерииНоменклатуры catalog).
• Drill-downs and navigation. Configuring additional drill-down fields (navigation to the series card, recorder, or movement report).
• Printing/export. Standard mechanisms for saving a spreadsheet document (XLSX, PDF) and distribution through the SSL report distribution subsystem.
• Access rights (RLS). Restricting selections by organizations/warehouses through rights settings; the report inherits the restrictions of the source registers.

Version-specific (requires verification in the specific 3.4.5.21 distribution): the exact list of datasets, availability of value resources, and composition of predefined variants are determined by this report’s composition schema.