Vendor Price Worksheets

Form ID: (AP202010)

You can use this form to create vendor-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. Also, you can create a worksheet with promotional prices and set an expiration date for the promotion. You can use a worksheet to calculate the pending prices for multiple items by using the price basis you specify. For more information on vendor prices, see Maintaining Vendor Prices.

You can populate a worksheet by manually adding new rows, uploading prices from an Excel file, using MYOB Acumatica import scenarios, and clicking the Add Item and Copy Prices buttons.

Form Toolbar

The form toolbar includes standard buttons and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands can be shown as buttons on the form toolbar, as commands on the More menu, or in both places. These commands are listed in the following table in alphabetical order.


Command	Description
Hold	Changes the status of the worksheet to On Hold. You click this button or command when you want to make changes to the worksheet. This button and command are available if the worksheet has the Open status.
Release	Causes the prices defined in the worksheet to become effective. The release process validates records, ensuring that the following criteria are met: Pending prices are 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, inventory ID, unit of measure (UOM), and currency do not overlap in time. Promotional prices for the same combination of price type, price code, inventory ID, UOM, and currency do not overlap in time. Note: Promotional and regular prices for the same combination of price type, price code, inventory ID, unit of measure, and currency may overlap each other in time. This button and command are available if the worksheet has the Open status.
Remove Hold	Changes the status of the worksheet from On Hold to Open, making it possible to release it. This button and command are available if the worksheet has the On Hold status.

Summary Area

In this area, you can select a price worksheet by its reference number to view its information, or you can enter summary information for a worksheet you are creating.


Element	Description
Reference Nbr.	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 numbering sequence used is defined on the Accounts Payable Preferences (AP101000) form.
Status	The status of the worksheet, which is assigned by the system and can be one of the following: On Hold: You can edit the worksheet but cannot release it. When you are ready to release the worksheet, you should click Remove Hold on the form toolbar (or the equivalent action). Open: The worksheet is ready to be released and cannot be edited. Released: The prices defined in the worksheet have become effective.
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 box becomes available if the Promotional check box is selected.
Overwrite Overlapping Prices	A check box that indicates (if selected) that the prices whose effective dates overlap with the effective date of the worksheet will be overwritten by the prices defined in the worksheet.

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 visibility of records with the Vendor price type may be limited based on the roles assigned to the user account to which you are signed in if the Customer and Vendor Visibility Restriction feature is enabled on the Enable/Disable Features (CS100000) form. With the feature enabled, the Restrict Visibility To box appears on the Financial tab of the Vendors (AP303000) form. The system displays the prices of the vendors for which one of the following is true:

The Restrict Visibility To box is empty for the vendor—that is, the vendor’s visibility is not restricted.
A branch, company, or a company group is specified in the Restrict Visibility To box for the vendor, and your user account is assigned to the role specified in the Access Role box of the Configuration Settings section of one of the following: the Branch Details tab of the Branches (CS102000) form for the selected branch, or the Company Details tab of the Companies (CS101500) form for the selected company or a company within the company group.

Table 1. Table Toolbar
The table toolbar includes standard buttons and buttons that are specific to this table. For the list of standard buttons, see Table Toolbar. The table-specific buttons are listed below.
Button	Description
Add Item	Opens the Add Item to Worksheet dialog box so that you can load the list of inventory items.
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 vendor.
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.

Table 2. Table Columns
Column	Description
Vendor	The vendor, by its ID, for which you want to define the price. The list of vendors available for selection may be limited based on the role or roles assigned to the user account to which you are signed in if the Customer and Vendor Visibility Restriction feature is enabled on the Enable/Disable Features (CS100000) form. In this case, the Restrict Visibility To box appears on the Financial tab of the Vendors (AP303000) form. With the feature enabled, a vendor is available for selection if one of the following is true: The Restrict Visibility To box is empty for the vendor—that is, the vendor’s visibility is not restricted. A branch, company, or a company group is specified in the Restrict Visibility To box for the vendor, and your user account has the role specified in the Access Role box of the Configuration Settings section of one of the following: the Branch Details tab of the Branches (CS102000) form for the selected branch, or the Company Details tab of the Companies (CS101500) form for the selected company or a company within the company group.
Alternate ID	The alternate ID of the stock or non-stock item for which you want to define the price. When you specify an alternate ID in this column, the system searches for the stock or non-stock item by the alternate ID and populates the Inventory ID, Description and UOM of the found item in the row. If the specified alternate ID is not found, the system will create a global alternate ID and assign it to the inventory ID that is specified in the row on release of the price worksheet. This column is hidden by default; it appears if you select the Load Vendor Prices by Alternate ID check box on the Price/Discount Settings tab of the Accounts Payable Preferences (AP101000) form. For more information, see Uploading Prices with Alternate IDs and Creating Alternate IDs from Price Worksheets.
Inventory ID	The ID of the stock or non-stock inventory item for which price information is listed.
Description	The description of the inventory 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 for which the price is defined. If this box is empty, the item price applies to all warehouses. This column appears if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.
Break Qty.	The quantity to define a lower bound for a quantity tier with a specific price. This column appears if the Volume Pricing feature is enabled on the Enable/Disable Features (CS100000) form.
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 box of the worksheet. However, when you are adding records by using the Copy Prices dialog box, the value depends on the selection of a 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. By default the system uses the currency specified for the selected vendor.
Tax	The tax whose amount is included in the price.

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. Each added item is assigned the vendor and currency you specify in the dialog box.


