Price analysis in 1s 8.2. Report “Price analysis. Often there is a need to analyze the prices of counterparties in order to adjust their own prices or set the price for a new product
Often there is a need to analyze the prices of counterparties in order to adjust their own prices or set the price for a new product.
Moreover, not only your supplier or buyer, but also a competitor can act as a counterparty.
In this article, we will consider the process and price analysis in the program "1C: Trade Management, ed. 10.3" on the example of researching competitors' prices.
Creating a counterparty and price types
Each company whose prices you want to analyze must be created in the Counterparties directory.
Menu: Directories - Counterparties (buyers and suppliers) - Counterparties
Add a new counterparty and specify its name:
If you plan to interact with a new counterparty - buy goods from him or, conversely, sell - check the appropriate flags "Buyer" or "Supplier". Also fill in other required details.
If you need a counterparty only for price analysis, and you do not plan any interactions with him, then filling in the name will be quite enough.
By the "OK" button, save the counterparty and close it.
In addition to the counterparty itself, you need to create its price types. We want to compare our bulk prices, so for each competitor you need to create a "Wholesale" price type and set prices. Other price types (eg wholesale/retail/distributor) would also need separate price types for each competitor.
Let's open the directory "Types of prices of the nomenclature of counterparties".
Menu: Directories - Nomenclature - Price types of counterparty nomenclature
Create a new counterparty price type and fill in:
- Counterparty - Competitor.
- Name - Wholesale prices.
- Item price type - the price type of our organization with which we want to compare the counterparty price. In this case, this is the wholesale price.
- Currency - in which prices will be set. You can choose any currency, since when comparing prices, all of them are converted into the same currency selected in the report.
- Prices include VAT - a sign that VAT is included in the price.
Click the "OK" button to save and close the price type
Important: be sure to specify the price type of the item, otherwise the program will not understand howat the priceour organization, we plan to compare competitor prices.
Setting competitor prices in 1C
To set the prices of counterparties for goods, use the document "Setting the prices of the counterparty's nomenclature".
Menu: Documents - Pricing - Setting prices for counterparty items
Let's create new document, fill in the counterparty "Competitor".
After specifying the counterparty, you can fill in the types of prices to be set. To do this, click on the selection button in the "Price type" field, in the selection window that opens, set the flag for the wholesale price and click "OK".
An example of a completed document:
Analysis of competitors' prices in 1C
To analyze competitors' prices, use the "Price Analysis" report.
Menu: Reports - Pricing - Price Analysis
In the report, it is better to set the selection by the type of prices that you want to analyze, otherwise the program will display all the information at once.
To set the selection, click on the "Settings" button, go to the "Selection" tab and select the price type - "Wholesale" (you can also use the quick selections on the form).
On the report form, also set the currency in which you want to analyze prices.
An example of a generated report:
The report on the left displays all products that have wholesale prices. Below are the prices of our company and the date of their installation (16.01.12).
After own prices, the program displays in turn information about all the competitors' set prices. The price of the counterparty and its deviation from our price as a percentage are indicated. If the deviation is positive, then the price of the competitor is higher than the price of the company. Conversely, if the deviation percentage is negative, then the competitor's price is lower than yours.
Thus, you can enter the prices of several of your competitors in the program. After that, you can analyze prices and adjust your pricing if necessary.
More about the possibilities and tasks that the module solves
Price analysis in 1C and selection of the most optimal supplier
Processing automatically analyzes the prices of suppliers in 1C and for each product determines the best supplier according to the specified evaluation criteria - at the lowest price, at the lowest price, taking into account delivery times, the availability of goods in the supplier's warehouse, etc. Any number of selected suppliers and items of the nomenclature can participate in the analysis (the entire directory, only certain items of the nomenclature, selected by sales, availability, customer orders, etc.). According to the results of the analysis, each position of the nomenclature is assigned the most optimal supplier A that can be used in the Purchasing Assistant.
You can analyze all or only selected suppliersFormation of the price list of the company at the prices of suppliers
Processing determines the best supplier, and also reveals the deviation of the company's purchase price from the prices of suppliers' price lists. Based on the deviations received, you can use one button to adjust the purchase price according to your price list and recalculate the sale prices derived from it. This allows you to quickly respond to changes in supplier prices and bring your prices in line.
And when using the module, the actualization of purchase prices and your price list can be performed automatically. Imagine that any price lists of suppliers are uploaded to the database on a schedule, the company's prices are updated and promptly updated in the online store.
The report is intended for comparative analysis prices for goods from various counterparties, including the company's own prices.
The report is generated in the form of a cross-table, the row headings of which are item positions (goods), and the column headings are counterparties. The report is built for a certain date at the prices that are recorded in the information registers "Nomenclature prices" and "Counterparty prices".
To generate a report, you can specify those types of prices in the reference book "Price types of the item", for which the prices of the enterprise were registered. In this case, for comparison, those types of prices of counterparties are displayed for which the selected type of prices of the product is indicated in the reference book "Types of prices of the counterparties' nomenclature".
If the price type is not specified in the report settings, then the analysis will be carried out at all prices registered at the enterprise and for counterparties.
To compare prices, all prices are recalculated in relation to the base unit of measure of the item and to the currency selected in the report settings.
Using this report, you can analyze the deviations of counterparty prices from company prices. To analyze deviations, it is necessary to set the flag in the "Deviation from the company's price in %" indicator.
For groups of counterparties and items, the average price values for counterparties and item groups are displayed, as well as the average values of percentage deviations.
By setting the grouping by the price registration date, you can see the date when the current price for this product was registered.
Often there is a need to analyze the prices of counterparties in order to adjust their own prices or set the price for a new product.
Moreover, not only your supplier or buyer, but also a competitor can act as a counterparty.
In this article, we will consider the process of installing and analyzing prices in the program "1C: Trade Management, ed. 10.3" on the example of researching competitors' prices.
Creating a counterparty and price types
Each company whose prices you want to analyze must be created in the Counterparties directory.Menu: Directories - Counterparties (buyers and suppliers) - Counterparties
Add a new counterparty and specify its name:
If you plan to interact with a new counterparty - buy goods from him or, conversely, sell - check the appropriate flags "Buyer" or "Supplier". Also fill in other required details.
If you need a counterparty only for price analysis, and you do not plan any interactions with him, then filling in the name will be quite enough.
By the "OK" button, save the counterparty and close it.
In addition to the counterparty itself, you need to create its price types. We want to compare our wholesale prices, so for each competitor we need to create a "Wholesale" price type and set prices. Other price types (eg wholesale/retail/distributor) would also need separate price types for each competitor.
Let's open the directory "Types of prices of the nomenclature of counterparties".
Menu: Directories - Nomenclature - Price types of counterparty nomenclature
Create a new counterparty price type and fill in:
- Counterparty - Competitor.
- Name - Wholesale prices.
- Item price type - the price type of our organization with which we want to compare the counterparty price. In this case, this is the wholesale price.
- Currency - the currency in which prices will be set. You can choose any currency, since when comparing prices, all of them are converted into the same currency selected in the report.
- Prices include VAT - a sign that VAT is included in the price.
Click the "OK" button to save and close the price type
Important: be sure to specify the price type of the item, otherwise the program will not understand howat the priceour organization, we plan to compare competitor prices.
Setting competitor prices in 1C
To set the prices of counterparties for goods, use the document "Setting the prices of the counterparty's nomenclature".Menu: Documents - Pricing - Setting prices for counterparty items
Let's create a new document, fill in the counterparty "Competitor".
After specifying the counterparty, you can fill in the types of prices to be set. To do this, click on the selection button in the "Price type" field, in the selection window that opens, set the flag for the wholesale price and click "OK".
An example of a completed document:
Analysis of competitors' prices in 1C
To analyze competitors' prices, use the "Price Analysis" report.Menu: Reports - Pricing - Price Analysis
In the report, it is better to set the selection by the type of prices that you want to analyze, otherwise the program will display all the information at once.
To set the selection, click on the "Settings" button, go to the "Selection" tab and select the price type - "Wholesale" (you can also use the quick selections on the form).
On the report form, also set the currency in which you want to analyze prices.
An example of a generated report:
The report on the left displays all products that have wholesale prices. Below are the prices of our company and the date of their installation (16.01.12).
After own prices, the program displays in turn information about all the competitors' set prices. The price of the counterparty and its deviation from our price as a percentage are indicated. If the deviation is positive, then the price of the competitor is higher than the price of the company. Conversely, if the deviation percentage is negative, then the competitor's price is lower than yours.
Thus, you can enter the prices of several of your competitors in the program. After that, you can analyze prices and adjust your pricing policy if necessary.