Uploading an invoice from 1c to xml. Tools for creating uploads

It will save time on entering information about the purchase of Peterhost services into 1C.
To do this, you need to upload an XML file into 1C and from it a document “Receipt of goods and services” will be generated, containing information about the purchased services. An invoice can be generated based on this document.

Detailed instructions are provided below.

1. Connection of external processing

1.1. If you are using the 1C:Enterprise 8.X information base with the “Enterprise Accounting 2.0” configuration, to load a document in CommerceML format you need to connect external processing ()
This can be done in two ways:
1. Save the external processing file locally to disk and open it through the menu “File” → “Open” before each loading of data in CML format.
2. Connect processing to the information base (IS) permanently. Then it will be available to everyone (if working over a network) from the menu “Tools” → “Additional reports and processing” → “Additional external processing”.

  • In the “Service” menu, you must select “Additional reports and processing” - “Additional external processing”.
  • Click the “Add” button. The form for adding a new directory element will open:
  • In the “Name” field, indicate the name of the processing, for example, “Loading data in CommerceML format (RU-CENTER Group).”
  • Click the file selection button and specify the path to the download processing file ().
  • Click the “OK” button. Now the processing is connected to the infobase and is located in the “Additional external processing” directory, and it can be opened by double-clicking the mouse.

1.2. If you are using the “Manufacturing Enterprise Management” (version 10.3 and higher) and “Trade Management” (version 1.3 and higher) configurations, this processing is already enabled and you can proceed to step 2.

2. Formation of the document “Receipt of goods and services”

As a result of the steps below, information about the services purchased from Peterhost will be entered into 1C.
1. Next, you need to save an XML file with the data of the “Receipt of goods and services” document for the required period to your computer. The file in XML format is located in the Personal Account section under the link “XML for 1C”.
Click the selection button to the right of the “Data file name” field and select this file (see Figure 1). To the question “Read data from a file?” answer "OK". The data file will be read by processing.
2. If processing is able to determine all the correspondence between the file data elements and the infobase data, the question “Save the data to the infobase?” will be asked. If you answer “Yes”, a new document “Receipt of goods and services” will be created. Go to step 3.
3. If not all data matches are identified, the message will be displayed: “When loading data, the program was unable to automatically find information security objects corresponding to the elements transferred in the exchange file...” and will offer to perform the comparison manually. In this case, you must do the following:

  • Click "OK". A form for comparing file objects and information security will open. It has several tabs that correspond to different types of objects (organizations, contractors, items, etc.). If any type of data has not been matched, there will be red exclamation marks on the corresponding tabs (see Figure 2).
  • Go to the appropriate bookmarks and manually match the elements. It should be taken into account that matches of counterparties and organizations are searched for by TIN, and matches of nomenclature are searched first by article number, then by name. If the element that corresponds to the file data is not in the IB, then it can be created automatically using the file data by clicking the “Create using data from file” button.
  • When adding items, you must check the “Service” property (see Figure 3). You can also change the full and short names of an item in the nomenclature.
  • On the “Accounts” tab, it is advisable to add item accounting accounts so that when creating the “Receipt of goods and services” document, these numbers are entered automatically. For example, the following values ​​can be set for services: “Accounting account” – 25 (Overall production expenses) and “Accounting for submitted VAT” – 19.04 (VAT on purchased services) (see Figure 4).
  • After comparing all the elements and clicking the “OK” button, the program will ask for confirmation to upload the document to the information security system, after which it will create a new document “Receipt of goods and services” (see Figure 5).

3. Posting the document “Receipt of goods and services”

To post the “Receipt of goods and services” document, you need to open it by double-clicking and fill in the missing fields, such as “Advance offset” (for example, “Automatic”) and the fields on the “Settlement accounts” tab (see Figure 6). The values ​​of these fields are determined by your organization's accounting policies. To post the document, click the “OK” button.

4. Formation of the “Invoice” document

After successfully creating and posting the “Receipt of goods and services” document, you can use it to create the “Invoice received” document. To do this, click on the appropriate link in the lower left part of the document form.