Element	Description
The Selection area of the dialog box includes the following elements.
Inventory	The inventory item or items. Start typing in the box, and the system displays the list of inventory items that contain the string you have typed in their ID or description.
Item Class ID	The ID of the class of inventory items (stock or non-stock) that you want to add to the worksheet. Leave the box blank to add items of all item classes.
Price Class ID	The item price class of the items that you want to add to a worksheet. You can leave the box blank to add items in all item price classes.
Product Manager	A box and the Me check box, which you can use as follows to select the price manager whose items you want to add: Select the Me check box to add the items assigned to you. The box will contain your user name. Clear the Me check box and select another user name to add the items assigned to the user. Leave the boxes blank to add items assigned to all users of the selected price workgroup or all groups.
Product Workgroup	A box and the My check box, which you use as follows to select the price workgroup of the price manager of the items you want to add: Select the My check box to add the items assigned to your price workgroup (or to a selected user in the group). Clear the My check box and select a price workgroup in the unlabeled box to add the items assigned to the price workgroup (or to a particular price manager, if you select one, in the selected group). Leave the box blank and clear the check box to add the items assigned to all price workgroups.
The Price Type to Add section of the dialog box includes the following elements.
Vendor	The vendor for which you want to create a price worksheet. The list of vendors available for selection may be limited based on the role or roles assigned to the user account to which you are signed in if the Customer and Vendor Visibility Restriction feature is enabled on the Enable/Disable Features (CS100000) form. In this case, the Restrict Visibility To box appears on the Financial tab of the Vendors (AP303000) form. With the feature enabled, a vendor is available for selection if one of the following is true: The Restrict Visibility To box is empty for the vendor—that is, the vendor’s visibility is not restricted. A branch, company, or a company group is specified in the Restrict Visibility To box for the vendor, and your user account has the role specified in the Access Role box of the Configuration Settings section of one of the following: the Branch Details tab of the Branches (CS102000) form for the selected branch, or the Company Details tab of the Companies (CS101500) form for the selected company or a company within the company group.
Currency	The currency to be assigned to the prices of newly added items.
Warehouse	The warehouse for which the price is defined. If this box is empty, the added item price will apply to all warehouses. This box appears if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.
The dialog box includes a table with the following columns.
Inventory ID	The identifier of stock or non-stock inventory item.
Item Class ID	The identifier of the class of stock or non-stock inventory items.
Description	The description of stock or non-stock inventory item.
Price Class ID	The identifier of the item price class.
Price Workgroup	The identifier of the price workgroup.
Price Manager	The price manager responsible for the pricing policy.
This dialog box has the following buttons.
Add	Adds the selected items to the currently selected worksheet, and leaves 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 All	Adds all items that match the selected criteria to the 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 & Close	Adds the selected 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.

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 selection criteria and assigning the specified vendor 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
The Source section of the dialog box includes the following elements.
Source Vendor	The vendor whose items you want to copy. The list of vendors available for selection may be limited based on the role or roles assigned to the user account to which you are signed in if the Customer and Vendor Visibility Restriction feature is enabled on the Enable/Disable Features (CS100000) form. In this case, the Restrict Visibility To box appears on the Financial tab of the Vendors (AP303000) form. With the feature enabled, a vendor is available for selection if one of the following is true: The Restrict Visibility To box is empty for the vendor—that is, the vendor’s visibility is not restricted. A branch, company, or a company group is specified in the Restrict Visibility To box for the vendor, and your user account has the role specified in the Access Role box of the Configuration Settings section of one of the following: the Branch Details tab of the Branches (CS102000) form for the selected branch, or the Company Details tab of the Companies (CS101500) form for the selected company or a company within the company group.
Source Currency	The currency of the items you want to copy.
Warehouse	The warehouse whose prices should be copied. If this box is empty, the system will copy only the prices that have no warehouse specified. This box appears if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.
Effective As Of	The date that the effective date of the item prices should match.
Promotional Price	A check box that you select to copy items that have promotional prices.
The Destination section of the dialog box includes the following elements.
Destination Vendor	The vendor to which you want to copy items. The list of vendors available for selection may be limited based on the role or roles assigned to the user account to which you are signed in if the Customer and Vendor Visibility Restriction feature is enabled on the Enable/Disable Features (CS100000) form. In this case, the Restrict Visibility To box appears on the Financial tab of the Vendors (AP303000) form. With the feature enabled, a vendor is available for selection if one of the following is true: The Restrict Visibility To box is empty for the vendor—that is, the vendor’s visibility is not restricted. A branch, company, or a company group is specified in the Restrict Visibility To box for the vendor, and your user account has the role specified in the Access Role box of the Configuration Settings section of one of the following: the Branch Details tab of the Branches (CS102000) form for the selected branch, or the Company Details tab of the Companies (CS101500) form for the selected company or a company within the company group.
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. This box is available if the Customer Price Class option is selected in the Price Type box.
Warehouse	The warehouse to which the copied prices will be assigned. This box appears if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.
The Currency Conversion section of the dialog box includes the following elements.
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.
This dialog box has the following buttons.
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.

Calculate Pending Prices Dialog Box

This dialog box opens when you click the Calculate Pending Prices button. By using the dialog box, which includes the following elements, you can calculate the new pending prices in the worksheet by using the selected price basis.

Table 3. Price Adjustment AreaIn this area, you specify an increase or decrease as a percentage of the basis.
Element	Description
The Price Adjustment section of the dialog box includes the following elements.
% 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 the 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 if Basis Is Zero	The check box the indicates, if selected, that 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 of the dialog box includes the following elements.
Last Cost	An option that you select to calculate prices based on the items' last costs.
Avg./Std. 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.
This dialog box has the following buttons.
Update	Updates all pending prices in the currently selected worksheet with the new values.
Cancel	Closes the dialog box without updating prices.