Price search

Enter the search criteria that reflects the sales transaction. All fields limit the search to price list records that contain the defined values.

The date should match the sales transaction. It limits the search to price lists with appropriate validity dates.

The currency both limits the search to price list records in the defined currency and displays a price list in the defined currency, if a currency conversion is authorized for the corresponding price list code.

The sales site and shipment site limit the search to price list records where the sites defined on the product and customer records contain the defined values.

The quantity and product unit limit the search to price list records that contain the defined values. If a price list record has been defined with a different unit to the unit defined on the product record, the unit conversion must be authorized for the corresponding price list code for the price list to be included in the search.

 Price list setup

 Conversion factors

Running the inquiry

Click the Apply action. The Price list block (grid/table) is updated. It contains two lines: one for the unit price; the other for the price appropriate to the defined quantity. The information relating to free of charge products (products and quantities) is also displayed. 

Unit price line:

• Gross price. Defined on the basis of the value found in the first applicable price list record (notion of priority in order to define the processing order of the price list records).
• Net price. Calculated by dividing the net price of the n products (global net price) by the quantity defined in the search criteria (in the header information).

Global price line (for the defined quantity):

• Net price. The global net price is calculated on the basis of the applicable discounts and charges initialized in the Discounts/Charges block.
  The table is initialized based on the applicable price list records. If multiple price list records have the same discount (or charge), the notion of priority linked to the price list code determines which price list record will initialize the field in question. Other setups relating to the initialization of these fields can be defined in the Charges/Discounts tab when the price list record is set up (see Price list setup).
• Miscellaneous. Corresponds to the amounts entered in price list columns which do not have any impact on the calculation of the net price (these are recorded in the invoice footer).
• Total. Corresponds to the total of the sales transaction, including everything that is defined on the line for the defined product.
  Global net price + Miscellaneous.

Price lines block

Click the Price list inquiry action to view the lines from the active price lists that apply to the selected product. The results are displayed in the Price lines block (grid/table).

This table displays for each line selected, information for the record such as the gross price, discount and quantity ranges.

If a quantity has been defined in the selection criteria a formula is applied, as follows, to determine which price list records are to be displayed:

     Quantity x 2 >= minimum quantity defined on the price list for the product
  and
  Quantity / 2 <= maximum quantity defined on the price list for the product

Click the Actions icon on the individual lines to view the details for the price list and the price list record code.

Occasionally a price list may be displayed purely for information when it is not linked in the Supplier table (BPSUPPLIER). This price list is not applied.