Transferring information between databases is one of the tasks of their support and administration. For its effective implementation, processing is created in automated 1C complexes. They greatly facilitate routine work, speed up the processes of uploading and downloading information and at the same time implement control over its correctness. Uploading from 1c to xml allows you to create a file with the contents of any configured configuration object, and use it when you need to upload data to an identical configuration.

Tools for creating uploads

To export information contained in databases, the xml format is mainly used. For 1C, many processing methods have been developed (for example, UploadLoadDataxml82 epf), with the help of which it is possible to output and load data to a file. In this case, the user must receive a file of a certain structure, which allows the information stored in it to be loaded into the native database or transferred to another location. When creating an upload, the following rules must be observed:

  • Save the created files until complete recovery and completion of procedures for verifying the correctness of the transferred information;
  • If you use processing as a backup tool, create separate subfolders for data copies and keep a log of them for quick retrieval.

Supplied in the 1C user support program, which can be found on the ITS website or disks, it is an excellent tool for exporting and importing information. A computer user can upload both the entire database and its individual objects, and in addition to the actual export, various operations are performed to check information that help get rid of critical errors in the data. Processing 1c upload to xml works in two modes:

  • Unloading. Creates a file containing user-defined pageable objects;
  • Loading. Reads a previously exported file and writes the information contained in it to the information base.

Processing allows you to check objects for invalid characters, and also includes a function for exporting information with restrictions.

Uploading can be used not only when exchanging information between 1C databases. With its help, you can ensure the integration of various complexes, for example, 1C and the Parus system. The versatility of the XML format allows you to create programs for transferring information for almost any information banks. Processing, uploading and downloading xml data is the most important tool for exchanging information.

The process of uploading data toxml

Let's look at how to upload from 1c to xml in normal mode. After downloading the processing UploadLoadDataxml.epf and opening it, you must perform the following steps:

  • Select objects for export;
  • Set up the necessary filters, for example, by period;
  • Determine the location of the file with information on the disk subsystem;
  • Start unloading objects.

It must be remembered that the header part of the upload file format differs from the file format used when uploading according to exchange plans.

xml

The xml is loaded into 1c into the receiving database with a configuration identical to the source database. Before loading xml 1c into 1c, you need to open processing in the receiving database. Then you need to specify the path to the previously uploaded file and download the data by clicking on the “Load data” button.

If necessary, checkboxes are activated to load data in exchange mode in a distributed infobase and ignore errors that occur when loading objects.

After this, you need to check the databases and make sure that all elements are loaded correctly so as not to lose them, for example, if an error occurred in the event handler after loading the object.

The XML data format according to the CommerceML (CML) standard will allow you to save time on entering information about the purchase of services of the company RSIT JSC into 1C. Upload the XML file into 1C and it will generate a “Receipt of goods and services” document containing information about the purchased services. An invoice can be generated based on this document.

Detailed instructions are provided below.

1. Connecting external processing

1.1. If you are using the 1C:Enterprise 8.X information base with the "Enterprise Accounting 2.0" configuration, to load a document in CommerceML format you need to connect external processing () (see Figure 1). You can do this in two ways:

2. Connect processing to the information base (IS) permanently. Then it will be available to everyone (if working over a network) from the menu “Tools” → “Additional reports and processing” → “Additional external processing”.

Picture 1

  • In the “Tools” menu, select “Additional reports and processing” - “Additional external processing”.
  • Click the "Add" button. The form for adding a new directory item will open.
  • In the “Name” field, specify the name of the processing, for example “Loading data in CommerceML format (RU-CENTER Group)”.
  • Click the file select button and specify the path to the download processing file ().
  • Click OK.
  • Now the processing is connected to your infobase and is located in the “Additional external processing” directory, and can be opened by double-clicking.

1.2. If you are using the "Manufacturing Enterprise Management" (version 10.3 and higher) and "Trade Management" (version 1.3 and higher) configurations, this processing is already enabled, go to step 2.

2. Formation of the document “Receipt of goods and services”

As a result of the steps below, information about the services you purchased from JSC RSIC will be entered into your 1C account.

A) save to your computer an XML file with data from the document “Receipt of goods and services” for the period you need. The file in XML format is located in the “Reporting Documents” section of your personal account under the “XML for 1C” link.

