1С8: Loading of price-lists of suppliers from Excel. Upload your own prices

Настройка позволяет выполнить автоматическую загрузку прайс-листов поставщиков, а также собственных прайсов.
Загрузка прайс-листов выполняется с поиском по:
  • артикулу и наименованию;
  • таблице соответствий.
Возможно настроить другие  способы поиска номенклатуры, например: по коду поставщика.

Также данную настройку можно использовать и в других документах, где необходимо загрузить табличную часть из файла Excel.




Industry ATP, transport management  Printing houses  Wholesale  Medical clinics, medical institutions  Rent of equipment for rent  Service station, car service, sale of spare parts and cars  Online store  Tourism  
Category Additional settings  Common forms  Price Lists  
Type Management Accounting  
Cofigurations Trade management  Manufacturing enterprise management  Trade Management2.3  
 1С8: Loading of price-lists of suppliers from Excel. Upload your own prices
UAH 2 600
Buy
Full description
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.

Processing is called from documents:

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

It can be used in configurations 1C, 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 1C.

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: 2600 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...