Unloading accounts from 1C. Publications

To unload data from the service to local information base "1C: Accounting 8" Perform the following.

1. Open the information database in the browser you want to unload on behalf of the user's username Running and administration.

2. Make sure that there are no other users at the moment with the application.

3. Go to the section Administration And select Team Unload data to the local version.

4. In the data unloading wizard window that opens, click Proceed. After that, the upload file will be prepared and the application will propose to save it:

Note: The figure shows an invitation to save a file for MS Internet Explorer.. For other browsers, the process of storing the obtained unloading to the local disk may differ.

5. Select the folder to save the file with the file with the archive.

6. Save and install the "Accounting 8" configuration. 3.0 from the user site http://users.v8.1c.ru/. Necessary use the latest versionposted on the user site.

ATTENTION! If you want to download data from the service to an existing local database, refresh its configuration to latest version. How to do it, see the link.

7. Create a new information base "Accounting 8" ed. 3.0 N. local disk Computer.

8. Open the created information database, go to the section Administration And select Team Download data from service.

ATTENTION! When the data is loaded, all user data existing in the local information database will be deleted!

9. After entering the command Download data from service Information message will appear During the download, all the data existing in the database will be deleted? Download?. Press the button Yes(when choosing an option Not The download process will be stopped).

10. Answer the need to download information about users. If you choose the option Yesthen the information will be loaded if you select Not - information about users is not loaded (when choosing Cancel The download process will stop).

In the 1C program: Enterprise Open the necessary information base.

In the menu bar of the 1C configuration menu, click File and select Open. Form Opening.

In the form that opens, select External Processing File itaudit_export_x.x.epf. the corresponding version and click on the button Open.

The loaded file with 1C handlers must be unpacked (unzip). External processing files can be saved in any directory on your computer.

From the program 1C: the company is unloaded by the following data:

Wiring	Unloading operations log for the selected period
Balance	Unloading residues in the context of analytical accounting. By default, data is unloaded as of the last number of each month. If you need to unload residues only at the beginning and end of the selected period, uncheck the box in the field Unload monthly balances at the end of the month
Directories	Uploading the following reference books: fixed assets, intangible assets, expenditures of future periods, counterparties, contracts. In the absence of need to unload the above objects, uncheck the box in the appropriate field

Uploading the values \u200b\u200bof reference books takes considerable time. To upload data without reference values, uncheck the box in the field Directories. In the absence of downloaded values \u200b\u200bof reference books, accounting data can be filled in the formation of a working document.

With a significant amount of wiring to be discharged, discharge them in stages (monthly or quarterly). When downloading data, they will be combined

In field Period Specify the period for which the data will be unloaded.

If necessary, limit the amount of data unloaded by certain accounts, in the drop-down list of the field Selection Select the desired value:

If you need to unload data on multiple accounts, a separate unloading is performed for each account. When importing data, the downloadable data will be combined. When choosing a value all data Posting and residues are unloading for all balance sheet accounts.

In field Archive unloading Click on the button Choose. In field File name Opened form Search archive unloading Enter the name of the file to which data from accounting program. Click on the button Open. The form Search archive unloading will be closed.

Click on the button Unload. After completing the upload data, the corresponding message will be displayed. Close the 1C program: Enterprise.

Transferring data on the accrued wage in 1C on the platform 3.0 is carried out in data synchronization mode between databases. This is a significantly more convenient mechanism compared to the previously exhausted unloading of 1C Accounting in 1C ZUP and back.

How has data exchange changed between databases 8.3 from ZUP 3.0 in the accounting department 3.0 compared with the previous versions of 1C?

In versions below 1C 8.3 from the database of salaries and frames, transfer to 1C Accounting was carried out through a separate file. This file was forced forced in a salary database, unloaded into a separate folder and then loaded into the main base for accounting.

The transition to the platform 3.0 pleased accountants with a fundamentally new mechanism for transferring data from 1C 8.3 Accounting in 1C 8 ZUP and back. This mechanism allows you to exchange information between two bases with almost one mouse click. This feature is called the synchronization of 1C ZUP 3.0 and 1C accounting company 3.0.

How to transfer data from 1C 8.3 Accounting in 1C 8.3 ZUP?

In former versions for the correct reflection of postings on accrual wages It should be unloading from the base, where accounting is conducted by the company's activities, to the base for paying salary. This unloading contained data plan data, posting templates, subconto to discharged accounts, etc.

Now the question of how to unload data from 1c enterprise 8.3 in 1C salary 8.3, not worth it - this exchange It is also carried out within the framework of synchronization.

Is it now unloading data from 1C ZUP 3.0 in 1C Accounting 3.0?

We have already written that how such a data unloading is not implemented now. It was replaced by the synchronization of the unloading of 1C 8.3 ZUP in the accounting department 3.0. About her and will be discussed.

To start the data synchronization, find the "Administration" section in the menu, where you detect the desired string.

If earlier data synchronization was not used, it is necessary to configure it, guided by the algorithm described in the next section. If the settings are already produced, the next partition you can skip.

Initial setup of synchronization of bases 1C 8.3 Accounting and ZUP 3.0

In the synchronization window, first of all, check whether a check mark in the corresponding cage is.

Click on settings.

In a new window, first find the "Configure Data Synchronization" button at the bottom and select the program with which you plan to exchange information. In our case, this is "salary and personnel management, a revision 3.0".

In a new window, set the start date of synchronization. Decide how you want to reflect accruals in accounting - copied by one wiring or broken down by employees. Note, making unloading to all organizations or selectively - relevant to those specialists who keep records of several enterprises in one base.

After that, you can click "write and close". Now proceed to synchronization.

Step-by-step instructions for unloading zp from ZUP 8.3.1 in 1C 8.3

To start the process, click "Synchronize" in the settings window, about which we told in the previous section.

A window appears in which the synchronization process is reflected.

At the end of the process, a window will appear about the successful completion of synchronization.

How to unload from 1C 8.3 ZUP in 1C 8.3 Accounting - Is it possible to do synchronization in the salary base?

The program will equally exercise data exchange when starting synchronization both in the salary database and when starting 1C Accounting. Therefore, where the synchronization is to run, no difference. And also there is no need to duplicate actions in one and another program.

Is it possible to exchange between databases 1c 8.3 from ZUP 3.1 in the accounting department 3.0 in automatic mode?

The 1C developers have provided an automatic synchronization. The regularity of these actions can be configured. On how to do this, we will tell in the next section.

How to configure 1C 8.3 Synchronization 8.3 BP 3.0 and ZUP 3.0 on schedule?

To customize the schedule, go back to synchronization settings.

Go to the Schedule tab and click Customize.

In the window that opens, select the Automatically Scheduled field. And next to click on the hyperlink, which immediately offers default schedule.

The program allows you to set up the most convenient schedule - go to the tab that suits you the most. You can configure daily synchronization at a certain time. You can set automatic launch at certain days of the week, etc.

What errors are when synchronizing data in 1C 8.3?

In rare cases, the accountant must correct the document in the accounting base, and in the salary to leave documents unchanged. Or vice versa. In this case, with the next synchronization, the program itself can cancel the changes made. How to avoid this, we will tell in the next section.

How to limit data transfer from 1C 8.3 ZUP in 1C 8.3 Accounting 3.0?

To limit possible mistakes Due to the accidental change in the past periods, it is worth limiting the synchronization period. To do this, set the change date of the change, noting the corresponding field in the data synchronization window.

Once you set a tick in the field opposite the download date, the link for settings will appear next.

If you use synchronization to exchange with multiple databases, then in the latest tab you can set different dates for different bases.

How to unload data from 1C ZUP 8.3 in 1C Accounting 8.2 and is it possible?

The need to exchange data between such bases does not happen very often. Developers imply that the transition from 1C 8.2 per 1C 8.3 is carried out simultaneously for all bases used by the enterprise. For this reason, the built-in mechanism for the exchange of data on the accrued salary between 1C ZUP 8.3 and 1C Accounting 8.2 is not. But if necessary, you can register external processing For such an operation. Often, regular programmers are also coping with this.

How to transfer data from 1C 8.2 ZUP in 1C 8.3 Accounting and is it possible?

With the inverse situation, i.e., with the exchange of data between 1C 8.2 ZUP and 1C Accounting 8.3, the situation is similar to the above described above. If you need such unloading, an external processing file will be required.

Despite the fact that 1C is the most popular, convenient and reliable information systemHaving a range of solutions in its lineup for automation and processing of absolutely all business processes in enterprises of any scale and field of activity, you still have a need to unload data from 1C in third-party programs or files. In this article, consider what unloading from 1C and show how to unload out of 1C and what problems may occur.

Data that can be unloaded from 1C

1c any configuration regular supports the unloading of such data as:

Printed forms;
Reports;
Tables and lists.

Uploading data from 1C 8.3 is possible in many popular formats:

Microsoft Excel;
Microsoft Word.;
Unloading to CSV;
HTML and others.

Unloading printed forms and reports

Any print form or report in 1C can be saved in the desired format. To do this, you will need to open a form or report, then select in the main menu File - Save as.

After that, the file saving window will be opened, which indicates the name and type of file:

Possible problems when unloading from 1C

This is due to the fact that printed form or the report is not activated at the moment. So that the printed form has become available to save, it is necessary to simply click on the mouse in any place on it:

Unloading to Excel

Processing data in the most popular tabular format requires appropriate unloading. In order to save the desired data in excel format, you need to specify the type in the file saving dialog Excel sheet2007 --... (*. XLSX). Less frequently, you need to save data in the old Format of the Excel sheet (* .xls):

Similarly, choosing the desired format, you can make unloading from 1C in PDF, out of 1C in Word, from 1C to CSV, as well as to other formats.

Unloading of arbitrary tables from 1C

This section will show how you can unload any data, provided that you have rights.

In 1c, a regular mechanism has been developed that allows you to unload any list (for example, a list of documents or reference items). To do this, in the command panel of any list, in the group "Yet" Available team "List":

