Setting allows you to automatically download price lists of suppliers, as well as their own prices.
Processing is called from documents:
- "Nomenclature price setting";
- "Setting the prices of the nomenclature of counterparties".
Can be used in configurations 1С, where there are these documents, namely:
- Managing a trading enterprise;
- Managing a manufacturing enterprise;
- Trade Management, Edition 2.3;
- Accounting, revision 1.2.
In addition, this setting can be used in other documents, where you need to download the table part from the Excel file.
Multiple copies of screens for demonstration work
Fig. 1. The document "Setting the prices of the item", calling the processing "Fill from Excel file" to fill the table part of the document.
Fig. 2 Form of the processing dialog "Loading the table part of the document from the Excel file". The form specifies the line number of the Excel file from which to start the import and the number of the last line. Also, the column numbers with the name of the product, the characteristic, if used in the database, and the column number with the price.
Fig. 3. Dialog for setting the correspondence of the item name in the Excel file to the item "Nomenclature" in the database. If the item name in the Excel file is not found in this table, it will be added to this table and in the future it will be necessary to put it in the directory of the nomenclature.
Fig. 4. The form of the processing dialog "Loading the table part of the document from an Excel file", caused from the document "Setting the prices of the nomenclature of counterparties".
Fig. 5. The processing form "Loading the table part of the document from an Excel file" on the tab "Table of conformity of the nomenclature of counterparties", where the correspondence of the names, codes or articles of the nomenclature of counterparties to our nomenclature in the reference book "Nomenclature" is placed. If the item item in the Excel file is not found in the table during import, it will be added, it will remain consistent with our nomenclature.
Cost of work: 2600 UAH taking into account integration costs in the configuration of the customer.