Show TOC

Tracking Prices and Discounts from Marketing Documents Locate this document in the navigation structure

 

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.

Procedure

To generate the price report or the discount group report from a marketing document:

  1. Open the document from which you want to generate the report.

  2. Right-click the relevant document's row and choose Price Report or Discount Group Report.

  3. 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 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.

End of the note.

Result

The reports display all sources of the price/discount of the document's row.

Note 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.

End of the note.

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

End of the note.

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 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

End of the note.

Price/Discount Change Rules

  • 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.

Country-Specific Fields: China, Japan, Korea

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.