ERP Consultant Blog

Sage 100 ERP: How do I automatically change all vendor item price and cost?

Written by Mike Renner | Mon, Sep 17, 2012

Question:  Mike, we own Sage 100 ERP (formally Sage MAS90), we received a letter from one of our vendors stating that as of October 1, 2012 all items they sell us will increase by 7%.  How can we make changes to our inventory items cost and price by 7% without having to manually change each of this vendor's individual items?

Answer:  There is a utility to do this, it is called the Sage 100 ERP Automatic Cost and Price Change which would do both cost and price for a specific primary vendor.  Go to inventory>utilities>automatic cost and price change.  Set the price and cost adjustment to 7% and select the correct primary vendor.

Written by Mike Renner, Partner WAC Conulting, Owner at Computer Accounting Services

Mike is and expert on Sage 100 ERP with over 25 years in the accounting software industry. Mike is also a Sage Certified Trainer and a recognized leader in the design, implementation and support of ERP systems, including Sage.

Specialties

Sage 100 ERP (formally Sage MAS90/200), Sage 100 Fund Accounting (formally MIP Non Profit Software), Sage Grant Management, Sage Online Fundraising, QuickBooks Enterprise and Point of Sale VAR.