Can I adjust the MSRP and Default Price for multiple items at the same time?

  • 11 October 2021
  • 4 replies

I am having to adjust prices for vendors periodically, and was wondering if there was a way to do multiple items at one time? 



Best answer by Debbie Baldwin 12 October 2021, 15:42

View original

4 replies

Userlevel 5
Badge +2

There are multiple options for the prices/costs maintenance:

  1. You can use Vendor Prices (AP202000) or Vendor Price Worksheets (AP202010) forms to maintain vendor’s prices (regular, promotional, temporary (with expiration date), price by warehouse, etc.). The Vendor Price Worksheets (AP202010) form even allows you to use simple formulas (like the calculation of vendor’s new prices based on MSRP, Last Cost, etc.)
  2. MSRP and Default Price are mostly about sales prices (not vendors’ prices). For the maintenance of the sales prices the following screens can be used: Sales Prices (AR202000) and Sales Price Worksheets (AR202010). On these screens you can manage sales prices (not Default Price and MSRP). The Sales Price Worksheets (AR202010) form allows to use simple formulas (like the calculation of sales prices based on MSRP, Last Cost+Markup%, etc.)
  3. If you really need to regularly update the Stock Item’s attributes (MSRP and Default Price), you may use the Import by Scenario (SM206036)/ As an example, you can take Import the IN Stock Items import scenario from Sales Demo dataset (it can be optimized by excluding multiple unneeded fields from the update).
Userlevel 1

It would be nice to be able to schedule an update to the MSRP and Default pricing like you can set the effective date for a cost change in the Item record.  It would also be nice to be able to upload a change list, similar to the sales price worksheet to alter the default and MSRP prices on the item record.


Userlevel 5
Badge +2

@JSager76 - these sound like ideas worth adding to the Ideas page for Distribution?



Userlevel 1

Just did - Additional pricing management capabilities - thank you!


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2022  Acumatica, Inc. All rights reserved