Checked on release 3.0.74.2 "Accounting for Kazakhstan" (version 3.0).
The counterparty sent an act for 1,160,000 ₸, but your turnover for account 6010 this month shows a different amount. The standard "Account Card" shows the transactions but does not allow you to quickly filter by a specific contract, manager, or VAT rate. You open the universal report on metadata, specify the required object (document, directory, register, or transactions), set the filter by counterparty and amount — and within a minute, you see which specific document caused the discrepancy. This is your "X-ray" for any data in the database: it does not change anything, it only reads and shows what is hidden in the configuration tables.
1. Purpose
The universal report on metadata is a tool that builds a table for any configuration object: directory, document, information register, accumulation register, or accounting register (transactions). You choose what to display in rows and columns, which indicators to calculate, and by which fields to filter. The report does not conduct or change anything — it only displays data in a way that no standard report can.
2. Where to find
Path in the interface:
- Main menu (≡ icon in the upper left corner) → "All functions" → "Reports" → "Universal report on metadata".
- If the "All functions" item is missing: "Service and settings" → "Settings" → "Parameters" → check the box "Show the 'All functions' command".
The fastest way is to open directly via the navigation link. Copy the line below, then in 1C: Main menu → "File" → "Open" will not work, use "Service" → "Go to navigation link" (or in the web client, paste the link in the address):
e1cib/list/Report.UniversalReportOnMetadata
The regular "Universal report" (section "Reports" → "Universal report") is a neighboring, simpler tool. The metadata report differs in that it provides access to service fields and any type of source, including the accounting register.
2a. How to find out your release
Main menu → "Help" → "About the program". In the opened window, you will see two key lines: "Platform version" (for example, 8.3.24.xxxx) and "Configuration: Accounting for Kazakhstan, version 3.0 (3.0.74.2)". The second line is your release. If it differs from the one indicated in the header, some field names may be different, but the logic of the settings remains unchanged.
3. How to fill in (configure)
The report is "filled" not like a document — you set the selection parameters. Let's go through each one in order.
| Field / Element | Purpose | What happens if you make a mistake |
|---|---|---|
| Period (MANDATORY for documents and registers) | Limits the selection by date. | An empty period for the accounting register will collect all transactions for the entire database — the report will hang. Set a specific interval. |
| Data source type (MANDATORY) | Defines the class of the object: "Directory", "Document", "Information Register", "Accumulation Register", "Accounting Register", "Chart of Accounts", etc. | If you select the wrong type, you will not find the required object in the next field. |
| Metadata object (MANDATORY) | A specific object: Document.SaleOfGoodsAndServices, AccountingRegister.CostAccounting, Directory.Counterparties. |
If you make a mistake with the object, the data will be "incorrect," although the report will be generated. |
| Table | For a document, this is "Main Data" (header) or the tabular part ("Goods", "Services"). For a register — "Balances", "Turnovers", "Balances and Turnovers" or "Movements". | If you want to see the nomenclature line by line but select "Main Data," you will only get headers without rows. |
| Rows (groupings) | What is displayed vertically: Counterparty, Contract, Organization, Account, Nomenclature. | Without groupings, you will get a flat list — hard to read. |
| Columns | What expands horizontally: for example, months, VAT rates. | Do not set if there is a lot of data — it will "spread" wide. |
| Indicators (fields / resources) | Numbers we calculate: Amount, VAT Amount, Quantity, for transactions — Debit Amount, Credit Amount, turnovers. | If you forget to add an indicator, the table will be without numbers. |
| Filters | Limitation by value: Counterparty = "LLP Romashka", Amount ≥ 1,000,000, Conducted = Yes. | Too broad a filter → extra rows; too narrow → empty. |
| Sorting | Order of rows (by amount, by date). | Without it, large amounts get lost in the list. |
| Formatting (conditional formatting) | Highlighting rows by condition (for example, negative — in red). | Not mandatory, but helps the eye. |
All these settings are opened by the "Settings" button (gear / "More" → "Settings"). The "Simple / Advanced" switch in the upper right corner of the settings window: in advanced mode, filters by service fields (Link, Deletion Mark, Responsible, Change Date) are available. After configuring, click "Generate".
Save the completed report configuration: "More" → "Save report variant" — and next time you won't have to assemble it again.
4. An example with transactions
Task. The counterparty LLP "Astana-Snab" sent a reconciliation act: sales for August 2026 — 1,160,000 ₸ including VAT. You have a lower amount for this counterparty on account 6010. You need to find the missing document.
Step 1. Data source type — "Accounting Register", object — AccountingRegister.CostAccounting, table — "Turnovers", period — 01.08.2026–31.08.2026.
Step 2. Rows (groupings): Registrar (document basis). Filter: Credit Account = 6010, Subaccount = Counterparties: LLP "Astana-Snab". Indicator — Credit turnover amount.
Step 3. Generate. You see two sales documents for 517,857.14 ₸ and 379,464.29 ₸ (these are amounts excluding VAT for credit 6010). Total income excluding VAT — 897,321.43 ₸. The third document, which the counterparty has, is not in the list — it was forgotten to be conducted.
Step 4. Check the amount of the act. Since the act is for 1,160,000 ₸ including VAT, the base = 1,160,000 / 1.16 = 1,000,000 ₸, VAT 16% = 160,000 ₸. The missing sale = 1,000,000 − 897,321.43 = 102,678.57 ₸ excluding VAT. Find the primary document and conduct the sales document for this amount.
Transactions of the found/added sales document (VAT 16%):
| Debit | Credit | Amount, ₸ | Meaning |
|---|---|---|---|
| 1210 | 6010 | 102,678.57 | Income from sales accrued (excluding VAT) |
| 1210 | 3130 | 16,428.57 | VAT payable accrued (16%) |
| 7010 | 1330 | 71,875.00 | Cost of sold goods written off |
After conducting, generate the same universal report again — the turnover for credit 6010 matches the act. The report itself does not make any transactions: it only helped to localize the discrepancy.
5. What can be built (types of selection)
The report is universal — "types of operations" here are replaced by data source types:
- Directory — lists of counterparties, nomenclature, contracts with any attributes (BIN, price type, responsible).
- Document — by header or by tabular part (for example, all rows "Goods" from sales for the period).
- Accumulation Register — balances/turnovers of goods in warehouses (
GoodsInWarehouses), mutual settlements, batches. - Information Register — exchange rates, rates, prices of nomenclature, responsible persons.
- Accounting Register (
CostAccounting) — transactions, turnovers, and balances by accounts with breakdown by subaccount. - Chart of Accounts / plan of characteristics — structure of accounts and subaccounts.
6. What is formed during construction
The universal report on metadata is a report, not a document. Therefore, it:
- does not create transactions and does not change data;
- does not generate ESF, SNT, and other electronic documents — electronic documents are created from sales/purchase documents, and the report only shows which documents have already been issued an ESF (if the corresponding attribute is displayed);
- does not make movements in registers — it only reads existing movements.
The result of the construction is a tabular document on the screen: rows, columns, totals, and subtotals by groupings. It can be reassembled as many times as needed without consequences for the database.
7. Print forms and export
You can:
- Print — button "Print" (printer icon) or Ctrl+P.
- Save as a file — "More" → "Save": available formats Microsoft Excel (.xlsx / .xls), table (.mxl), PDF document, ODF table (.ods), HTML, text file (.txt), CSV.
- Send by email — "More" → "Send" (if the email account is configured).
There is no separate "blank" print form for the report — the generated tabular document is printed in the form it appears on the screen.
8. Common errors
"Field '...' not found" — you saved the report variant on an old release, and in the new one, the attribute has been renamed or deleted. Remove the problematic field from the settings and add the current one.
"Data source for the report not specified" — the metadata object is not selected. Open "Settings" and fill in the "Data source type" and "Metadata object" fields.
The report is generated very slowly or "hangs" — you are building from the accounting register or a large document without a period/filter. Set a narrow period and at least one filter (organization, account, counterparty).
"Insufficient rights to perform an operation on the object ..." — your role does not have rights to view this metadata object. Contact the administrator: access to the universal report on metadata is usually granted separately, as it "sees" service data.
The report is empty, although there is data — most often, the period is incorrect or the "Main Data" table is selected instead of the tabular part (or vice versa), or a non-existent value is set in the filter. Check the period and remove unnecessary filters.
Amounts do not match with the turnover balance — you displayed the amount of the document including VAT, while the turnover balance for 6010 is excluding VAT. Make sure which indicator you are calculating and build from the accounting register if you need accounting data.
9. FAQ
(see the separate Q&A block below)
10. Related tools
The universal report is not introduced "based on" a document — it is independent. But it is conceptually related to:
- Regular "Universal report" (section "Reports") — a simplified version for quick selections.
- Standard reports: "Turnover balance sheet", "Account Card", "Subaccount analysis" — when a strict accounting cut is needed, not an arbitrary selection.
- "Report on conducted documents" and operations journal — when you need to go from the found row to the actual document (double-clicking on the row opens the registrar document).
- Finding a discrepancy, you correct source documents: "Sale of goods and services", "Receipt of goods and services", "Operation (accounting)" — and from them, if necessary, issue ESF and SNT.
How to find out your release
Main menu → "Help" → "About the program" — there you will find the platform version and the configuration release ("Accounting for Kazakhstan, version 3.0, version 3.0.74.2"). Compare it with the signature below: if the releases differ, the names of individual fields may vary.
This material was prepared for release 3.0.74.2 of the "Accounting for Kazakhstan" configuration (version 3.0). Current rates for 2026: VAT — 16%, MRP — 4,325 ₸, MSP — 85,000 ₸.