Supplier price worksheets (AP202010)
Introduction
- 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 import scenarios, and clicking the Add item and Copy prices buttons.
What to do from this window
The window toolbar
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:
If you do not want to update a price, delete the row from the table.
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. |
The top part
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:
|
| 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. |
The table
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.
The table buttons
| 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. |
The table columns
| 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. |
The Add item to worksheet dialog box
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.
The top part
| 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. |
The table buttons
| 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. |
The table columns
| 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. |
The Copy prices dialog box
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.
The dialog box elements
| 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. |
The dialog box buttons
| 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. |
The Calculate pending prices dialog box
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.
The Price adjustment section
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. |
The Price basis section
| 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. |