1. Identification
| Parameter | Value |
|---|---|
| Object Type | Report |
| Name | DataReconciliationOfGoodsOrganizationsAndAccounting |
| Full Name | Report.DataReconciliationOfGoodsOrganizationsAndAccounting |
| Alias | Reconciliation of goods data of organizations and accounting (in the interface — “Reconciliation of TMZ according to accounting data and the register 'Goods of organizations (Accounting)'”) |
| Configuration | Accounting for Kazakhstan, edition 3.0, version 3.0.74.2 |
| Schema Basis | Data composition system (DCS) / extended tabular report with grouping settings |
Purpose. The report is designed to identify discrepancies between the accounting data of inventory (TMZ) and the operational (warehouse) accounting data recorded in the accumulation register 'Goods of organizations (Accounting)'. It compares balances and turnovers of inventory accounts from the chart of accounts with balances of the corresponding register by nomenclature, warehouses, characteristics, batches, and (if necessary) customs declaration numbers. It is used by accountants and controllers for periodic reconciliation (monthly, quarterly, annually), during the closing of periods, and when discrepancies in nomenclature analytics are detected — to ensure that the accounting and warehouse contours of inventory accounting match.
Where to find in 1C:
- Section “Nomenclature and Warehouse” → “Reconciliation of TMZ according to accounting data and the register 'Goods of organizations (Accounting)'”.
- Navigation link:
e1cib/list/Report.DataReconciliationOfGoodsOrganizationsAndAccounting
2. Attributes and Table Parts
The report stores its settings in the header attributes and table parts. Default values are set in the form and/or report variants.
2.1 Header Attributes (Settings)
| Name | Type | Mandatory | Purpose |
|---|---|---|---|
| StartPeriod | xs:dateTime (Date) |
Not checked (DontCheck) | Date of the start of the reconciliation period; sets the lower time limit for analyzing balances and movements of goods |
| EndPeriod | xs:dateTime (Date) |
Not checked | Date of the end of the reconciliation period; together with StartPeriod defines the interval for report generation |
| RepresentationOfListOfOrganizations | xs:string (String) |
Not checked | Text representation of selected organizations for output in the report header; service field for the user |
| RepresentationOfListOfDepartments | xs:string (String) |
Not checked | Text representation of selected departments; used for detailing reconciliation by structural units |
| PlacementOfAdditionalFields | xs:decimal (Number) |
Not checked | Numeric code for the method of placement of additional fields in the layout (vertically/horizontally) |
| DetailingMode | xs:boolean (Boolean) |
Not checked | Enables detailed breakdown of data; allows transitioning from report cells to primary registering documents |
| ListOfAccounts | v8:ValueListType from ChartOfAccountsRef.Standard |
Not checked | List of accounting accounts for which reconciliation is performed; key filter for selecting inventory accounts (in the RK — primarily 1330 'Goods', as well as sub-accounts for inventory accounting) |
| ByCustomsDeclarationNumbers | xs:boolean (Boolean) |
Not checked | Enables grouping/detailing by sources of origin (customs declaration numbers); applied for imported goods |
| ByAccounts | xs:boolean (Boolean) |
Not checked | Enables grouping of data by accounting accounts; separates data by different inventory accounts |
Note on accounts: in the standard chart of accounts of the RK, goods are accounted for on account 1330 'Goods' (inventory — group 1300). The provided evidence features examples '1310/1320' — this illustrates the format of the list of accounts; the actual selection for goods in the RK should be made based on 1330 and its sub-accounts. The value of the field
ListOfAccountsis configured by the user.
2.2 Table Parts
Grouping
Defines the hierarchy and order of grouping the report data (by nomenclature, warehouse, account, characteristic, batch, etc.).
| Name | Type | Purpose |
|---|---|---|
| Usage | xs:boolean |
Flag for the activity of the grouping level; only marked rows are applied |
| Field | xs:string |
Technical name of the data field for grouping (e.g., “Nomenclature”, “Warehouse”) |
| Representation | xs:string |
User display of the grouping field name in the interface |
| GroupingType | EnumRef.GroupingDetailingTypes |
Type of detailing (grouping / detailed records / hierarchy, etc.) |
AdditionalFields
List of additional output fields (nomenclature attributes, characteristics, analytics), placed in the report according to the value of PlacementOfAdditionalFields. Each row contains a usage indicator, technical name of the field and its representation, as well as the type of placement (in groupings / in separate columns).
3. Forms
For reports of this type, a standard set of forms from the data composition system is used in the standard configuration:
| Form | Purpose |
|---|---|
| Report Form (ReportForm / Main) | Main form: period fields (StartPeriod/EndPeriod), selection of organizations and departments, list of accounts, flags ByAccounts and ByCustomsDeclarationNumbers, button “Generate”, area of the tabular document with results and breakdowns |
| Settings Form (SettingsForm) | Extended configuration of structure: groupings, selections, additional fields, formatting, selection of report variant |
| Variant Form / Selection of Variant | Selection and saving of predefined and user-defined report settings |
The specific composition of custom (non-autogenerated) forms is version-specific and requires verification in the configurator of version 3.0.74.2.
4. Key Procedures of Modules
The object module / form module for this version is not attached in the evidence, so below is the typical composition of handlers for the report in DCS (general logic confidently applicable to this type of object):
OnResultComposition(object module) — overriding the composition process: programmatic construction of the layout, merging two data sets (accounting data and data from the register 'Goods of organizations (Accounting)'), calculating the discrepancy column (Accounting − Register).OnCreationOnServer(form module) — initialization of the period (e.g., current month/quarter), filling the list of inventory accounts by default, restoring user settings.Generate/ComposeResult— starting composition: reading header and table part settings, applying selections by organizations/departments/accounts, outputting to the tabular document.BeforeDetailing/ detailing handler — whenDetailingModeis enabled, opening primary registering documents from the report cell.OnChangeFlagByAccounts/OnChangeFlagByCustomsDeclarationNumbers— controlling visibility and composition of groupings depending on set flags.
The exact paths
path:stringand names of procedures will be provided by the analysis of modules of version 3.0.74.2 — requires verification against the source code of the configuration.
5. Data, Registers, and Reconciliation Accounts
Important: this is a report, therefore it does not conduct and does not generate movements in registers and does not create accounting entries. The report only reads data from two sources and compares them.
Sources being reconciled:
- Accounting — turnovers and balances on accounts from the attribute
ListOfAccounts. In the standard chart of accounts of the RK, goods are accounted for on account 1330 'Goods' (analytics: Nomenclature, Warehouse, Characteristic, Batch). If necessary, other inventory sub-accounts from group 1300 may be added to the list. - Accumulation Register 'Goods of organizations (Accounting)' — operational (warehouse) contour of inventory accounting in the same analytical breakdowns.
Logic of result formation: for each dimension (Organization, Warehouse, Nomenclature, Characteristic, Batch, when ByCustomsDeclarationNumbers — Customs Declaration Number/country of origin) the report outputs the balance/turnover according to accounting data, the balance/turnover according to the register, and the difference. A non-zero difference indicates a discrepancy that requires analysis of primary documents.
Accounts related to commodity operations in the RK (for understanding the context of movements that the report reconciles):
| Account | Name |
|---|---|
| 1330 | Goods (inventory accounting) |
| 1210 | Short-term receivables from customers |
| 1030 | Cash in current bank accounts |
| 3310 | Short-term payables to suppliers |
| 3130 | VAT payable (VAT rate in the RK from 2026 — 16%) |
| 6010 | Income from sales of goods and services |
| 7010 | Cost of goods sold and services rendered |
Example of context (sale of goods, where the report then reconciles the balance of 1330 with the register): Dr 1210 Cr 6010 — revenue; Dr 1210 Cr 3130 — VAT 16%; Dr 7010 Cr 1330 — write-off of cost. The sale is accompanied by the issuance of an electronic invoice (ESF) in the ESF system and the registration of SNF during the movement of goods. All amounts are in tenge (₸).
6. Related Objects and Input on Basis
- Accumulation Register 'Goods of organizations (Accounting)' — the main source of operational data for reconciliation.
- Chart of Accounts 'Standard' (
ChartOfAccountsRef.Standard) — source of inventory accounts (1330 and others), set throughListOfAccounts. - Directories 'Organizations', 'Departments (warehouses)/Warehouses', 'Nomenclature', 'Characteristics of nomenclature', 'Series/Batches', 'Customs Declaration Numbers' — dimensions of groupings and selections.
- Primary registering documents for TMZ (receipt, sale, transfer, inventory write-off, inventory) — available through detailing when
DetailingMode = True.
Input on basis: not applicable for the report (reports are not a basis and are not input on basis). The result is a tabular document; when discrepancies are identified, adjustments are made in the corresponding primary documents and regulatory operations.
7. Extension Points
- Report Variants — saving user settings for groupings, selections, and formatting without changing the configuration.
- Configuration Extension — adding custom forms, settings attributes, changing the composition scheme and handlers
OnResultComposition. - Additional Fields (
AdditionalFields) — output of arbitrary nomenclature/characteristics attributes without code modification. - Selection by Accounts (
ListOfAccounts) — flexible configuration of the list of reconciled inventory accounts in the RK. - Programmatic DCS API — overriding composition settings from external code (e.g., for batch generation and export).