Instructions for regulated reporting 1s 7.7 Belarus
Compilation of interim (quarterly) financial statements is an integral part of the work of the organization's accounting service at the end of each reporting period. Modern information technologies make it possible to significantly simplify the preparation of reports. In this article, S.A. Kharitonov, Doctor of Economics, Professor of the Financial Academy under the Government of the Russian Federation, will talk about the automated preparation of financial statements in the program "1C: Accounting 7.7".
Regulatory framework and scope of reporting
In 2002, when preparing interim reports, organizations should be guided by the following regulatory framework:
- Federal Law No. 129-FZ of November 21, 1996 "On Accounting".
- Regulation on accounting and reporting in the Russian Federation, approved. by order of the Ministry of Finance of Russia dated July 29, 1998 No. 34n.
- Chart of accounts for accounting of financial and economic activities of organizations and instructions for its use, approved by order of the Ministry of Finance of Russia dated October 31, 2000 No. 94n.
- Civil Code of the Russian Federation. Parts one, two and three.
- Order of the Ministry of Finance of Russia dated January 13, 2000 No. 4n "On Forms of Accounting Statements of Organizations".
- Guidelines on the procedure for the formation of indicators of financial statements of organizations, approved. by order of the Ministry of Finance of Russia dated June 28, 2000 No. 60n.
- Regulation on accounting "Accounting policy of the organization" RAS 1/98, approved. by order of the Ministry of Finance of Russia dated December 9, 1998 No. 60n.
- Regulation on accounting "Accounting for agreements (contracts) for capital construction" PBU 2/94, approved. by order of the Ministry of Finance of Russia dated December 20, 1994 No. 167.
- Regulation on accounting "Accounting for the property and obligations of the organization, the value of which is expressed in foreign currency" RAS 3/2000, approved. by order of the Ministry of Finance of Russia dated January 10, 2000 No. 2n.
- Regulation on accounting "Accounting statements of organizations" PBU 4/99, approved. by order of the Ministry of Finance of Russia dated July 6, 1999 No. 43n.
- Regulation on accounting "Accounting for inventories" PBU 5/01, approved. by order of the Ministry of Finance of Russia dated 09.06.2001 No. 44n.
- Guidelines for accounting of inventories, approved. by order of the Ministry of Finance of Russia dated December 28, 2001 No. 119n.
- Regulation on accounting "Accounting for fixed assets" PBU 6/01", approved by order of the Ministry of Finance of Russia dated 30.03.2001 No. 26n.
- Guidelines for accounting of fixed assets, approved. by order of the Ministry of Finance of Russia dated July 20, 1998 No. 33n.
- Regulation on accounting "Income of the organization" PBU 9/99, approved. by order of the Ministry of Finance of Russia dated 06.05.1999 No. 32n.
- Regulation on accounting "Expenses of the organization" PBU 10/99, approved. by order of the Ministry of Finance of Russia dated May 6, 1999 No. 33n.
- Regulation on accounting "Accounting for state aid" PBU 13/2000, approved. by order of the Ministry of Finance of Russia dated October 16, 2000 No. 92n.
- Regulation on accounting "Accounting for intangible assets" PBU 14/2000, approved. by order of the Ministry of Finance of Russia dated October 16, 2000 No. 91n.
- Regulation on accounting "Accounting for loans and credits and the costs of servicing them" RAS 15/01, approved. by order of the Ministry of Finance of Russia dated 02.08.2001 No. 60n.
The preparation of interim financial statements may also be based on other regulations that clarify the features of accounting for individual property, liabilities and transactions.
In accordance with clause 2 of the instructions on the volume of accounting forms, approved. by order of the Ministry of Finance of Russia dated January 13, 2000 No. 4n, interim financial statements include:
- balance sheet (form No. 1);
- income statement (Form No. 2).
At the same time, organizations may additionally include in the interim financial statements those forms that are presented as part of the annual financial statements:
- statement of changes in equity (Form No. 3);
- cash flow statement (Form No. 4);
- appendix to the balance sheet (form No. 5);
- report on the intended use of the funds received (form No. 6).
Components of automated reporting
Modern information technologies used in the program "1C: Accounting 7.7" can significantly simplify the filling of standard forms. The automated preparation of financial statements in "1C: Accounting 7.7" is based on the use of so-called regulated reports, which, along with the actual sample forms, contain algorithms for filling them out based on accounting information registered in the information base.
The correct completion of sample forms is based on compliance with conventions on the structure of configuration metadata and record keeping. First of all, this applies to the working chart of accounts and constants.
Business transactions carried out in the organization are reflected in accounting using the double-entry method: on the debit of one account and the credit of another. The accounting account is designed to summarize information on the availability and movement of property, liabilities, expenses, etc. The set of accounts used by an organization forms a working chart of accounts. In "1C: Accounting 7.7" the working chart of accounts is built on the basis of the Chart of Accounts, approved. by order of the Ministry of Finance of Russia dated October 31, 2000 No. 94n. It contains the account numbers of the first level of the Chart of Accounts. At the same time, sub-accounts of the second level, as well as analytical accounting, are organized in such a way that, on the one hand, they do not violate the provisions of the instructions for using the Chart of Accounts, and, on the other hand, ensure the maximum degree of automation of accounting work and reporting.
The same information is indicated in various reporting forms, for example, the name and address of the organization, information about the head and chief accountant, industry (type of activity), OKPO, OKONKh, OKOPF, OKFS codes, taxpayer identification number (TIN), etc. This kind of permanent and semi-permanent information in "1C: Accounting 7.7" is stored in constants, which are filled using the "Information about the organization" processing, called from the "Service" menu. Constants with general information about the organization are filled in on the "Organization" and "Codes" tabs of this processing. To select the appropriate bookmark, just click on its name.
On the tab "Organization" (Fig. 1) the following is indicated: the date of state registration, short and full name of the organization, legal and postal address, phone numbers of the organization, and on the tab "Codes" (Fig. 2) - the identification number of the taxpayer, codes and name of the main type of activity, legal form and form of ownership, OKPO and OKDP codes.
Rice. 1. Tab "Organization" of processing "Information about the organization"
Rice. 2. Tab "Codes" of processing "Information about the organization"
Connecting and using regulated reports
The following regulated reports are intended for the preparation of financial statements in "1C: Accounting 7.7":
Preparation of financial statements in "1C: Accounting 7.7" is carried out in the "Regulated reports" mode of the "Reports" menu. At the same time, a window with a list of regulated reports is displayed on the screen (Fig. 3).
Rice. 3. Window for selecting a regulated report
In the upper part of the window there is a field for selecting a group of reports. The fact is that reports for each reporting period form a separate group, for example, "Reporting for the 2nd quarter of 2002", "Reporting for the 3rd quarter of 2002", etc. For each reporting quarter, the set of regulated reports includes a set of external files that have extension ERT. These files are placed in a folder ExtForms, in which, in turn, folders are created to store a set of regulated reports for a specific quarter.
The name of the folder corresponds to the reporting period. For example, a folder named Rp02q2.grp combines files for reporting for the 2nd quarter of 2002, with the name Rp02q3.grp- for reporting for the 3rd quarter of 2002.
Each folder contains a text file RpList.txt, containing a list of the reports included in the set and the names of the files in which they are stored.
A set of regulated reports is prepared by 1C in the form of a self-extracting archive file with the extension EXE. For example file Rp02q2.exe contains regulated reports for reporting for the 2nd quarter of 2002, file Rp02q3.exe- for reporting for the 3rd quarter of 2002, etc.
Connecting regulated reports for the next reporting quarter is done using the "Download" button. A window opens in which the path to the archive file is specified using standard Windows tools and it is opened (the "Open" button). At the same time, new regulated reports are loaded from the archive file to the directory ExtForms, subordinate to the directory containing the current infobase.
If reports for this quarter have already been downloaded, the program suggests placing them in an existing group (with updating existing files) or creating a new one.
Users who receive the "Information and Technology Support" disk by subscription have the opportunity to copy reporting forms directly from the ITS disk. To do this, just enter the "1C: Reporting Forms, Program and Configuration Releases" section, select the appropriate set of reporting forms, check the checkboxes in the list of infobases in which it needs to be installed, and click on the "Copy to infobase" button (Fig. .four).
Rice. 4. Selection of information bases for copying reporting forms
Under the name of the selected group (Fig. 3) there is a list of reports included in it.
To access a specific report, select the required report in the list with the cursor and click the "Open" button or double-click the left mouse button.
Scheduled reports are configured to share two parts of the form in one screen window: an on-screen dialog and a table (Fig. 5).
Rice. 5. Fragment of the screen form of the regulated report
The on-screen dialog includes the buttons "Close", "Save", "Restore", "Clear", "Fill", "Text" and "Print", as well as details for setting up individual report generation parameters. For example, for the balance sheet, the reporting period, the unit of measurement and the accuracy of data presentation, the date of delivery of the balance sheet, the option for processing data on payables and receivables by maturity are indicated.
The table is a computer analogue of the standard form, it consists of cells with fixed and result information.
Cells of the first type contain textual information entered into the form at the stage of its design, for example, the name of the report, indicators, etc. This information is common for all organizations, it is not editable when working with the application in 1C:Enterprise launch mode. A variety are cells with information specifying the reporting period, the date of the report, the unit of measurement and the value of some other indicators. These cells are filled in automatically according to the values of the details in the on-screen dialog of the report form and constants, but they are also not available for editing directly in the table.
All cells of the table, which provide for the output of result information, are highlighted in yellow or green. Yellow color means the cell value can be edited. Green color means that the value is calculated automatically by some formula. For example, in the report "Balance sheet (form No. 1), the cells in columns 3 and 4 of lines 211-217 are highlighted in yellow, and in the same columns, lines 210 are green, since they are filled in according to the formula: the sum of lines 211-217 (Fig. .6).
Rice. 6. Fragment of the screen form of the report "Balance sheet (form No. 1)"
When you open the report form for the first time, there is no result information in the table. To receive it, click on the "Fill" button. If the calculated indicators are displayed in the cells highlighted in yellow, then they are available for editing. When they change, the value of other indicators associated with the adjusted indicator by the formula is recalculated automatically.
The output of the completed standard form on paper is carried out using the "Print" button in the "Print immediately" or "Show form" mode. In the first case, the table with the result information is immediately printed; in the second, the report prepared for printing is displayed on the screen for previewing and making changes. The second mode allows you to see on the screen an electronic image of a standard form, change page parameters (position of a sheet of paper, margins, scale, etc.).
Deciphering the filling algorithm
The algorithm for automatically filling out the reporting form is formalized in the built-in language of the program knowledge of regulatory and instructive documents on the interpretation of analytical and synthetic data of primary accounting and the rules for generating reporting indicators. To explain the operation of the algorithm in the language of accounting, regulated reports provide a mode for decoding the order of formation of indicators. It is called using the "Open" button after filling out the form in an automated mode.
On fig. 7 shows a fragment of the decoding of the algorithm for filling in the balance sheet.
Rice. 7. Table-interpretation of the algorithm for filling out the balance sheet
For individual indicators given in the table-decoding, you can get more detailed information. On such indicators, the cursor takes the form of a "magnifying glass", and the detailing is called up by double-clicking the left mouse button. If the indicator characterizes the turnover between accounts, the register "Journal of transactions" is formed. If the indicator characterizes account turnover, a standard report of your choice is generated.
On fig. 8 shows the report "Turnover and balance sheet for the account", detailing the indicator "Balance at the end of the period on the debit of account 04".
Rice. 8. Detailing the indicator of the transcript table
Technological analysis of accounting
The correctness of the interpretation of accounting data in the automatic formation of indicators of standard forms depends on compliance with agreements on computer accounting technology.
The first group is formed by agreements that arise from the legal framework governing the accounting of assets and liabilities. So, the property of the organization (fixed assets, intangible assets, materials, etc.) is reflected in the asset balance. It is taken into account on active accounts, the balance of which can only be debit.
The organization's liabilities (to personnel for wages, banks for loans received, etc.) are reflected in the liabilities side of the balance sheet. Therefore, they are taken into account on accounts, the balance of which can only be credit.
Violation of the established procedure for reflecting the property and liabilities of the organization leads to the fact that the balance sheet form filled in automatically will not be balanced (the indicators of lines 300 and 700 are not equal).
The second part of the agreements follows from the need to obtain detailed information of an analytical nature for the automatic formation of individual indicators of reporting forms. For example, in the profit and loss statement (form No. 2) it is necessary to provide information on the composition of non-operating income and expenses.
To obtain this information, analytical accounting on account 91 "Other income and expenses" is designed in such a way as to automatically analyze the turnover for the relevant profit and loss items. Deviation from such a model for accounting for income and expenses on other operations leads to a distortion of the components of the financial result.
To check the correctness of the initial data, a technological analysis of the state of accounting is carried out before reporting. For its implementation, the set of regulated reports includes the report "Analysis of the state of accounting" (Fig. 9).
Rice. 9. Screen form of the report "Analysis of the state of accounting"
Technological analysis of accounting is carried out in the following areas:
1) analysis of the working chart of accounts;
2) analysis of the balance of accounts;
3) analysis of accounting results;
4) analysis of accounting entries.
In chapter " Analysis of the working chart of accounts"A check is made for compliance with the recommendations of the company" 1C "settings of the chart of accounts" Main ". If the description of the properties of the account is incorrect in relation to the side of the balance sheet, an error message is displayed.
If the checkbox "Analytical accounting structure" is checked in the on-screen dialog of the report, then the correctness of analytical accounting on the accounts used in the algorithms for filling in standard forms is checked. Discrepancies found are disclosed in the report.
In chapter " Account balance analysis"Accounting results are analyzed at the end of the reporting period. In accordance with the established procedure, individual accounting accounts are subject to "closing" at the end of each reporting month. The balances from these accounts are written off to other accounting accounts, so they are not shown in the balance sheet. The balance is checked against the following accounts:
- 25 "General production costs";
- 26 "General expenses";
- 40 "Output of products (works, services)";
- 90 "Sales";
- 91 "Other income and expenses";
- 99 "Profit and Loss" (as of January 1 of the reporting year).
For automatic "closing" of accounts, the regulatory document "Closing of the month" is intended. The list of processed ("closed") accounts is indicated in the on-screen dialog of the document form.
If the accounts to be closed at the end of the reporting period have balances, information about such accounts is issued.
In chapter " Analysis of accounting results" is checked:
- correspondence of balances on accounting accounts to the description of their properties in relation to the balance sheet;
- the presence of errors in the accounts with a sign of quantitative accounting;
- identification of accounts with a sign of conducting currency accounting, for which the balances at the end of the period were not recalculated at the rate of the Central Bank of the Russian Federation.
For each account (subaccount) in the column "Act." form of the chart of accounts list "Basic" its attribute is set in relation to the balance.
Active accounts have the sign "A", passive - "P", active-passive - "AP".
The section checks the balances at the beginning and end of the reporting period on synthetic and analytical accounts, and a message is displayed if the active account has a credit balance, and the passive account has a debit balance.
The balances on accounts (sub-accounts) are checked, in which in the column "Col." the form of the list of the chart of accounts "Basic", the sign of conducting quantitative accounting is set - the "+" sign. Such a sign is set on accounts 10 "Materials", 41 "Goods", etc.
As a result of incorrect registration of transactions with objects of analytical accounting on these accounts, the following practical situations are possible:
Situation 1. The object has a balance in monetary terms, but there is no balance in kind.
Situation 2. The object has a balance in physical terms, but there is no balance in monetary terms.
Situation 3. Balances in monetary and physical terms are placed on the account symmetrically: in physical terms - on debit, in monetary terms - on credit, and vice versa.
Regardless of the reasons that resulted in the occurrence of the described situations in practice, this “marriage” in accounting work, which does not always lead to a distortion of the balance sheet indicators, must be corrected.
Before preparing financial statements, it is often forgotten about the need to recalculate assets and liabilities, the value of which is expressed in foreign currency. This requirement is contained in PBU 3/2000. As a result, the structure of the balance sheet is distorted. For accounts (sub-accounts) intended to summarize information about assets and liabilities, the value of which is expressed in foreign currency, in the column "Val." of the chart of accounts list form "Basic", the sign of currency accounting is set - the "+" sign. Recalculation is made at the exchange rate of the Central Bank of the Russian Federation as of the last date of the reporting period. Exchange rates are stored in the Currencies directory. If the ruble equivalent of the currency amount recalculated at the exchange rate of the Central Bank of the Russian Federation on the last date does not match the ruble balance of the analyzed accounting object, the exchange rate difference is calculated. It is attributed to account 91 "Other income and expenses", an object of analytical accounting with the value of the attribute "Type of other income and expenses" - "Exchange differences".
Automatic recalculation of assets and liabilities accounted for in accounts with the sign of currency accounting on the last date of the reporting month is carried out using the regulatory document "Currency revaluation".
The "Analysis of accounting entries" section checks for incorrect entries that can lead to a distortion of the taxable base and the amount of tax payable to the budget for value added tax and sales tax.
A little gag on the topic of updating where it all comes from on the Internet, 1C has stopped updating 1C7.7 as such. , that is, you yourself need to take a floppy disk, take yellow sheets of paper with a description of the configuration and go to the 1C office for an update. BUT there is "TECHNOFORM", a tax stray for the task of reporting in electronic form, it distributes 1C7.7 updates for free for those who bought ...
Link to how to download updates from the Internet: http://forum.ru-board.com/topic.cgi?forum=...&start=1660
and here: http://forum.ru-board.com/topic.cgi?forum=...mit=1&m=1#1
Here is described what to do with these .exe that are downloaded via the Internet, directly how to update:
How to install and update accounting forms (regulated)
CONNECTING REPORTING FORMS
Reporting forms are connected in the "Regulated reports" mode. To invoke this mode, do the following:
- Select the "Regulated reports" item in the "Reports" menu of the main menu of the program or
- Select the "Reports" item in the "Operations" menu of the main program menu;
- In the list, select the line "Regulated reports";
- Click the "OK" button.
In the "Regulated reports" mode dialog, click the "Load" button. A standard file open dialog will be called, in which you should select and open any file with the EXE extension (for example, the Service.exe file).
After that, the list of reporting forms included in the delivery will be displayed in the "Regulated reports" dialog. Checkboxes indicate the forms that need to be uploaded. By checking or unchecking the required forms, you can select the required forms to upload. After selecting the forms, click the "OK" button to complete the download.
After that, the new reporting forms are loaded. The download process takes some time. When loading a reporting set from floppy disks, the program will ask you to insert another floppy disk into the drive.
After loading, the dialog of the operating mode with regulated reporting will be opened again. In the list of reports there is always an instruction for working with reporting forms - it is located in the very first list of reports. Open it and follow the instructions and recommendations in it.
- If you are accounting for several enterprises, you should repeat the procedure described in this file for each infobase that contains the data of these enterprises.
- Before using the reporting forms, you should check the correctness of the information about the enterprise and the value of tax rates, contributions and fees.
- Since the proposed algorithms for building reporting forms are designed for use in a variety of enterprises, you may need to further adjust these algorithms to adjust them to the specifics of accounting in your enterprise. It is recommended that you save the original reporting forms in a separate directory on your hard drive before making adjustments.
CONNECTING REPORTING FORMS MANUALLY
If for some reason the download of a new set of reporting forms in the "Regulated reports" mode was not completed, the reporting forms can be connected manually. For this:
- Go to the ExtForms directory located in the directory with your infobase;
- In the ExtForms directory, create a directory named RPххQх.GRP
(where: RP [year number - two digits] Q [quarter number - one digit], for example: RP03Q4.GRP); - Copy all files with the *.EXE extension and the Ver.id file located on the diskettes of the regulated reporting delivery kit to the RPххQх.GRP directory;
- Run all *.EXE files sequentially for execution. When you run each file, it will start unpacking the reporting form and writing it to disk;
Y (Yes, Yes)- if you WANT to REPLACE the report file that you already have on disk with a new file extracted from the archive;
If you have responded to a request "Y" or "N", the unpacking program will also require a response to the request in the future whenever the name of the file being extracted from the archive matches the one that already exists on the disk.
After answer "A" the unpacker will run automatically and no screen prompt will be displayed.
At any time you can press the keys Ctrl+Break and abort the unpacking process. Those files that the unpacking program managed to extract from the archive will remain on the disk. After unpacking, delete all files with the *.EXE extension from the RPххQх.GRP directory.
After unpacking, go to 1C: Accounting 7.7 and call the "Regulated reports" mode (if the "Regulated reports" mode is already called, close it and call it again). A new line "Reporting for the x quarter of 20xx" should appear in the "Report group" list.
Occurs in two stages - updating the platform and configuration. In addition, configurations often add additional steps to update regulated reporting. Consider step by step instructions.
To update the 1C 7 Platform, just run the installation file and install the program with the new version in the same directory as the old one. The installer will replace the old files with new ones.
You can install in different directories. In this case, the computer will have two instances of the Platform with different versions:
Please note that when installing an update, you can change the initial settings, such as the name of the organization that owns the program or the set of installed components:
Configuration update 1C 7
Configuration is a 1C 7.7 application solution, for example, 1C Accounting 7.7, Salary and Personnel, etc.
To update the 1C configuration, you first need to prepare the update distribution kit. The fact is that in most cases the update is delivered in a universal form: for the basic version and for the professional version. More precisely, the distribution kit is supplied specifically for the basic version, and if you have a professional version, you need to prepare it.
Create a separate folder, for example, "Preparing for update" and copy all the files from the update distribution package there:
Now let's run the 1C program and create another infobase. Let's call it "Preparing for the update" and specify the path to our new folder:
Run the program in Configurator mode. Before any actions with the configuration, you need to open it (menu "Configuration" - "Open configuration" or the corresponding icon).
If you have a professional version, this warning will open:
We press "OK". This will open the configuration tree. Click "Save":
Now let's open the Configurator of the database we are going to update:
Get 267 1C video lessons for free:
For example, I chose Configuration 1C “Accounting and reporting of an entrepreneur, ed. 1.2":
As you can see from the figure, the current release of the program is 7.70.260. Now we will update it to release 7.70.265. Let me remind you that we have already prepared it and it lies in the “Preparing for the update” folder.
Be sure to make a backup copy of the information database first. To do this, go to the menu "Administration" - "Saving data":
Select the save path and file name here. Click "Save".
After saving, we will start updating. In our case, the update must be done in merge mode. Go to the menu "Configuration" - "Combining configurations ...". Select the file "1cv7.md" from the "Preparing for update" directory:
The program will compare the current configuration and the updated one. The result will be displayed in a separate window. In this window, you can see what changes have been made in the new release, and if you wish, you can refuse some.
Set the "Configuration Priority" section to "Loadable Configuration", and in the "Merge Method" section - "Replace Objects":
We press "OK".
After merging, we save the resulting configuration. The database will be restructured according to the update. Click "Accept":
This completes the update from the Configurator side.
Now let's run the program in Enterprise mode and confirm the legality of the received update. After that, if necessary, the system will make updates already at the level of credentials, and at this point the update can be considered complete:
Update of regulated reporting in 1C 7.7
Unlike version 1C 8, in version 7.7, regulated reporting is delivered separately.
To download it, you need to go to the "Reports" menu - "" (the path may differ in different configurations):
As you can see, I have not downloaded any package of regulated reports at the moment. Now we will fix it.
Initially, the reporting is in a packaged form. The file should look something like this: 16q2001_PBOUL.zip, where 16 is the year, q2 is the second quarter, 001 is the distribution version, PBOUL is the name of the configuration.
You need to unpack this archive into a folder convenient for you.
1. General information about reports
The final step in bookkeeping isreceiving reports.
An important point is that the automation of accounting allows you to get intermediate (operational) results.
Before generating reports, it is necessary to check whether the calculation of accounting results for the quarter summarized in the reports is established, and it is better to completely recalculate the results.
Reports are generated based on the entered data, that is, postings(unposted documents or documents that do not form postings are not taken into account).
Reportsdivided into standard and regulated.
Standard Reports defined by the configuration, changed in the configurator, used to obtain information, as a rule, on any account (except for the cash book, sales book, etc.).
Regulated reports are created in the company 1C, comply with regulations, serve for submission to public authorities (balance sheet No. 1, VAT calculation, etc.). Scheduled reports can be supplemented by adding them to the program from files.
All reports can be compiled for a period defined either by two dates, or by a quarter or a month.
All reports are contained in the menu itemReports.
2. Formation of reports
Generation of standard reports.
To generate a standard report, it is necessary from the paragraphReportsselect the desired line or click on the toolbar button, a dialog box appears, specify the report period and other necessary parameters in it, clickOk- a report appears. Difference between buttonsOk and Formis that when using the second button, the dialog box does not disappear from the screen. To the right of the period in the dialog box there is a button(Period selection), it opens an additional window for selecting some fixed periods (current quarter, month, day, period).
The report has buttons:Refresh- recalculates the report. This is necessary when you changed any details of documents or transactions in the journals, and this could affect the totals for the accounts analyzed in the report.Setting– calls a dialog box for this report, which allows you to change the report period and other parameters and re-create the report.When you work with a report all the time and you often have to change the report generation parameters in the dialog box, you can save the report settings (period, account, and other parameters) using the button(Save setting), after clicking it, you need to enter the name of the setting, click Ok. You can save an unlimited number of settings. The next time you generate a report, you need to click on the button(Open setting), select its name from the list, click Ok and then generate the report in the usual way.
Formation of regulated reports.
Reports ® Scheduled ® Select report group ® Select report ® Open (dialog box appears)® or Form (here you can also print a blank report form with the buttonForm, save or open report settings).
Scheduled reports can be edited.
3. Types of standard reports
4. Save and inrelationship of reports
After the report is generated and appears in the active window, it can be saved in a separate file:
Saved report can be opened:
File ® Open (or click on the button ® Select directory and drive ® Select filename ® Open.
The accountant should analyze the received reports.
Analysis – it is the decomposition of the whole into separate elements.
The purpose of the analysis is to identify errors made either in the execution of business transactions, or when entering them into a computer.
Since arithmetic errors in the automated form of accounting with the correct handling of the program (proper management of accounting and operational results) are extremely rare, the most important thing in this case is to identify errors on the merits.
If an accountant, when viewing a summary report, is interested in some indicator, then he has the opportunity to find out what this amount consists of - just double-click on the amount of interest and you can find out what amounts of analytical results it consists of, and then (double-click again) - find out from what amounts of transactions.
If in this way the accountant discovered an error, then he mustfix not in the report, but in the operation,
since all totals are calculated by the amounts of transactions! From the transaction window, you can open the details of the document and correct them or go to the journal of transactions or postings.
Let's put it in sequence:
checkerboard(double click on sum)®
Posting journal(double click on wire)®
Operation(correcting an error in an arbitrary or typical operation to correct an error in a document - click on the button®
Document details) (click on the button®
Activity log(click on button®
Posting journal.
When returning “back”, you need to close the nested windows, however, the numbers in the summary reports do not correct themselves - you need to click on the buttonRefresh.
Although not very often, there are still organizations working with 1C: Enterprise 7.7. The language of this version is seriously different from the language of 1C:Enterprise 8, so even creating a simple report can be a problem for a person who has not worked with 1C 7.7 (like me). There was not much information on the Internet, basically everyone refers to the ZHKK (yellow-red books of manuals), so I will try to summarize everything that I found in this article. I will describe creating a report without using constructors, although they can simplify the task.
So, the task: to create a report - a register of incoming invoices for metal (the organization is engaged in the acceptance of scrap). The register is a table with the number and date of the invoice, the name of the metal, etc. The content is not so important, it is important that the data will be received by a request to the document Receipt of goods and its tabular part. The user will be able to set filters for the report by dates, by stock and by type of metal (ferrous or non-ferrous).
Create a report
- We create a report. Mine will be called JournalPSA. This is done in the same way as in 1C 8. When you open the created report, its form is immediately displayed. At the bottom of the tabs except mode Dialog there are modes Module and report layouts. Layouts can be added by right-clicking on the tab level and selecting Add table.
- In mode Dialog we add input fields in which data for filters will be entered. Similarly to 1C 8, there are controls on the bottom toolbar. When adding an input field, a properties window will open in which you need to specify Identifier and Data type. The identifier is Name an element by which it will be possible to get the value selected by the user. So I added the following fields: SelectStartPeriod, SelectEndPeriod, SelectMetal, SelectStorage. We also need a button Form it probably already exists. I will only pay attention to the parameter Formula in its properties. The name of the procedure that is called by pressing the button is written there. That is, for example, form().
- We create a report layout. Everything here looks like layouts in 1C 8. The same spreadsheet document that has sections(they are also regions). Section names are assigned via the menu Table. Cells have several types of filling, which are similar to types in 1C 8: text, parameter, template. Only parameter called here Expression.
There is also a difference from 1C 8. Parameter expressions are not assigned names here, but the name of the variable is prescribed, from which you need to take the value for substitution in the layout. For example, in my request, the invoice number will be received, therefore, in the properties of the corresponding layout cell with the type Expression I will write Request.Number.
The template works in the same way as in 1C 8. The text part is written as usual, and the expression is enclosed in square brackets. And it must also contain a variable from which the value is taken. For example, I need to display the level of radioactivity of the received scrap from the query result and add a unit of measure to the number µSv/h. The following template is suitable for this: [Request Radiation] µSv/h
- Now let's move on to the report generation procedure. Most likely the procedure for the button Form already created, if not, create manually. The code will look like this:
Form() procedure
Variable Request, Request Text, Tab;
//Create an object of type Request
Request = CreateObject("Request" ) ;
RequestText =
"//((REQUEST(request)
|Period from SelectStartPeriod to SelectConPeriod;
|Process NotMarked for Deletion;
| No results; |
|Number = Document.Receipt of Goods.DocNumberIncoming;
|Date = Document.Receipt of Goods.DateDocIncoming;
|Sender = Document.Receipt of Goods.Contractor.Description;
|LegalAddress = Document.Receipt of Goods.Contractor.LegalAddress;
|DocumentSeries = Document.Incoming Goods.Contractor.DocumentSeries;
|DocumentNumber = Document.Receipt of Goods.Contractor.DocumentNumber;
|DocumentIssued By = Document.Goods Receipt.Counterparty.DocumentIssued By;
|Metal = Document.Receipt of Goods.Goods.Metal;
|Weight = Document.Receipt of Goods.Quantity;
|Radiation = Document.Receipt of Goods.Radiation;
|Storage Location = Document.Receipt of Goods.Storage Location;
|GroupingDocumentString;
|Grouping Document;
|Condition(Metal.Colored = SelectMetal);
|Condition(StorageLocation = SelectStorageLocation);
|" //))REQUEST
;The request text, I think, is clear. To form it, you can use the query builder (top menu Constructors). Let me draw your attention to some features:
- Each query field is written to a separate variable, they can be seen before the = sign. In principle, this is similar to setting aliases in .
- In request necessarily there must be at least one grouping. Otherwise, it will be impossible to bypass the query result. In this case, the grouping goes first by the lines of the Goods Receipt document, and then by the documents themselves. If you leave only document lines in the grouping, then one document will be displayed.
- The request can take data from the form. For example, the conditionStorageLocation = SelectStorageLocation says that the value will be taken from the input field named SelectStorageLocation.
// If there is an error in the request, then exit the procedure
If Request. Execute(QueryText) = 0 Then
Return;
EndIf ;// Prepare to populate output forms with request data
Tab = CreateObject("Table" ) ;
Tab. SourceTable("layout" ) ;
Tab. OutputSection("Title" ) ;
State( "Filling output table...") ;
Tab. Options(0 , 0 , TableTableHeight() , 0 ) ;Here we check the ability to execute the query and, if everything is in order, we create a spreadsheet document based on the layout and display the section header.
While Request. Grouping() = 1 Loop
// Fill in request fields
Deliveryman = Abbreviated LP (Request. Deliveryer) + ", " + Abbreviated LP (Request. Legal Address) + ", passport " + Request. DocumentSeries + " " + Query. DocumentNumber + "Issued" + Request. DocumentIssued By;
Tab. OutputSection("Data" ) ;
EndCycle ;
// Output of the completed form
Tab. ViewOnly(1 ) ;
Tab. Show("Report" , "" ) ;
EndProcedureNow we loop through all the groupings (and if there were no groupings, we would not be able to bypass the query result) and display the section Data. Remember that the expressions in the layout cells had to match the variables in the module? This is where it works. When a section is displayed, the expressions are automatically replaced by the values of the same variables. All data on the layout was received from the request, except for the data of the deliverer. It was collected from several fields of the query result.
That's all, the report is ready.