You can use the price report or the discount group report, generated from the document's row, to view the different prices defined for a specific item and, if required, to replace the current price/discount in the document's row with other prices/discounts displayed in the report.
To generate the price report or the discount group report from a marketing document:
Open the document from which you want to generate the report.
Right-click the relevant document's row and choose Price Report or Discount Group Report.
Some data from the document, such as the business partner and the item, are selected automatically as the selection criteria and the report is generated.
Note
This option is available in all sales and purchase documents and drafts, except in a purchase request and in duplicated documents, before choosing the BP. The report is available even when the document status is closed.
The reports display all sources of the price/discount of the document's row.
Note
When the UoM Group value in the document's row is other than Manual, then the following apply:
If the UoM Code value is the inventory UoM, only inventory UoM prices are displayed in the price report.
If the UoM Code value is a specific UoM other than Manual, both the prices of the specific UoM and the prices of the inventory UoM are displayed in the price report.
When there is a match between the price/discount in the document's row and one of the sources of the price/discount, the matched row is highlighted in blue in the report.
When there is no match between the price/discount in the document's row and one of the sources of the price/discount, a message is displayed and the report is generated with no highlighted row.
Note
When a discount percentage is a combination of more than one discount (for example, average, total) all relevant rows are highlighted in blue in the discount group report.
When the source price of the document's row is Manual, a relevant message is displayed during report generation and no row is highlighted in the report results.
You can choose to replace the current price/discount of the particular document's row by double-clicking any row of the report results. Then, in the document's row, the price/discount is replaced with the chosen price/discount and the price source is changed to Manual.
Note
You cannot replace the price/discount with any of the report's rows in the following cases:
For closed rows, for example, a closed row in a sales order
In added documents that are not editable, for example, an added invoice
When the document's row is linked to a blanket agreement
When choosing a different row in the price report, both price and discount are replaced in the document's row.
When choosing a different row in the discount group report, only the discount is replaced in the document's row.
When choosing a different row in any of the reports, the calculation of all relevant rows is updated (tax, gross price, price after tax, total line, and so on).
When the UoM Code value in the document's row is a specific UoM, rather than an inventory UoM, and in the price report you choose another price that is related to the inventory UoM, the price adjustment is done automatically according to the specific UoM.
It is not possible to choose any row from the report if the UoM Code value of the document's row is empty. First you must specify a UoM code.
When there are no authorizations for price lists or special prices, the prices are masked in the report and you cannot choose those kinds of rows.
The following are exception rules for gross price lists that can be defined in specific localizations:
When you choose a gross price list in the price report, the price is retrieved into the document as Gross Price and the Unit Price is calculated based on the gross price and the VAT.
When you choose one of the special prices sources in the price report, the price is retrieved into the document as Gross Price or Unit Price, depending on the price list in the document's settings.