Click the select button to the right of the Data File Name field and select the file (see Figure 1). To the question “Read data from a file?” answer "OK". The data file will be read by processing.

B) If processing manages to determine all the correspondence between the data elements of the file and the data in your infobase, then the question “Save the data to the infobase?” will be asked. If you answer “Yes”, a new document “Receipt of goods and services” will be created. Go to step 3.

C) If not all data matches are identified, the message will be displayed: “When loading data, the program was unable to automatically find information security objects corresponding to the elements transferred in the exchange file...” and will offer to perform the comparison manually. In this case, you need to do the following:

  • Click OK. A form for comparing file objects and information security will open. It has several tabs that correspond to different types of objects (organizations, contractors, items, etc.). If any type of data has not been matched, there will be red exclamation marks on the corresponding tabs (see Figure 2).

Figure 2

  • Go to the appropriate bookmarks and manually match the elements. It should be noted that matches of counterparties and organizations are searched by TIN, and matches of items - first by article, then by name. If the element that corresponds to the file data is not in the IB, then it can be created automatically using the file data by clicking the “Create using data from file” button.
  • When adding items, you must check the “Service” property (see Figure 3). You can also change the full and short names of an item in the nomenclature.

Figure 3

  • On the “Accounts” tab, it is advisable to add item accounting accounts so that when creating the “Receipt of goods and services” document, these numbers are entered automatically. For example, the following values ​​can be set for services: “Accounting account” - 25 (Overall production expenses) and “Accounting account for submitted VAT” - 19.04 (VAT on purchased services) (see Figure 4).

The development is intended to automate routine operations for entering invoices from a supplier into 1C. Allows you to quickly fill out the tabular part of the receipt of goods and services, as well as create goods that are not yet in 1C. Now the data loading time will be reduced to 5 minutes!

Problems that the development of “Loading invoices into 1C from Excel” solves

    Accelerates the creation of documents “Receipt of goods and services” and “Sales of goods and services” To do this, just fill out the “header” of the document and start processing the document. Now you do not need to enter each product manually and fill out the columns (customs declaration number, unit of measurement, quantity, price, amount, etc.).

    Prevents duplication of goods in the 1C database Human error in filling out important documents is a well-known problem. Now you can reduce it to a minimum. Processing itself will determine which products are already in the database and which need to be added. The addition will also happen automatically, which will allow you to avoid, among other things, grammatical errors in the name of the product.

“Downloading invoices into 1C from Excel” is a real help to operators and accountants. Processing allows you to avoid errors and inaccuracies, saves time and effort for employees, and saves the company money due to the absence of errors in documents.

Examples of using the development “Loading invoices into 1C from Excel”

    Fast creation of goods receipts. If your store regularly receives a fairly large number of electronic invoices, then the need to automate the receipt of goods is obvious. Your 1C users will no longer first search in 1C to see if such a product already exists in the database, then add it to a document or create a new product, and then carefully fill out the quantity and price, checking with documents from the supplier. Everything happens quickly, simply, and the data is transferred to 1C as accurately as possible.

    You are an intermediary between the wholesale company and the buyer.

    If your workflow looks like this:

    1. They order a certain amount of goods from you;

    2. You purchase this product from your supplier;

    3. Sell this product at a premium to the customer;

    then this processing automates this process. You simply upload the invoice to “Receipt of goods and services”, and then upload it to “Sales of goods and services”, indicating the required margin. This, in turn, will save you from having to manually calculate the markup percentage. Everything will be done automatically!

How does the “Download invoices into 1C from Excel” solution work?

Advantages of developing “Loading invoices into 1C from Excel”

    The development is ready for use immediately after installation You just need to copy the file to your computer and add it using the file upload service in 1C. A step-by-step guide is provided for users. If difficulties arise, we are ready to help install a solution using remote access to your computer.

    The development is easy to use and does not require special skills In order to master loading invoices into 1C from Excel, no additional training is required.

    The development interface is designed according to the standards adopted by 1C It is no different from other reports, processing and documents in 1C. Standard windows and buttons and standard data presentation are used. You don't have to get used to something completely new. It’s just that now there will be another opportunity in 1C.

    The development does not affect the mechanisms of standard configurations Your 1C program will continue to be easily updated, and all functions will work as before!

