1c trade management 11 comparison of supplier nomenclature. How to register goods and supplier prices? Loading supplier prices

To register goods and supplier prices, use the Supplier Price Registration document.

The document records the goods that the supplier supplies and the prices at which he supplies them. In fact, the supplier's price list is registered. Each time the supplier's price list is updated, a new document, Registration of Supplier Prices, is entered. To create a new document, use the Supplier prices (price lists) workplace (Purchases section).

Information about the goods supplied by the supplier is entered into the Supplier Nomenclature directory. In this case, the name and article number of the product are registered as entered in the supplier’s information database.

Important!

Information about supplier products can be registered only if the Supplier nomenclature checkbox is selected in the Administration - Items section.

You can enter information about supplier products at the time of registering supplier prices. So let’s open the processing of Supplier prices (price lists) to register supplier prices

In the workplace we will indicate the supplier Base “Products”. The types of prices (retail and wholesale) that were entered when registering an agreement with this supplier will be automatically loaded. We will load the supplier's products and prices from an external file provided to us by the supplier (Load from file).

At the first step of the assistant's work, you need to copy the prices, names and article numbers of goods that are indicated in the external file via the clipboard into the appropriate columns. Using the Select price types command, you can refine the list of loaded supplier price list columns and add new price types (price list columns).

When loading supplier item items, an automatic comparison of new supplier items occurs with those item items that are in the information base.

Automatic comparison occurs according to the following principle:

if the supplier’s item has already been defined as an item registered in the infobase, that is, a comparison has already been made previously, then the matched item position will be automatically filled in;
if no comparison has been made, then the information base will be searched by article and name. If at least one of the fields (article or name) matches completely, the positions will be compared.

Unmatched items will be indicated as skipped upon registration.

New supplier nomenclature items will be automatically created at the next stage of the assistant's work and registered in the Supplier Nomenclature directory for the Product Database supplier.

Newly created supplier nomenclature items must be compared with items in the Nomenclature directory.

You can leave only unmatched items in the list and manually match those items. If necessary, without leaving the assistant, you can create new item items and compare them with supplier items.

At the last stage of the assistant's work, supplier prices will be registered (the document Registration of supplier prices has been created).

It should be noted that supplier prices will be registered only for those items that are compared with item items in the information base.

Supplier prices can also be registered manually. To add a list of supplier positions, use the Generate button.

Using the advanced mode, you can select item items by any parameters, for example, by item group.

When re-downloading a supplier's price list, it is convenient to use the mode for displaying old prices. The mode for displaying old prices is activated by the command Options – Show old prices. In this case, the percentage change in supplier prices will be immediately visible.

To register supplier prices, use the Apply Changed Prices command. The Supplier Price Registration document will be automatically created. You can view the list of previously created documents Registration of supplier prices directly from the Supplier prices (price list) workspace using the Price change history command.

In the Price Change History list, you can not only view existing documents, but also enter a new document, Registration of Supplier Prices.

In one document you can register several types of prices (columns) of the supplier’s price list. To change the list of price types, use the Go to change the composition of price types hyperlink.

Often in practice, a situation arises when the nomenclature directory in 1C becomes “confused.” There are many nomenclature items with almost identical names. For example:

Premium wheat flour

etc. In fact, these can be the same raw materials: Premium wheat flour.

A neglected product reference book interferes with record keeping and data analysis.

Why is this happening? What to do?

To begin with, let’s divide the nomenclature into 2 main groups:

1. group: nomenclature “what we make it from”. This group includes materials, raw materials, packaging, semi-finished products, components, etc. This is the so-called “input group” of the nomenclature. It mainly consists of goods and materials purchased from suppliers, as well as our own semi-finished products.

2. group: nomenclature "what are we doing". This group includes finished products of our production.

Within these two groups you can make many convenient subgroups. For example, separate raw materials, materials and semi-finished products in group 1.

With the second group (our finished products), there are usually fewer problems with entering items than with the first.

Step 1. Let's start by putting things in order in the finished products group.

