Show TOC

Price Report Window Locate this document in the navigation structure

 

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   Inventory   Inventory Reports   Price Report  . 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 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.

End of the note.

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

End of the note.

Note Note

This topic documents fields and other elements in this window that either are not self-explanatory or require additional information.

End of the note.
Price Report Fields
Source of Price

The source of the price, which is one of the following:

  • Special Prices for BP

    • The price is taken from the Special Prices for Business Partners window, and in case prices are defined in its sub windows (periods discount and volume discount), they are displayed in separate rows in the report.

    • A link arrow opens the Special Prices for Business Partners window, even when the price is taken from its sub window.

  • Period and Volume Discount

    • The price is taken from the Period and Volume Discounts window, and in case prices are defined in its sub windows (periods discount and volume discount), it is also displayed in separate rows in the report.

    • A link arrow opens the Period and Volume Discounts window, even when the price is taken from its sub windows.

  • Price list name

    • The price is taken from the Price List window (for Inventory UoM), and in case prices are defined for any UoM other than the Inventory UoM, then it is also displayed in separate rows in the report.

    • A link arrow opens either the Price List window or the Price List UoM Prices window, depending upon where the price is defined.
Item No.

The number of the item, as displayed in the relevant source of price.
Item Description

The description of the item, as displayed in the relevant source of price.
BP Code

The business partner code as displayed in the Special Prices for Business Partners window.

Note Note

This column is relevant only for the Special Prices for BP source of price.

End of the note.
Base Price List

The base price list as defined in the relevant source of price.

Note Note

When the source of price is Price List, the base price is taken from the specific item row.

End of the note.
Factor

The factor as defined in the item row in the relevant price list window.

Note Note

This column is relevant only for the Price List source of price.

End of the note.
Primary Currency - Unit Price

The Primary Currency - Unit Price as defined in the relevant source of price.

Note Note

  • For the Special Prices for BP and Period and Volume Discount sources of price, the price is displayed in this column or in the following columns, according to the source price selected in those sources.

  • For the Last Purchase Price and Last Evaluated Price sources of price, the price is always displayed only in primary currency.

End of the note.
Additional Currency 1 - Unit Price

The Additional Currency 1- Unit Price as defined in the relevant source of price.
Additional Currency 2 - Unit Price

The Additional Currency 2 - Unit Price as defined in the relevant source of price.
Discount %

The discount percentage as defined in the item row in the relevant source of price.

Note Note

This column is relevant only for the Special Prices for BP and Period and Volume Discount sources of price.

End of the note.
UoM

The item's unit of measurement for which the price is defined.
Quantity

The quantity as defined in the volume discount window in the relevant source of price.

Note Note

This column is relevant only for the Special Prices for BP and Period and Volume Discount sources of price.

End of the note.
Active

Displays whether the price list is active as defined in the Price Lists window

Note Note

This column is relevant only for the Price List source of price.

End of the note.
Valid From

The date on which the price validity starts, as defined in one of the following:

  • For the Price List source of price, as defined in the Price Lists window

  • For the Special Prices for BP and Period and Volume Discount sources of price, as defined in the Period Discounts window
Valid To

The date on which the price validity ends, as defined in one of the following:

  • For the Price List source of price, as defined in the Price Lists window

  • For the Special Prices for BP and Period and Volume Discount sources of price, as defined in the Period Discounts window
Remarks

When the base price list is inactive and the Apply Activity of Base Price List on: checkbox on the Pricing tab in   Administration   System Initialization   General Settings   Inventory   is selected, prices are taken into the document as zero and a relevant remark is displayed in this column.

More Information

Price Report

Price Report - Selection Criteria Window