Technical Features and Support

It is possible to adapt the development to individual orders.

The development is intended for configurations:

  • Enterprise accounting ed. 3.0
  • Enterprise accounting ed. 2.0

1 year warranty We are ready to quickly solve any possible problems related to the integration and quality of the program.

All errors that arise in the operation of the solution are corrected promptly and free of charge. both individually at the request of users, and in planned releases, during the warranty period.

Procedure for purchasing the development “Loading invoices into 1C from Excel”

In accordance with the legislation of the Russian Federation, the buyer has the right to refuse the ordered goods at any time before receiving it.

Attention! After receiving a set of source files, a refund to the customer becomes impossible, since the software is subject to copyright and is protected as a literary work (Civil Code of the Russian Federation, Part 4, Article 1259). In turn, non-periodical publications in accordance with the Law on the Protection of Consumer Rights of the Russian Federation (Chapter 2, Article 25) are included in the list of non-food products that are not subject to return or exchange (as amended by Resolutions of the Government of the Russian Federation dated October 20, 1998 No. 1222, 06.02 .2002 No. 81).

The fact of transfer of goods is considered to be the receipt of a set of source files by e-mail or through other electronic exchange services.

Solution cost

Solution cost“Loading invoices into 1C from Excel” is from 18,000 rubles

You can order individual modifications of this solution to suit the specifics of your activity. Evaluation of modifications is carried out on an individual basis upon request.

Solution order form

You can leave all questions, wishes, as well as requests to purchase this development in the comments. The website team specialists will promptly answer any questions regarding the operation of the “Downloading invoices into 1C from Excel” solution.

No registration required to post comments!

Processings are modified Purchase and Sales Books. A Control button has been added, when clicked, a Sales/Purchases Book report is generated and information messages are issued about blank data (TIN, KPP, Address, Full Name). By clicking the Generate button, invoice files in xml format are generated in the directory on disk, then these files must be loaded into the TaxpayerYUL program (you can download it for free here http://www.nalog.ru/rn55/program/all/nal_ul/), create sales/purchase books there, and then create a VAT return based on them.

More details on working with Taxpayer Legal Entities:

1. Select or create, if the Organization has not been created (TIN and KPP must be the same as those of the organization in 1C, otherwise invoice files containing the TIN and KPP in their name will not be loaded). Select the reporting period.

2. Upload invoice files (menu Documents - Information for VAT declaration - Issued invoices / Received invoices, depending on what we are loading - first issued by the invoices, then received)

When you click the Load button and select the directory into which the SFs were uploaded from 1C, a window will appear, as in the screenshot above. It is necessary to mark the SF by checking the boxes opposite them, you can mark everything at once by clicking on the Green checkbox button. After making the marks, you need to click the Select button, the selected invoices will be loaded into the Taxpayer of Legal Entities

3.The next step is to create Purchase/Sales Books (Menu Documents-Information for VAT returns-Purchases and Sales Books - Add button, after which an empty book will appear

To fill it with data on the sf, you must, as shown in the screenshot above, stand on an empty drain and press the Select from directory button.

By setting the appropriate switches in the dialogs, as in the screenshot above, and clicking OK, after that the book should be filled, you need to calculate the final fields and check the filling by pressing the appropriate buttons

Afterwards, you need to burn the book by pressing the button with the floppy disk.

4.When the book of purchases and sales has been generated, you can begin to generate a VAT return (menu Documents - Tax reporting - Add - select Tax return for corporate income tax from the list) and fill out data for sections 8 and 9 based on the books.

In the window that appears, click on the Transfer data from purchase/sales books button (depending on section 8 or 9).

Mark all invoices using the Mark all button, click Control, view/correct errors. All.

Processing works on platform 8.1, can be converted to platform 8.2, 8.3 (simply open in the configurator under the lower platform and save) for configuration BP1.6.

Work with imported goods (customs declaration) is not taken into account; if someone has such a situation, I will finalize the processing by agreement.

Comments, shortcomings, suggestions - please report.



 

It might be useful to read: