1. Identification
| Property | Value |
|---|---|
| Object Type | Report |
| Name | CustomerDebtByDebtTerms |
| Full Name | Report.CustomerDebtByDebtTerms (Reports.CustomerDebtByDebtTerms) |
| Alias | “Customer debt by debt terms” |
| Configuration | Accounting for Kazakhstan, edition 3.0 (version 3.0.74.2) |
| Example Currency | tenge (₸) |
Purpose. The report is intended for detailed analysis of accounts receivable from customers, broken down by time intervals of overdue payments (current debt, 1–30 days, 31–60 days, 61–90 days, over 90 days, etc.). It is used by financial managers, accountants for customer settlements, and managers to assess the quality of accounts receivable, identify problematic counterparties, and plan debt collection activities.
The report is generated for a specific date, supports flexible grouping settings (counterparty, contract, manager, organization), filters by organizations, adds additional analytical fields, exports results, and schedules dispatch. It integrates with “Manager's Monitor” to display key indicators of overdue debts.
Important: this is a report, not a document. It does not perform postings or generate movements in registers or accounts — it only reads accounting data (see section 5).
Where to find in 1C: section “For the Manager” → “Customer debt by debt terms”. Navigation link: e1cib/list/Report.CustomerDebtByDebtTerms.
2. Header Attributes and Table Parts
2.1 Report Attributes (Parameters)
| Name | Type | Mandatory | Purpose |
|---|---|---|---|
| Period | Date (xs:dateTime) |
Mandatory (ShowError) | The date for which the debt and overdue terms are calculated. A key parameter: it determines the calculation of the number of overdue days for each debt. |
| OrganizationListRepresentation | String |
Optional | Text representation of the selected organizations for the report header. Automatically generated when organizations are selected in the settings. |
| AdditionalFieldsPlacement | Number (xs:decimal) |
Optional | Controls the placement of additional fields (in columns/rows). Affects the visual structure of the tabular document. |
| DetailingMode | Boolean |
Optional | Detailing switch: when True, detailed fields are hidden, only aggregated data is shown. Used when transitioning from the manager's monitor or for simplified viewing. |
2.2 Table Part “Intervals”
Defines time ranges (in days) for segmenting debt by overdue terms. Each row sets the boundary of the interval; the system automatically forms groups such as “0–30 days”, “31–60 days”, etc.
| Name | Type | Purpose |
|---|---|---|
| Value | Number (xs:decimal) |
End of the interval in days (e.g., 30, 60, 90, 120). The upper limit of the overdue range for the segment. |
| Representation | String |
Text representation of the interval (“Up to 30 days”, “31–60 days”, “Over 90 days”). Automatically generated, editable by the user. |
2.3 Table Part “Grouping”
Manages the structure of grouping report rows (by which dimensions to group: counterparty, contract, manager, organization, etc.).
| Name | Type | Purpose |
|---|---|---|
| Usage | Boolean |
Grouping activity flag. True — the field is included in the grouping, False — ignored. |
| Field | String |
Technical name of the data layout field (“Counterparty”, “Contract”, “Organization”). |
| Representation | String |
Displayed name of the field in the settings interface. |
3. Forms
The report is built on the data composition system (DCS), so the set of forms is typical for reports in BC 3.0:
| Form | Purpose |
|---|---|
| ReportForm (main) | A unified form for setting parameters (Period, organizations, intervals, groupings), launching the generation, and outputting the result in a tabular document. Contains a result field and a DCS settings panel. |
| SettingsForm / layout option | Extended configuration of the report structure: selection of groupings, filters, conditional formatting, additional fields. Can be embedded in the main form or called separately. |
| VariantSelectionForm | Selects predefined report variants (by counterparties, by contracts, by managers), if variants are provided. |
User settings (Period, filtering by organizations, composition of intervals) are displayed on the main form as quick settings.
4. Key Module Procedures
The attached evidence does not include software modules (BSL), so below are standard report handlers for this type of object in BC 3.0:
- Object Module →
OnResultComposition(ReportResult, DecryptionData, StandardProcessing)— interception point for outputting the result. Here, the layout is usually fine-tuned: substituting overdue intervals from the table part “Intervals”, calculating the number of overdue days relative to thePeriodparameter, distributing amounts across the overdue columns. - Form Module →
OnServerCreation— initialization of parameters (fillingPeriodwith the current date, default values for table parts “Intervals” and “Grouping”), setting field visibility based onDetailingMode. - Form Module →
BeforeFilling/SetReportParameters— receiving external parameters when opening from the “Manager's Monitor” (including settingDetailingMode = True). - Form Module → handlers for changes in table parts “Intervals”/“Grouping” — reassembly of layout settings when adding/removing intervals and toggling
Usageflags. OnFillingCheck— control of the mandatory attributePeriod(implementation of ShowError).
Requires verification on a specific delivery 3.0.74.2: exact names of procedures and path
path:string— the provided handlers reflect the standard implementation of DCS reports, but the composition may differ with modifications.
5. Data Sources (Registers and Accounts)
The report does not generate postings or movements — it aggregates already existing accounting data. The source is the balances for settlements with customers:
- Accounting Register “Cost Accounting” — balances on account 1210 “Short-term accounts receivable from customers and clients” (standard chart of accounts of the RK) broken down by subaccounts “Counterparties” and “Contracts”.
- The date of debt occurrence is taken from the movement/document data; the number of overdue days =
Period − DebtDate(considering the payment schedule by contract, if specified). - The debt amount is grouped by the intervals of table part “Intervals”.
Related accounts involved in forming the debt itself (for understanding the context of accounting):
| Account | Purpose |
|---|---|
| 1210 | Short-term accounts receivable from customers — the main source of the report |
| 1030 | Cash in current bank accounts (debt repayment) |
| 6010 | Revenue from sales (debt occurrence from sales) |
| 3130 | VAT payable (VAT rate in the RK from 2026 — 16%) |
| 7010 | Cost of sales |
| 1330 | Goods |
| 3310 | Payables to suppliers (for reciprocal analysis, not included in this report) |
Sales to customers that generate debt on 1210 are accompanied by electronic documents ESF (ESF IS) and, if necessary, SNT; this does not affect the amounts of tax indicators in the report — it only operates with debt amounts.
6. Related Objects and Input Based On
Reports in 1C do not support “input based on” and are not entered based on documents themselves. Functionally, the report is related to:
- Directories “Counterparties”, “Contracts”, “Organizations”, “Individuals/Managers” — dimensions of groupings and filters.
- Documents for settlements with customers — “Sale of goods and services”, “Act of completed works”, “Receipt of money”, “Debt adjustment”, “Mutual settlement” — generate movements on account 1210, which the report reads.
- “Manager's Monitor” — calls the report with preset parameters (including
DetailingMode). - Electronic documents ESF / SNT — accompany the sale that generated the debt.
7. Extension Points
- Report Variants (DCS) — adding new grouping/formatting options without changing the code.
- Configuration Extensions — overriding
OnResultComposition, adding form attributes and columns (extending the form/object module). - Additional Fields through
AdditionalFieldsPlacement— outputting user analytics in columns/rows. - Table Part “Intervals” — flexible adjustment of the overdue scale to the organization's regulations.
- Scheduled Dispatch and Export — integration into regulatory tasks and external reporting.
- Event Subscriptions / External Processing — pre-processing parameters when opening from external locations (manager's monitor, desktop).
