How to download reports from 1s 7.7. Uploading reports electronically. Retrieving Information Using the Query Console
Posted Aug 4 2016, 10:55 by user Vyacheslav Abisalov
Posted Jan 19 2016, 04:51 by user Vyacheslav Abisalov
Posted Jan 18 2016, 08:22 by user Vyacheslav Abisalov
Posted Dec 8 2015, 11:24 by user Vyacheslav Abisalov
Posted Dec 6 2015, 13:49 by Vyacheslav Abisalov
Quite often, users need to save data from 1C 8.3 to a file, for example, pdf, Word, Excel and other formats. For example, send by e-mail report to another person, make calculations in Excel. Unfortunately, not all users know that it is very easy to download such data from 1C on their own without outside help.
It is often necessary to download a list of some data from the tabular part of a document, list form, document log, etc. Such tasks are often isolated, and it is inappropriate to involve a specialist to write a report.
For example, you need to get the entire item with the “Materials” view, but you only need the columns “Item” and “Unit”.
In the case when you need to upload data with filtering, first of all, you need to configure the list in the “More” menu of the tabular section.
In the window that appears, from the left side (available fields), you need to select those by which you will make a selection (in this case, “Type of item”). In the right part of the window, the values of the selection parameters are set. Moreover, the type of comparison is not limited to equality alone.
After the stock has been set, in the list form of the “Nomenclature” directory, only those items that meet the specified condition will be displayed.
The next step is to output this list into a spreadsheet document.
From the More menu, select List.
If you need to display not all columns, as in our example, then check the boxes only for those that are necessary.
As a result, you essentially get a report that we can save in any available format. How to do this will be discussed below. In a similar way, you can download tabular parts of documents and reference books, data from document journals, list forms, and more.
Uploading reports and printed forms from 1C
Any report, printed form, spreadsheet document (for example, which we received in our example) in 1C 8.3 can be uploaded to an external file in two clicks.
On the top panel of the program there is a button to save to an external file (Taxi interface). It will be active on any reports and printed forms where saving is available.
Uploading the entire 1C database
This method is necessary in cases where the 1C database needs to be unloaded as a whole, for example, to create a test copy.
Go to the desired information base in configurator mode.
In the “Administration” menu, select “Download infobase”.
Specify a different file name and save path if necessary.
The resulting downloaded data file with the *.dt extension is very easy to download in the future. To do this, in the configurator mode, in the “Administration” menu, select “Load infobase” and open the *.dt file received earlier.
Setting up uploading reports from 1C: “Accounting of a government institution 8”.
1) To download regulated reports, select the menu “Accounting” - “Regulated reports” - “Accounting statements”
2) On the “Report Journal” tab of the “Regulated Accounting Reports” form, when you click on the “Upload” button, the “Export of Institutional Reporting” processing opens.
Only reports with the status “Prepared” or “Approved” are available for uploading reports.
If you need to download reports with the status “In Progress” or “Scheduled”, click on the “Disable selection” button, then all saved reports will appear in the list
4) To download reports, you must configure export. In the “Export Settings” window, clicking on the selection button opens the “Reporting Export Settings” reference book.
5) In the reference book “Setting up reporting export”, when you click on the button, a new element opens
6) In the “exchange format” field, the format for which the settings are being made is indicated. From the “Exchange Format” field, click the button to go to the “Plug-in Algorithms” directory
7) In the “Plug-in Algorithms” directory, when you click on the button, the file is indicated external processing. Depending on where the reporting will be downloaded, select the required file.
By selecting required file click on the “Open” button
8) When you click on the “OK” button, “Plug-in algorithms” will appear in the directory new line with the selected algorithm
Double-click on the line and the required upload will appear in the “Exchange Format” field.
9) In the “Name” field, indicate the name of the setting. The name can be anything. For example: Uploading to vault 7.7.
To save the upload result to information base The “Save files in the infobase” checkbox is checked.
In the “Upload Method” field, the Directory is indicated.
In the “Download path” field, indicate the folder on the computer where you want to download reports
10) Click on the “OK” button. Now the newly created setting appears in the “Reporting Export Settings” window.
11) Double-click on the name of the setting.
In the “Export Settings” window of the “Export of Institutional Reporting” processing, the required setting. In the left processing window, the code for submitting reports is indicated. We mark the reports required for downloading with a tick and click on the “Download data” button.
Need to document this information arose as a result of a failure of the frontal lobes, especially in the subject area of filing a VAT return. The note will be useful
especially for spoiled users of 1C Enterprise 8, where there are no such difficulties when working with regulated reporting.
So, suppose we need to generate and upload a VAT return for the 3rd quarter of 2010
Let's move on to: Reports - regulated - Tax reporting - VAT.
In the report we have Title page, 7 sections and 2 applications. fill in the required pages and indicators. Unloading is carried out using the Unloading reporting data processing (formats version 4, version 5). let's launch it. In the list of reports for downloading, by double clicking you can go to desired page report. This opens the “Select report section” window.
About the most common problem with downloading tax reporting from 1C Accounting 7.7.
If the program produces errors like:
The indicator in Section 2\Line 040\Column 3 is not filled in.
The indicator in Appendix 1 to Section 3\Line 030 is not completed.
The indicator in Appendix 1 to Section 3\Line 040 contains an incorrect value: the length of the indicator value must be at least 10.
The indicator in Appendix 1 to Section 3\ Line 050 contains an incorrect value: the length of the indicator value must be at least 10.
The indicator in the checkpoint is not filled in.
What to do if the regulated report from 1C:Accounting 7.7 is not downloaded?
The 1C program supports several options for filling out the report, which are selected using the Option button. As a rule, an error in unloading is that the necessary indicators are left blank. This especially applies to cases of uploading 1C reporting pages, the completion of which is not implied during upload. In other words, we created report pages but didn't populate them.
To avoid errors, immediately before uploading, go through each page of the report, click on the Option button and make sure that unnecessary pages do not have options.
If a list of options for filling out the report opens, select the item<удалить текущий>, close the page and refuse to save the report
. This is how you can delete report pages created by mistake.
The general rule is to save only those sections that we plan to fill. To help us, at the root of the list of regulated reports there is processing Maintenance of saved reporting data. This service allows you to track which pages are created for each report. From here you can navigate to the desired section and, if necessary, delete it.
Where are completed regulatory reports stored?
C:\Program Files\1Cv77\1SBDemo\ExtForms\01028561.77\6 301001.02\1152017.10\31120100.rvs
- C:\Program Files\1Cv77\1SBDemo - infobase directory;
- 01028561.77, 6301001.02 - TIN and KPP of the organization (in this case from the demonstration base);
- 1152017.10 - report code designation
- 31120100.rvs - report file with rvs extension
IN Russian Federation When generating financial statements in electronic form, Order of the Federal Tax Service of Russia dated March 20, 2017 N ММВ-7-6/228 “On approval of recommended formats for presenting accounting (financial) statements in electronic form” applies.
Uploading reports to xml file produced by most accounting programs. The procedure for uploading reports is described in the documentation of the program used by the audited entity. This page shows the procedure for downloading reports from the 1C program for informational purposes.
Uploading reports from 1C. Configuration 3.0
- Run the 1C: Enterprise 8.3 program (Enterprise Accounting 3.0 configuration) and specify the required information base.
- In the left menu of the program that opens, click Reports and select Regulated reports. The page will open 1C-Reporting.
- Place the mouse cursor on the line with the required reporting form and click on the button Unload.
In the opened form Specify directory select the path to save the reporting file. The process of uploading the selected reporting form to the specified directory will start.
The uploaded reporting forms are used to fill out the reporting forms of the audited entity in the Reporting module.
Uploading reports from 1C. Configuration 2.0
- Launch the 1C: Enterprise 8.2 program (Enterprise Accounting 2.0 configuration) and specify the required information base.
- In the menu bar of the main program window, click Reports and select Regulated reports. The form will open Regulatory and financial reporting.
- On the tab Report log Place the mouse cursor on the line with the required reporting form. Click on the button Unloading and select Unload. In the opened form 1C: Enterprise confirm the upload of the selected reporting form by clicking on the button Yes. The form will open Specify directory.