The enterprise needs to create regulations for entering items into the database: who is responsible for what information and procedure. You can develop a form “Item Approval Card” and regulate the procedure for approving card data and responsibility for entering data into 1C.

Important! A digital article/product code is required. You can develop a system of articles for inclusion in the database. The article may be different from the code, or it may be equal to the code. Basically, programmers ask to separate these two fields: for example, the article is set by the user, and the code is assigned by the program. But in practice we have not encountered any difficulties in working with the program when the code and article are equal. The article and code must be unique.

In 1C ERP, control of the uniqueness of an article is set in the Item Type - Creation Settings. Check the “uniqueness control” box.

Please note that when working with chain stores, you will most likely have to supplement the finished product nomenclature directory in 1C with such a concept as PLU code. This is a product code that is assigned to your products by the chain store itself, so that it is easier to enter our product into the database when it arrives at the store’s warehouse.

Step 2. We enter the item from the supplier into the program.

Attention, accountant! Often, an accountant or other person registering the receipt of goods from a supplier considers it his duty to enter the item under exactly the same name as that of the supplier indicated in the document. If you have received high-grade psh flour from the supplier, then you need to urgently run to create the nomenclature “high-grade psh flour”. The nomenclature “prepare flour” arrived from another supplier; we ran to create the nomenclature “prepare flour”. All! The end of the nomenclature and warehouse reference book with production accounting!

The enterprise must draw up regulations for introducing a new item from the supplier.

This is especially important for the purchase of raw materials. Typically, the incoming quality control department can create a card for the new item. To simplify the situation, on the TORG12 form from the supplier, the person responsible for receiving raw materials must write the name or code/article of our nomenclature for accounting or indicate a new name for the data establishment. Thus, there is a correspondence between the supplier's nomenclature and our nomenclature.

Based on this information, the accountant correctly enters the inventory in the database.

Let's look at an example of how to create a correspondence between our nomenclature and the supplier's nomenclature in the 1C ERP database.

In the menu Master data and administration - Setting up master data and sections - Nomenclature in the additional information section, check the box "list of suppliers".

2. In the Master data and administration menu - Master data - Counterparties in the partners section on the tab "supplier nomenclature" We fill out in the dialog box the correspondence between the supplier’s nomenclature and our nomenclature directory in 1c ERP.

3. When creating the document Receipt of goods and services, an additional field appears for entering the supplier’s nomenclature.

Premium flour from the supplier - nomenclature name in the supplier’s document. Our nomenclature option was chosen: 1st grade wheat flour.

This solves the problem of keeping records of the enterprise's product range and conducting reconciliations with the supplier.

In "1C: Retail 8" there are two main scenarios for synchronizing product data received from EGAIS and nomenclature:

When working with reference data (reference information).
When processing a document, the EGAIS consignment note (incoming).

Preliminary settings for elements of the "Nomenclature" directory

Directory " Types of nomenclature"

In order to account for alcoholic products, it is necessary to create a separate Type of nomenclature.

To do this you need:

Go to section NSI – Nomenclature – Types of nomenclature and press the button Create.
Follow the hyperlink Specify in the form of a directory element Type of nomenclature.
In the window that opens Select item type set radio buttons to value Product And Alcohol (alcohol-containing) products.

Attention! Checkbox Sold by the glass is established only for products sold by the glass, after the packaging has been opened.

Directory " Types of alcoholic and alcohol-containing products"

Directory Types of alcoholic and alcohol-containing products(chapter NSI – EGAIS) contains information in accordance with the classifier from Appendix 4 to the order of the Ministry of Taxes of the Russian Federation dated January 12, 2004 No. BG-3-13/11@ "On introducing additions to the format for submitting tax and accounting reports in electronic form (version 2.00)".

There are two ways to fill out the directory:

Directory "Nomenclature"

In directory elements Nomenclature You should fill in the details:

In the Procedure for a system participant when recording data in EGAIS, published on the FSRAR website (http://egais.ru/files/order.pdf), it is recommended to search for alcoholic products when registering retail sales by reading the EAN barcode scanner.

In order to assign an EAN barcode to a product from its packaging, you must:

The barcode will be automatically recorded in the information register Barcodes. You can go to the created record with the command Barcodes from the directory item form Nomenclature(menu More – Go).

Note. A barcode can be assigned to a directory element Nomenclature at the stage of its creation. To do this you need to go to the directory Nomenclature(section Master data – Nomenclature) and scan the EAN barcode with the scanner. If a directory item is not found, the program will prompt you to create it and automatically assign this barcode.

Loading alcoholic beverages from EGAIS

Information on alcoholic products obtained from EGAIS is stored in the directory (section NSI – EGAIS).

There are three ways to download the directory EGAIS classifier of alcoholic products:

Automatically upon receipt of documents from EGAIS.
According to the TIN of importers and manufacturers.
According to the current warehouse balance using a barcode scanner.

directory "EGAIS Classifier of Alcohol Products" by TIN of importers and manufacturers

To download alcoholic products from EGAIS using the TIN of the importer or manufacturer, you must:

reference book "EGAIS Classifier of Alcohol Products" using a barcode scanner

The excise stamp code, as prescribed by the FSRAR, contains an encrypted AP code. To enter the warehouse balance you must:

In the workplace Comparison of EGAIS nomenclature tools provided:

The need to account for goods and materials received under a name other than that indicated in the supplier's invoice occurs constantly for some companies, while for others it arises only from time to time. Let's figure out when such a renaming may be necessary and how to do it, so that later you do not have to prove to the tax authorities that the printer supplied to you, for example, and the printing device accepted for accounting are one and the same.

In what cases is it necessary to rename inventory items?

Different companies can sell the same product under different names. For example, suit fabric, woolen fabric, combed fabric - all this is the same fabric.

Reader's opinion

“At first we tried to carry the goods from acceptance to sale strictly under the name of the supplier. However, this was soon abandoned, among other reasons, due to customer dissatisfaction. They were not happy with the situation when, under an agreement concluded for the supply of ten woolen hats, during shipment we gave them documents for seven knitted hats and three colored earflaps, despite the fact that these were absolutely identical hats from the same manufacturer, they simply came from different suppliers ".

Elena Krasivtseva,
chief accountant, Samara

You may need to account for purchased inventory items under a name other than that indicated in your shipping documents by your supplier, in particular if:

you purchase the same property from several suppliers, each of which names this product in its own way and all in different ways. If goods arrive from each batch under the name specified by the supplier, you will have to take into account the same thing under a dozen different names. This is not only inconvenient (you need to ensure that each batch is sold or written off for production exactly under the name under which it is registered), but can also lead, for example, to the appearance in the accounting of surpluses and shortages that actually do not exist and related additional tax charges with them th Resolution of the Twentieth AAS dated June 30, 2009 No. A23-3030/08A-14-189; FAS UO dated May 10, 2011 No. Ф09-2429/11-С3, as well as to an incorrect assessment of written-off inventory items, if you write off not according to the cost of each unit, but according to the average cost or according to the FIF method ABOUT clause 73 of the Guidelines for accounting of inventories, approved. By Order of the Ministry of Finance of Russia dated December 28, 2001 No. 119n (hereinafter referred to as the Guidelines);
your buyer insists on a certain name, but it does not match the one indicated in the shipping documents by your supplier. Such demands, in particular, are put forward by state employees, who have the right to spend money strictly on what they are allocated funding for;
you have production, and the accounting of raw materials and components is based on their names and codes given in your technical documentation, and they do not coincide with those indicated by your suppliers;
transactions with goods are subject to a tax benefit and for its safe use, it is important for you to sell it under the name given in the regulatory document establishing the benefit or list of exempt goods;
You are an exporter and when exporting goods you need to indicate in the customs declaration and transportation documents the name given in the Commodity Nomenclature of Foreign Economic Activity, which does not coincide with the name indicated by your supplier in the documents for the goods.

Why can you assign your own name to inventory items?

In the regulations establishing accounting rules, you will not find direct permission to assign a unified name accepted by the company to incoming goods and materials and reflect it in the primary documents accompanying the goods from acceptance to sale or use in production.

However, the organization must conduct accounting rationally O clause 6 PBU 1/2008 “Accounting policy of the organization”, approved. By Order of the Ministry of Finance of Russia dated October 6, 2008 No. 106n. Obviously, accounting for the same thing under different names cannot be called rational (due to an unjustified increase in item items, the need to track the write-off of inventory items exactly under the name under which they are registered, etc.).

In addition, accounting for inventory items should ensure control over their safety and use m clause 3, sub. “c” clause 6 of the Guidelines. A bloated nomenclature list, on the contrary, makes such control difficult.

As you can see, if you begin to assign names to the purchased goods and materials based on your needs, this will not contradict the principles of accounting. The main thing is that these names correspond to reality and allow you to correctly identify goods and materials (obviously, you cannot call a table a chair).

Guidelines for accounting of small enterprises Z paragraph 50 of the Guidelines allow you to change, for the purpose of proper accounting and control, the unit of measurement specified in your supplier’s shipping documents to the one accepted for the inventory data in your accounting. This is formalized by a translation document drawn up in any form A para. 3 clause 50 of the Guidelines. By analogy, the same can be done with the name of the product.

What claims can tax authorities make?

Accountants are primarily afraid of tax claims - that inspectors, after checking the documents, will decide: the company registered and then sold or used in production something other than what it bought. After all, the correspondence of the names used by you and your supplier may not always be obvious to the inspector. Thus, there are doubts that the “steel angle 50 x 50” accepted for registration and indicated in the supplier’s delivery note and invoice “angle. meth stainless steel 50 x 50" is the same thing and is unlikely to arise. But inspectors uninitiated in the technical intricacies probably won’t put an equal sign between “sensor-relay” and “thermostat”.

These fears, as practice shows, are not in vain. If the documents do not clearly show that you registered, sold or wrote off for production exactly what you bought, the tax authorities may add additional charges:

VAT, by deducting input tax on purchased goods and materials due to the fact that you did not take them into account at clause 1 art. 172 Tax Code of the Russian Federation. After all, it will not follow from the documents that you have capitalized exactly what is indicated in the invoice and the supplier’s delivery note;
income tax, removing expenses for inventory items used in production or sold, since according to the documents something else was released or sold e subp. 3 p. 1 art. 268 Tax Code of the Russian Federation. And if the market value of this “something else” is recognized as expenses, then additional income will be accrued in the same amount. After all, you will not have documents confirming the acquisition of goods and materials of this particular name, and there is a risk that inspectors will consider them surplus, identified but not documented during the inventory And clause 20 art. 250, paragraph 2 of Art. 254 Tax Code of the Russian Federation. And finally, tax authorities can remove from tax expenses all costs associated with the acquisition of renamed goods and materials - for transportation, storage, intermediary services (if you purchase goods or materials through an intermediary).

And exporters, due to a discrepancy between the names of goods purchased and then exported abroad, may have difficulties with confirmation zero VAT rate.

However, usually such claims can be repulsed at the stage of considering the audit materials (by filing objections) or by filing an appeal with the Federal Tax Service, although sometimes you have to sue the tax authorities And Resolution of the Federal Antimonopoly Service of North Caucasus of September 2, 2008 No. F08-5142/2008. In some cases, officials themselves are even able to admit that differences in names are not fundamental. s Letter of the Ministry of Finance of Russia dated 04/05/2006 No. 03-03-04/1/320. Judging by arbitration practice, it is mainly exporters who are forced to go to court, who in such situations had to prove their right to deduct and refund VAT in more than one instance. Resolution of the Federal Antimonopoly Service ZSO dated January 23, 2008 No. F04-449/2008(1058-A45-41); FAS NWO dated 02.27.2008 No. A56-1/2007, dated 03.03.2008 No. A56-8615/2005; FAS MO dated 06/07/2007 No. KA-A40/4967-07.

We reduce tax risks

It is necessary to draw up documents so that the renamed inventory items can be clearly identified as the same as those indicated in the documents of your supplier. Your actions will depend on how often you need to change the name of incoming valuables: constantly or only occasionally.

Inventory materials have to be renamed constantly: we draw up a table of correspondence of names

STEP 1. Secure by order of the director that for the purpose of proper accounting and control over the use of inventory items, your organization keeps records of them under the names specified in the internal nomenclature.

STEP 2. Draw up and approve by order of the director:

internal nomenclature of goods and materials;
a table of correspondence of each name given there to all those names that your suppliers use for this position, as well as, separately, to those names that buyers require to be indicated in documents.

STEP 3. When accepting goods, compare the name indicated in the supplier’s documents with the name from the internal nomenclature and, in accordance with the latter, register the inventory items. Many accounting and warehouse programs make it easy to automate this process.

STEP 4. Make sure that the document with which you formalize the acceptance of inventory items (receipt order M-4 for materials or a stamp on the invoice replacing it, an act of acceptance of goods) is linked to the supplier’s invoice. In the M-4 receipt order form there is a column in which the details of the supplier’s invoice are indicated. You can add this information yourself to the free form document on acceptance of goods.

This way you will confirm the registration of purchased goods and materials under a different name m clause 1 art. 9 of the Federal Law of November 21, 1996 No. 129-FZ “On Accounting”; clause 1 art. 252 Tax Code of the Russian Federation; Resolution of the Twentieth AAS dated June 30, 2009 No. A23-3030/08A-14-189. The fact that this can be done using a name correspondence table was directly indicated by the Eighth AA WITH Resolution of the Eighth AAS dated July 15, 2010 No. A46-4842/2009.

When returning goods to the seller, you will have to indicate in the documents the name that appeared on his delivery note and invoice. In this regard, in the accounting program it is better to enter this name as a note in the product card. Then, when returning, you won’t have to “pick up” the paper invoice.

One-time need: we avoid the problem or draw up a “bridging” document

It is best, of course, to avoid the problem altogether: even at the stage of concluding an agreement with the supplier, agree with him on a name suitable for you or your customers, which he will indicate in the shipping documents. Some companies even issue suppliers with a specially designed memo on how to indicate the names of goods in shipping documents.

Reader's opinion

“ Occasionally, buyers ask to sell them a product under a name other than the one under which we purchased it. Then I write in TORG-12 the name they require, and in parentheses I indicate the one under which the product is registered with us, for example, “Semi-linen canvas (Tarpaulin).” Often this compromise suits the buyer.”

Alena Rudnitskaya,
chief accountant, St. Petersburg

Alas, the supplier may not agree. Then make a note on his documents that you are registering the goods and materials under a different name. In some companies, the supplier’s representative is even asked to sign a certificate of identity of names and file it with the invoice. In others, instead of such an act, an accounting certificate is attached to the invoice stating that the goods and materials are accepted for accounting under a different name, or an act of “transfer” from one name to another (compiling it in the same way as when transferring from one unit of measurement to another).

There is no need to register the renaming of a product for sale under a different name as an alleged re-equipment or modification - this is a mistake. After all, you don't actually do anything with the product.

It is more difficult for tax officials to trace the movement of a product that changes its name along the chain from the supplier to the final buyer, and they have suspicions that we are talking about different products X Resolution of the Seventh AAS dated April 14, 2008 No. 07AP-1550/08. Approval of the internal nomenclature and table of correspondence of names allows us to document that these are the same product even at the stage of a tax audit or consideration of its materials by the inspectorate.

1C:ERP 2.1 provides for registration of supplier prices in three ways:

1. Manually, by creating documents Registration of supplier prices (Purchases - Supplier prices (price lists) - History of price changes)

2. Automatic registration of prices based on document data from Receipt of goods and services (if appropriate settings are specified in agreements with the supplier)

Before starting work with price registration, you must make the following system settings:

1. To register several types of supplier prices, for example, wholesale and retail, you need to set this option in the settings Administration - Marketing and planning – Marketing – Several types of prices (Fig.1)

2. To be able to download supplier prices, indicating the names of the supplier's nomenclature, the setting must be selected: Administration – Setting up system parameters – Nomenclature – Additional information – Nomenclature of suppliers (Fig. 2).

You can create a supplier item before loading supplier price lists, or during the loading process.

To create a supplier item manually, you need to open the card of the counterparty who will own this item (Purchasing - Working with suppliers - Suppliers) in the list Go... Supplier nomenclature using the command Create open an input form in which to indicate Name And Compliance with the nomenclature of the directory supplier Nomenclature (Fig. 3). When creating, you can also specify the supplier's article to load the price list by article, in case of changes in the names of the supplier, or errors when typing the name, this will eliminate duplication of item items.

Uploading supplier prices is carried out using the Supplier Prices (price lists) processing. This processing can be opened in the card of the supplier whose prices need to be loaded, or directly in the section Purchasing - Working with suppliers - Supplier prices (price lists).

Let the document with supplier prices look like (Fig. 4).

From the counterparty’s card, you can go to downloading its prices using the command in the group Go... Price list (Fig. 5).

indicated Provider , you need to set the date from which the downloaded prices will be valid and check the price types that will be used when downloading: Select price types (Fig. 7).

In the window that opens Selecting price types (Fig. 8) you need to select those types of prices that will be used further as column headings (see Fig. 7). If the supplier price type has not been created previously, you can add it at this stage (button Add ).

Now, as the information on the form suggests, you need to copy the data range from the Excel file to the clipboard and paste it into the table (Fig. 9). After this, if necessary, you can edit the data directly in the table cells, for example, change prices.

After pressing the button Further a search is made for the correspondence of the entered data with the information base data. The entered item is searched in the Supplier Nomenclature directory. If the Article is entered, then the search is performed by article, otherwise the search is performed by name. In the window that opens, you can see those items of the supplier’s nomenclature for which no match was found in the directory Supplier nomenclature , correspondences can be set manually; in our example there are none (Fig. 10).

If, when loading data from an Excel file into a table, any position of the supplier’s item is detected for which the correspondence is not indicated in the directory Nomenclature , then this table row will be highlighted in font color (Fig. 12).

All such positions can be collected by selecting Show items - Unmatched (Fig.13.)

In column Nomenclature need to be fixed <пропущена при регистрации> - select the desired position in the directory Nomenclature . If it does not exist, then you can create it by calling the Create command

Directly in processing (write the required name, the commands Show all, Create will appear, or place the cursor in the Nomenclature cell and press the F8 key (Fig. 14).

Go to the directory Nomenclature , create the entry you want there, and then go back to select it for matching.

After registering prices in the directory Supplier nomenclature The entry created during loading will appear (Fig. 16).

Prices are recorded. We are in a position Supplier prices (price lists) (see Fig. 6).

Using the command History of price changes (see Fig. 6-2) you can see the list of registered documents Registration of supplier prices (Fig. 17).

The price list is generated using the button Form (see Fig. 6-3). In the window Setting up price list parameters (Fig. 18) it is necessary to set the parameters for selecting items. If the parameters are not set, the entire list of items will be filled in. Using the setting option Advanced type, you can set more complex selection options with grouping of conditions (and, or, maximum, minimum), the ability to select by any nomenclature details, etc. On the bookmark Columns price list, a list of prices that need to be assigned is configured. The selected selection settings are saved for the next work session.

Let's select the data By nomenclature (Fig. 19).

OK – the price list has been generated (Fig. 20).

Prices in the price list can be changed. To do this, you need to take advantage of the direct change in prices in the cells. To save the prices changed in the price list, you need to click on the button Apply changed prices (Fig. 21). When you run this command, a document will be automatically created Registration of supplier prices with a list of registered prices.