Home » Categories » 01. Shop ManagementSE v 6.x and 7.x

Shop Management: How to Lock a Specific Markup Value for Multiple Parts in Inventory

This is a process to lock-in specific markup settings on certain parts in your inventory. This should only be done in cases where you do not want the Markup Matrix to apply to a specific set of inventory parts and wish to set a price on multiple parts in your database all at once. If you only need to effect a few parts we would suggest just manually calculating the price you wish to sell the part for, editing the part in inventory, checking user entered price, and manually typing in the price you want for that part.

  1. Create database backup so any unwanted changes and can undone.
  2. Open Inventory List.
  3. Choose a Vendor, Category, or Manufacturer for the parts that require adjustment. Then click the search magnifying glass.
  4. Once search list populates, click Update
  5. The Inventory Update window will appear. Check, Enable Matrix Markup and Update List Prices, then click OK.
    Note:  
    If the vendor was not selected in the previous screen you can select a specific vendor that supplies the populated list. Otherwise, <ALL> will apply changes to all parts listed within the populated search list.
  6. At the prompt, click Yes.
  7. Open Setup > Standard Table > Price Markup Matrix.
  8. Adjust markup percentages to desired markup change for specific inventoried items. Then click, Apply Matrix to inventory.
  9. Repeat steps 2-4
  10. Check Disable Matrix Markup, then click OK.
    Note:  This will leave the markup price on the items but will change them to user entered price preventing them from being affected by any further change in Price Markup Matrix
  11. Open Setup > Standard Table > Price Markup Matrix, and change percentages back to what they were before the change. Then click, Apply Matrix to inventory.
  12. Next, check prices on inventory items that should have been changed. If items have not been modified after the change back to the previous matrix percentage, then the process was successful.


Note:  This does not apply to any parts added to inventory after this process. Any new parts added to inventory will need to be individually reprocessed.

0 (0)
Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Comments Comments
Related Articles RSS Feed
Shop Mgmt Keyboard Shortcuts SE 6.x
Viewed 13587 times since Tue, May 22, 2012
Late Fee Calculation - Annual Percentage Rate (APR)
Viewed 2220 times since Fri, Sep 2, 2016
Flagging a RO As Comeback
Viewed 7399 times since Wed, Jun 6, 2012
Shop Management Software and Carfax
Viewed 9313 times since Wed, Mar 13, 2013
Florida State Reqs: Estimates & Invoices
Viewed 3883 times since Tue, May 22, 2012
How to Write Off Bad Debt
Viewed 13476 times since Fri, Aug 3, 2012
Shop Management crashes after sending email with Microsoft Outlook
Viewed 331 times since Fri, Jun 8, 2018
Tracking eCRM Coupons in Mgmt SE
Viewed 3599 times since Wed, Jun 6, 2012
User List Name Stores Screen Preferences
Viewed 3476 times since Thu, Jul 30, 2009
SE Recommended Local Backup Instructions
Viewed 5616 times since Wed, Jan 14, 2015