Enter/Change Vendor Prices

Manually Add Vendor Price

1.  Navigate to Vendor Prices (AP202000) from the Payables or Purchases Workspace.

2. Add a new row + using the icon on Form Toolbar.
3. Find the Acumatica Vendor ID.

4.  Enter or find the Inventory ID.

5. Update the price UOM, if applicable.  The UOM will default to the Purchase Unit on the item setup.

6. Enter the Vendor Price.

7.  Update the Effective Date and/or Expiration Date, if applicable.
8. SAVE

Manually Edit Vendor Price

1.  Navigate to Vendor Prices (AP202000) from the Payables or Purchases Workspace.

2.  Find the Acumatica Vendor using the VENDOR field in the header or detail column.

3.  Find the Inventory ID using the field in the header or detail column.

4.  Update the price UOM, if applicable.  The UOM will default to the Purchase Unit on the item setup.

5.  Edit the Vendor Price.

6.  Update the Effective Date and/or Expiration Date, if applicable.
7. SAVE

Upload Vendor Prices using Price Worksheet

Use these steps to upload vendor prices from a spreadsheet.

Prepare File

Ensure the following columns are included. Using these headers will simplify field mapping:

•  Vendor – Acumatica Vendor ID
•  Inventory ID – Acumatica Item ID
• UOM – Acumatica Purchase Unit will be used if not mapped in file.
• Warehouse, if multiple warehouses enabled
• Pending Price – new vendor price

 Upload Prices from File

1. Navigate to the Vendor Price Worksheet (AP2020PL) from the Payables workspace.
2. Add new worksheet + using the icon on the Form Toolbar.
3. Enter Effective Date and Description (internal only).  Effective Date can be in the future.  Once Released, the vendor prices will be use on all new purchase orders after that date.
4. Recommend SAVE after header data entered.
5. Select Load Records from File icon on the Table toolbar.

6.  Follow prompts to navigate to the file containing the Vendor prices.
   1. Select Choose File and navigate to the file.

1. 2.  Select Upload in lower corner of dialog box
   3. Select OK to Common Settings popup.
   4. Columns dialog opens.  Spreadsheet columns appear on the left under the Column Name header, Acumatica fields appear on the right under Property Name header.
   5. Map any fields in Property Name column that are not defaulted.

6. 6. Select OK on dialog when all columns are properly mapped.
7. Prices are uploaded into the Vendor Price Worksheet

Source Price column displays current vendor price. Pending Price is the new vendor price.

8.  SAVE
9. Remove Hold
10. Release