Information will be withdrawn in a special tabular document. This document looks the same as any other report in 1C, and it can be unloaded in the same way using the command. File - Save as:

How to unload data that is not visible in the list

Often, the problem of unloading a list that arose is accompanied by the need to add speakers there, which are accurately in the document (directory), but for some reason they are not visible in the current list. Example: add to the "Clients" list to unload the "Phone" field, which is displayed only in the additional panel on the right:

So that the phone can be unloaded out of 1C, it is still necessary to add it to the list. To do this, you need to call the team "More - change the form." Next, we need to find the desired speaker list. There is one trick: the developers of typical configurations almost always add the field "Link". If you get up on it, and then click the button That we will see all possible fields of this reference book. Find a field "Telephone" And we put a tick of use.

After that, customer database with phones can be unloaded into a file through a regular command. "List" and sell competitors.

To unload the goods in the form of settings of the exchange parameters, the basic settings of the node must be performed and the option is noted. Activate unloading information about nomenclature On the tab Data exchange mode. The upload settings window opens by the button Tune and has the following form:

On the tab General settings Indicated catalogs where goods and information on them are unloaded. If noted Classify the nomenclature of the nomenclatureThe groups of the nomenclature will be the types of nomenclature.

Catalog table:

Note: At least one correspondence of groups / species of the nomenclature of catalogs should be specified on the site.

On the tab Products Specify the settings of the dischargeable goods.

With the option noted Unload goods Information on products will be unloaded.
With the option noted Pictures and files Pictures and files of goods will be unloaded, and only new or modified pictures and files are unloaded. The option is available only when the option marked Products.
Option Unload property values This means that properties values \u200b\u200bwill be unloaded into goods, even if the properties themselves are not unloaded (it should be noted when the properties are unloaded separately by another exchange setting).
If flag is installed Unload barcodesthen their barcode will be unloaded for goods. If the barcodes are not used, then it is better not to put this flag so as not to slow the work of the unloading.
With the option noted, the information will be unloaded when information is planned to be the nearest arrival of the goods.
Using the field The number of goods in the package Worth how many products should be in one package with data.

Setting the Compliance of the Nomenclature Fields:

In this section, the rules are set, which XML field of the product is unloaded by a certain product information. The main details are constant, there are no restrictions on additional details. Utility fields of the XML file cannot be edited.

Field name values 1C. There may be both predefined (for example, barcode, name) and arbitrary. Arbitrary field 1C. maybe a piece of code 1C.The appeal to the nomenclature occurs through the "Nomenclature." . For example, in the XML-field of the names, it is possible to insert the expression "Nomenclature. Arcticula +" - "+ Coolp (nomenclature. Name)", as a result of which a nomenclature with the name glued to the site will fall into the site.

On the tab suggestions The settings of the discharged proposals are specified:

If option is noted Unload sentences, then the goods offer will be unloaded and the following settings are available:

With the option noted Pictures and files Pictures and proposal files will be unloaded, and only new or modified pictures and files are unloaded.
Option Unload characteristics only with residues It is necessary for additional selection of proposals and means that only those trading proposals will be unloaded, the number of which is greater than zero.
Option Unload offer only with price It is necessary for additional selection of proposals and means that if the proposal has no prices for disclosable agreements (types of prices), then such a proposal is not unloaded.
Mark option Unload the nomenclature as a proposal It is necessary when it is necessary that the goods are discharged as a proposal, even if it has characteristics. If the option is not installed, then suggestions will only characterize the goods and goods that do not work according to the characteristics.
Option Unload property values \u200b\u200bin sentences This means that property values \u200b\u200bwill be unloaded in the proposals, even if the properties themselves are not unloaded (it is necessary when the properties are unloaded separately by another exchange setting).
Option Unload the characteristics of proposals Determines whether it is necessary to unload the characteristics of the proposals in proposals (if they are enough to unload them as properties).
If flag is installed Unload barcodesThen, their barcodes will be unloaded for proposals. If the barcodes are not used, then it is better not to put this flag so as not to slow the work of the unloading.
With the option noted Unload the planned dealement date The offer will be unloaded information when it is planned to be the nearest arrival of the goods.
Option Unload components Used to unload the sets.

On the tab Properties The settings of the discharge properties are specified:

If option is noted Unload PropertiesThe properties of goods and suggestions will be unloaded.

In the table part, you can specify which properties of goods should be stored in highload blocks, which affect the price, which should be unloaded into the properties of proposals, and which in the properties of goods.

Note: Property type File Always stored in Highload blocks.

By button Fill out the use of default properties Fill flags of the use of properties in products and suggestions on a given algorithm for the exchange module (if, in one of the unloaded goods / proposals, the property is used, then the check box is not installed).

On the tab Residues The settings of the discharged residues are specified:

On the tab Prices Settings for price unloading are set:

With the option noted Unload prices Information about the prices of goods will be unloaded.

Perform the unloading of goods to the site

Automatic unloading of goods is carried out in accordance with the configurations of the Autobrament. For manual launch The process of unloading goods is necessary:

At the end of the unloading, the result can be viewed in the administrative section of your site: