The Price Report window displays all prices, their sources and details, based on the defined selection criteria.
To open this window, from the SAP Business One Main Menu, choose
. In the Price Report - Selection Criteria window, specify the selection criteria, and choose OK.To generate the price report directly from a marketing document, right-click the document's row and choose Price Report. The report is generated using all price sources and other data from the document as the selection criteria of the report.
Note
All prices from Price Lists, Special Prices for Business Partner, and Period and Volume Discounts windows (including their sub windows), are displayed in the report based on the selected criteria and regardless of the definition in the Remove Unpriced Items from Price List in Database checkbox in the General Settings window. For more information, see General Settings: Pricing Tab.
Note
When All is selected in the Source of Price field, in the Price Report - Selection Criteria window, there might be defined selection criteria that are not relevant for specific price sources. In those cases, the irrelevant selection criteria are ignored for the specific price source.
Note
This topic documents fields and other elements in this window that either are not self-explanatory or require additional information.
The source of the price, which is one of the following:
|
The number of the item, as displayed in the relevant source of price. |
The description of the item, as displayed in the relevant source of price. |
The business partner code as displayed in the Special Prices for Business Partners window. Note This column is relevant only for the Special Prices for BP source of price. End of the note. |
The base price list as defined in the relevant source of price. Note When the source of price is Price List, the base price is taken from the specific item row. End of the note. |
The factor as defined in the item row in the relevant price list window. Note This column is relevant only for the Price List source of price. End of the note. |
The Primary Currency - Unit Price as defined in the relevant source of price. Note
End of the note. |
The Additional Currency 1- Unit Price as defined in the relevant source of price. |
The Additional Currency 2 - Unit Price as defined in the relevant source of price. |
The discount percentage as defined in the item row in the relevant source of price. Note This column is relevant only for the Special Prices for BP and Period and Volume Discount sources of price. End of the note. |
The item's unit of measurement for which the price is defined. |
The quantity as defined in the volume discount window in the relevant source of price. Note This column is relevant only for the Special Prices for BP and Period and Volume Discount sources of price. End of the note. |
Displays whether the price list is active as defined in the Price Lists window Note This column is relevant only for the Price List source of price. End of the note. |
The date on which the price validity starts, as defined in one of the following:
|
The date on which the price validity ends, as defined in one of the following:
|
When the base price list is inactive and the Apply Activity of Base Price List on: checkbox on the Pricing tab in is selected, prices are taken into the document as zero and a relevant remark is displayed in this column. |