Loading of price-lists of suppliers from Excel. Upload your own prices

Loading of price-lists of suppliers from Excel. Upload your own prices

UAH 3 500
Buy
Загрузка прайс-листов поставщиков из Excel. Загрузка собственных прайсов
Setting allows you to automatically download price lists of suppliers, as well as their own prices.
Downloading price lists is performed by searching by:
  • article number and name;
  • matching table.
It is possible to configure other ways to search for an item, for example: by vendor code.

You can also use this setting in other documents, where you need to download the table part from the Excel file.



Setting allows you to automatically download price lists of suppliers, as well as their own prices.
Downloading price lists is performed by searching by:
  • article number and name;
  • matching table.
It is possible to configure other ways to search for an item, for example: by vendor code.
It is possible to preserve the correspondence of columns in Excel with downloadable data for different price options.
A simple and reliable solution that works great.
If it is not possible to compare the goods according to the Articles, then you can specify the comparison of the goods in the correspondence table, where the correspondence of the names of the goods and articles, which are specified in Excel, to the goods and characteristics of goods (if necessary) in "1С:Підприємство".

Processing is called from documents:

  • "Setting prices of the item";
  • "Setting prices of the counterparty nomenclature".

It can be used in configurations "1С:Підприємство", where these documents are, namely:

  • Trade management;
  • Manufacturing Enterprise Management;
  • Trade Management, revision 2.3;
  • Accounting, edition 1.2.

In addition, this setting can be used in other documents where you need to load a tabular part from an Excel file.


Multiple screenshots to demonstrate the work

Document "Setting the price of an item".


Fig. 1. The document "Setting the prices of the item", the call processing "Fill from Excel" to fill in the table part of the document.


Fig.2. The processing dialog form “Loading the table part of the document from the Excel file”.

On the form "Loading the table part of the document from the Excel file", the tab "Import Settings" sets the range of lines in the Excel file from which to start the import and the number of the last line. Also, the correspondences of the columns in the Excel file with the number of the TMC column, article number, characteristic, if used in the database, and the number of the price column are specified.


Fig.3. Form processing dialog "Loading the table part of the document from the Excel file".The ability to use the item matching table. The tab "Correspondence table for our item" is activated.



Fig. 4. On the tab “Correspondence table for our nomenclature” the following data is filled in: goods and materials line, article, characteristic nomenclature by line, the nomenclature of conformity and the characteristic of the nomenclature of conformity.


If the name of the item 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 down the corresponding position in the item reference book.


Fig. 5 . On the tab "Correspondence table counterparty nomenclature" fill in the data on the name of the counterparty item, counterparty number, the nomenclature of conformity and the description of the nomenclature of conformity.


Document "Setting pricesnomenclature contractors".


Fig.6. The document "Setting the prices of the counterparty nomenclature", the call processing "Fill from the Excel file" to fill in the table part of the document.


Fig.7. The processing dialog form “Loading the table part of the document from the Excel file”.
 
The form contains the type of the item correspondence table-Counterparty nomenclature, the tab “Import Settings” sets the range of lines in the Excel file from which to start the import and the number of the last line. Also set the correspondence columns in the Excel file with the name of the product, the characteristics, if used in the database, and the number of the column with the price.


Fig.8. The ability to save the settings of the correspondence columns of the Excel file with the data for BAS.

The setting provides the ability to save selected column matches. You can save different variants of correspondence of columns for different suppliers, for Excel files, with different sequence of columns.

This solution includes solution "Loading tabular parts of documents from Excel files". This reference defines the correspondence of columns for loading tabular parts of documents from Excel files.



Fig. 9. On the tab “Correspondence table for our item” you can set the item name matching settings in the Excel file to the item list item in the database.

If the name of the item in the Excel file is not found in this table, then it will be added to this table and in the future it will be necessary to put the corresponding position in the item reference book.


Document "Receipt of goods and services".

 

Fig.10. The document "Receipt of goods and services", call processing "Fill from Excel file" to fill in the table part of the document.


Fig.11. The processing dialog form “Loading the table part of the document from the Excel file”.

The form contains the type of the item correspondence table-Counterparty nomenclature, the tab “Import Settings” sets the range of lines in the Excel file from which to start the import and the number of the last line. Also set the correspondence columns in the Excel file with the product name, quantity, price and column number with the sum.


Fig. 12. On the tab “Correspondence table for our item” you can set the item name matching settings in the Excel file to the item list item in the database.


If the name of the item in the Excel file is not found in this table, then it will be added to this table and in the future it will be necessary to put the corresponding position in the item reference book.

Cost of work: 3500 UAH  (taking into account the cost of integration into the configuration of the customer).

NCT Company
www.nct.ua

info@nct.ua







(0)



  • Comments
  • Facebook
Loading comments...

Recommended products: