Supplier price worksheets (AP202010)

This topic gives you information about the elements that you find in this window in Visma.net ERP, such as fields, field values, buttons, and check boxes.

Introduction

You can use this window to create supplier-specific price worksheets.

  • By using a worksheet, you can make changes to prices in bulk.

  • Prices defined in a worksheet become effective when you release the worksheet; before you release it, you can make edits and save your changes.

  • You can create a worksheet with promotional prices and set an expiration date for the promotion.
    You can use also a worksheet to calculate the pending prices for multiple items by using the price basis you specify.

  • You can populate a worksheet by manually adding new rows, uploading prices from an Excel file, using Visma.net ERP import scenarios, and clicking the Add item and Copy prices buttons.

If you are in the list window, the first line in the table is a search line. Each column has a search field which you can click to search for or filter on specific values and narrow down the displayed table rows. You can search and filter in as many columns as you need to, to only display the results you want to view.

There are two types of search fields:

  • White: here you can type a specific search term to display results in this column containing this exact value. If you search on several (partial) words, you can separate them by a space or % and get different results:

    • space: the result contains the words in any order,

    • %: the result contains the words in the specific order, and the % functions as a wildcard as well.

  • Grey: you can click this to open the column filter pop-up window where you can filter the results for this column.

The window toolbar includes standard and window-specific buttons.

Button Description
Release Makes the prices defined in the worksheet effective.

The release process validates records, ensuring that the following criteria are met:

  • Pending prices should be set for all records.

    If you do not want to update a price, delete the row from the table.

  • Regular prices for the same combination of price type, price code, item ID, unit of measure (UoM), and currency may not overlap in time.
  • Promotional prices for the same combination of price type, price code, item ID, UoM, and currency may not overlap in time.

Promotional and regular prices for the same combination of price type, price code, item ID, unit of measure, and currency may overlap each other in time.

In this part, you can select a price worksheet by its reference number to view its information, or you can create a worksheet.

Element Description

Ref. no.

The reference number of the worksheet in the system; for a new document, the NEW string is displayed, indicating that a new number will be generated when you save the document.

The number series to be used is defined in the Supplier ledger preferences (AP101000) window.

Status

The status of the worksheet, which is one of the following:
  • On hold:
    Indicates that a user can edit the worksheet but cannot release it.
    The Hold check box is selected, and you should clear the check box when you are ready to release the worksheet.
  • Open:
    Indicates that the worksheet is ready to be released and cannot be edited.
    The Hold check box is cleared.
  • Released:
    Indicates that the prices defined in the worksheet have become effective.

Hold

A check box that indicates (if selected) that the worksheet is a draft.

A worksheet with the Hold status may be edited and cannot be released.
Description A brief description of the worksheet.

Effective date

The date when the prices defined in the worksheet become effective.

Promotional

A check box that indicates (if selected) that the prices defined in the worksheet are promotional and an expiration date must be specified.

Expiration date

The date when the promotional prices expire.

This field becomes available if the Promotional check box is selected.

Overwrite overlapping prices

When this check box is selected, the prices whose effective dates overlap with the effective date of the worksheet will be overwritten by the prices defined in the worksheet.

This table displays the prices for items in the selected worksheet.
You can view the existing items, upload the listed items with their pricing information, add items from inventory, or copy the existing list to another currency.
For all the listed items, you can manually define new pending prices for all units used for the item, or you can direct the system to perform calculation of new pending prices.

Button Description
Add item Opens the Add item to worksheet dialog box so that you can load the list of items from the Inventory workspace.
Copy prices Opens the Copy prices dialog box so that you can copy prices from the selection you specify to a new price worksheet for another supplier.
Calculate pending prices Opens the Calculate pending prices dialog box so that you can calculate new pending prices or recalculate (update) pending prices by using the selected price basis.
Column Description

Supplier

The supplier, by its ID, for which you want to review the price.

Item ID

The ID of the item for which price information is listed.
Description The description of the item.

UoM

The unit of measure used for the item.
You can select any of the units defined for this item and set a separate price for it.

Warehouse

The warehouse in which the price is applied for the item.

Break qty.

The quantity to define a lower bound for a quantity tier with a specific price.
This column appears if the Volume pricing functionality is enabled in the Enable/disable functionalities (CS100000) window.

Source price

The currently effective price.
When you add a new record, the value corresponds to the price effective on the date set in the Effective date field of the worksheet. However, when you are adding records by using the Copy prices dialog box, the value depends on the selected source. If there are no prices defined, the base price of the item is displayed.

Pending price

The pending price for the item.
You can set any price here and it becomes effective immediately after you release the worksheet.

Currency

The currency in which this price is specified.

VAT

The VAT whose amount is included in the price.

This dialog box opens when you click the Add item button.
By using the dialog box, which includes the following elements, you can upload the list of items that match the criteria you have selected, with their current price information from the Inventory workspace.
To each added item is assigned the supplier and currency you specify in the dialog box.

Column Description

Item

The ID of the item.

Item class ID

The ID of the class of the items.

Price class ID

The ID of the item price class.

Product manager

The product manager assigned to this item.
Me When this check box is selected, you use only your own products.

Work group

The ID of the product work group.
My When this check box is selected, you use only your own work groups.

Supplier

The supplier for whom the item is used.

Currency

The currency to be used on the item.

Warehouse

The warehouse in which the price is applied for the item.
Button Description
Add

Adds the selected items to the currently selected worksheet.

The dialog box stays open so that you can change selection criteria and add more items.
The Pending price column is blank for all added items.
Add and close

Adds the selected items to the currently selected worksheet and closes the dialog box.

The Pending sales price column is blank for all added items.
Cancel Closes the dialog box without adding items to the worksheet.
Column Description

Item ID

The ID of the item.

Item class ID

The ID of the class of the items.
Description The description of the item.

Price class ID

The ID of the item price class.

Price manager

The price manager responsible for the pricing policy.

Work group

The ID of the product work group.

Item ID

The ID of the item.

Item class description

The description of the item class of the item.
Price class description The description of the price class of the item.

This dialog box opens when you click the Copy prices button.
By using the dialog box, which includes the following elements, you can add records to the currently selected worksheet by copying items that match the selection criteria and assigning the specified supplier and currency to the copied records.
If the source and destination currencies are different, you specify the type and date of the rate to be used for currency conversion.

Element Description

Source supplier

The supplier whose items you want to copy.

Source currency

The currency of the items you want to copy.

Warehouse

The warehouse from which the item prices will be copied.

Effective as of

The date that the effective date of the item prices should match.

Promotional price

When this check box is selected, the items with promotional prices will be copied.

Destination supplier

The supplier to which you want to copy items.

Destination currency

The currency to which you want to copy prices.

If the source and destination currencies are different, you should specify the conversion details in the Currency conversion section.

Warehouse

The warehouse to which the item prices will be copied.

Rate type

The rate type to be used for currency conversion.

Currency effective date

The date when the exchange rate for the destination currency becomes effective.
Button Description
Copy Copies the selected items, adds the copied items to the currently selected worksheet, and closes the dialog box.
The Pending price column is blank for all added items.
Cancel Closes the dialog box without adding items to the worksheet.

This dialog box opens when you click the Calculate pending prices button.
There you can calculate the new pending prices in the worksheet by using the selected price basis.

In this area, you specify an increase or decrease as a percentage of the basis.

Element Description

% of original price

The percentage at which the new pending prices will be calculated by using the selected price basis.
By default, this is 100%, which reflects no change.
If you specified 98%, the new prices would be 98% of the price selected as basis.

Decimal places

The number of places after the decimal point to be shown for prices expressed in the destination currency.

Update with zero price when basis is zero

When this check box is selected, the pending price parameter of the price record will be updated with the zero value if the selected price basis for this record is zero.
Column Description

Last cost

An option that you select to calculate prices based on the items' last costs.

Average/standard cost

An option that you select to calculate prices based on the items' average/standard costs.

MSRP

An option that you select to calculate prices based on the manufacturer's suggested retail price.

Source price

An option that you select to calculate prices based on the values specified in the Source price column.

Pending price

An option that you select to recalculate pending prices based on currently pending prices.
Update (button) Updates all pending prices in the currently selected worksheet with the new values.
Cancel (button) Closes the dialog box without updating prices.

Related concepts

About supplier catalogues

Related tasks

Create a supplier price worksheet

Calculate pending supplier prices for items

Supplier price lists