It is often necessary to obtain data from 1C 8.3 and save the information to the external file, in other words, make unloading from 1C enterprise. The task is almost always done without attracting 1C programmers.
Consider the ranks useful SovietsWith which you can unload data from 1C to the external information system.
In 1C there are several methods with which you can get information without attracting specialists:
- Uploading the base of 1C 8.3 entirely - for subsequent download on another computer
- Saving reports and printed forms in Excel, Word or PDF
- Unloading tables from 1C
- Receiving information using the query console
Read more about them:
How to unload the base from 1C 8.3 entirely (in file.dt)
To do this, you need to enter the configurator mode, then select the "Administration" item in the main menu - "unload information base»:
Then you will only need to specify the name of the future file and its location on the disk.
For later booting to another database, click on the "Download Information Database" button and select a preloaded file.
Unloading from 1C in Excel reports and printed forms
This method is universal and very simple. For this, it is enough when opening a printed form or report.
For example, we open the printed form of bargain 12, press Ctrl + S (or in the File menu - save both) and select the file type and its name:
For the same system - the report is unloaded into two clicks:
Get 267 video tutorials for 1C for free:
Available in main formats - Excel, Word, PDF, HTML, TXT, and TD.
Unloading tables from 1C 8.3
Often there are such banal tasks as "get a list of payments for the current year", "unload the book of shopping or sales" or "unload goods from the invoice number 226". Solve such tasks are simple enough.
For example, I need to get all the arrivals from the counterparty "Vector" with the amount of more than 1000. Let us open the list form and install the desired selections in the list:
The system will propose an output option - in tabular document Or text, choose tabular. The 1C program will display information in such a tabular document that, like reports, can be saved to the format you need:
Such actions can be made practically for any tabular part in 1C 8.2. For example, we needed to unload the list of products from arrival No. MSK00003, not a problem. It is done very simply - open the document, call context menu And after a couple of clicks, we obtain the desired unloading in the desired format:
Unloading in Excel Magazine Magazine from 1C:
Receiving information using the query console
However, not all information can be found in a simple tabular part 1C 8.2. Sometimes it is required to collect data from multiple data sources, connect them to some fields.
This method is suitable for technically savvy people who know the basics of the query language. It is to get the result of the request with the help and save it to the format you need.
For example, you need to get all the counterparties suppliers and their telephone number. To do this, write the following query:
The resulting table can also be unloaded into the desired format File:
You can download the data to another database 1C using "". See the video design on the example of the nomenclature:
Need to documented this information There was a result of refusal to work, especially in the subject area of \u200b\u200bthe deposit of the VAT. Note will be useful
in particular, the deposited users of 1C enterprise 8, where there are no difficulties when working with regulated reporting.
So, suppose we need to form and unload VAT declaration for the 3rd quarter of 2010
Go: Reports - Regulated - Tax Reporting - VAT.
The report has a title list, 7 sections and 2 applications. Fold the necessary pages and indicators. Uploading is performed using the reporting data unloading (version 4 formats, version 5). Run it. In the list of reports to unload the double click, you can go to the desired report page. This opens the "Select Report section" window.
About the most frequent problem With unloading tax reporting from 1C Accounting 7.7.
If the program issues type errors:
Not filled with an indicator in section 2 \\ string 040 \\ graph 3.
Not filled with an indicator in Appendix 1 to section 3 \\ Row 030.
The indicator in Appendix 1 to section 3 \\ string 040 contains an incorrect value: the length of the value of the indicator should be at least 10.
The indicator in Appendix 1 to section 3 \\ string 050 contains an incorrect value: the value of the value of the indicator should be at least 10.
Not filled with an indicator in the checkpoint.
What to do if the regulated report from 1C is not unloaded: Accounting 7.7?
Program 1C supports several options for filling out the report, which are enhanced by the option button. As a rule, the error in the unloading is that the necessary indicators remain empty. In particular, this concerns the cases of unloading pages of reporting 1C, the filling of which is not meant when unloading. In other words, we created report pages, but did not fill them.
Borrowing errors immediately before unloading on each page of the report, click the option to the button and make sure that there are no options for unnecessary pages.
If a list of report filling options appear, select item<удалить текущий>, Close the page and refuse to save the report
. This is how it is possible to delete the pages of the report created by mistake.
General rule It is to save only those sections that we plan. To help us in the root of the list of regulated reports there is a processing of maintaining stored reporting data. This service allows you to track which pages are created for each of the reports. From here you can follow the transition to the desired section and, if necessary, remove it.
Where are the completed regulated reports stored?
C: \\ Program Files \\ 1CV77 \\ 1SBDEMO \\ ExtForms \\ 01028561.77 \\ 6 301001.02 \\ 1152017.10 \\ 31120100.RVS
- C: \\ Program Files \\ 1CV77 \\ 1SBDEMO - information base directory;
- 01028561.77, 6301001.02 - INN and CAT of the organization (in this case, from the demo base);
- 1152017.10 - Code designation report
- 31120100.RVS - report file with RVS extension
In the programs "1C: Accounting 8" and "1c: Accounting Corp" Editorial 3.0, starting from version 3.0.48, it is possible to download the regulated report from the electronic representation file. About how to enjoy such an opportunity, the $ 1C experts said.
Create or open a regulated report from the electronic representation file is possible as follows:
- by transferring the data regulated reports between the platform configurations "1C: Enterprise";
- by downloading data from files formed by other accounting programs or services, including transferring files sent from programs and / or services of specialized communication operators.
Mechanism of downloading reports
The mechanism is intended for organizations with branch structure and separate units using various application solutions on the 1C: Enterprise platform: versions of version 7.7 and regulated reports of versions of version 8.x, containing the regulated reporting subsystem.
The mechanism allows you to upload data from XML files of electronic views to regulated reports for FTS, FSS, Rosstat and other controls.
For example, if the report is formed in another program 1C or in third-party programWhen the report is unloading, a file is formed. This file is the basis for the reporting mechanism.
Opportunities for downloading reports
- loading data into an existing regulated report;
- creating a new report from the unloading file;
- in a downloaded report changing the reporting period within acceptable limits (no earlier than 2015);
- in the download report, the choice of another organization;
- editing a downloaded file;
- sending a report through 1C reporting.
How to upload a report
1. Creating a new report from the unloading file in the report log
In the report log when clicking on the button Download Choose The form of the report.
Then, in the window that appears, find the folder with the saved file and open it.
The report file window opens. The program will automatically determine Report view, report period, document type and organization.
In the window you can choose:
- another organization (or add a new one);
- another period or set the period in the report for which the report period did not boot (absent in the unloading file);
- type of document (primary \\ corrective).
To open the on-screen form of the report, click the button Download and close.
What should pay attention to
1. There is no way to decrypt data.
Cause: Decoding is subject to data obtained directly from the accounting program.
No solutions in the absence of initial accounting data.
Cause: Indicators are loaded in original form, without distortion through the authoring.
Decision: Open the report settings and uncheck the box in the field. Disable the automatic calculation of the calculated cells.
The downloaded report can, if necessary, adjust, check, unload and send to the control system through 1C reporting.
2. Loading data to an existing regulated report
If you need to download Data to an open report, use the button Downloadon the top panel open report.
Important!
- When you try to download the file that does not correspond to the open report or its reporting period, a message will be issued about the impossibility of loading.
- There is no possibility to download data from the file with an electronic representation format different from the report approved for this form.
- If the data load is loaded into the existing report and the process is completed with an error due to a non-compliant format, the previous filling of the report does not change.
- When the file is loaded into an open report, the data in the existing report is cleared and the data from the unload file is loaded.
The remaining actions are similar to those specified in paragraph " Creating a new report from the unloading file in the report log. "
For such a complex report consisting of multiple unloading files, as a VAT Declaration, you must upload all the electronic representation files.
In the download window to add files, use button Add.
Each downloaded file can be opened.
After pressing the button Download and close In the VAT Declaration, sections from all downloaded email files are filled out and the procedure for checking counterparties service FTS is started.
Quite often, users have the 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 Another person is a report, make calculations in Excel. Unfortunately, not all users know that unloading such data from 1C is very simply independently without help.
It is not rare the need to unload the list of any data from the table part of the document, the list of the list, documents log, etc. Such tasks are often single, and it is impractical to attract a specialist for writing a report.
For example, you need to get the entire nomenclature with the type of "Materials". At the same time, only the "Nomenclature" and "Unit" columns are needed.
In the case when it is necessary to unload data with their filtering, first of all, you must configure the list in the "More" menu.
In the window that appears from the left side (available fields), you must choose those for which you will make the selection (in this case, the "view of the nomenclature"). In the right side of the window, the values \u200b\u200bof the selection parameters are set. At the same time, the type of comparison is not limited to the equality alone.
After the evolution was installed, only those positions that are suitable for a given condition will be displayed in the form of a list of the Handbook "Nomenclature".
The next step will be withdrawal this list in a tabular document.
In the "More" menu, select "Display List".
If you need to withdraw not all the speakers, as in our example, then install the checkboxes only on those that are necessary.
As a result, you get, in fact, a report that can be saved to any available format. How to do this will be discussed below. Similarly, you can unload the tables of documents and reference books, data from documents logs, lists and not only.
Unloading reports and printed forms from 1C
Any report, printed form, a tabular document (for example, which we received in our example) in 1C 8.3 can be unloaded into the external file in two clicks.
On the top of the program there is a saving button to an external file ("Taxi interface"). It will be active on any reports and printswhere the saving is available.
Unloading 1C database
This method is necessary in cases where the 1c database must be unloaded entirely, for example, to create a test copy.
Go to the desired information database in the configurator mode.
In the "Administration" menu, select "Unload Information Base".
Specify if necessary, another file name and path to save.
The resulting file of the unloaded data with the extension * .dt is further very easy to download. To do this, in the Configurator mode in the "Administration" menu, select "Download information database" item and open the previously obtained * .dt file.
