How To Set Up Part Price Matrices
MaxxTraxx has the capability to create several Matrices for your part price calculations and can have differently Matrices assigned to your Online Vendors.
Creating a Parts Matrix:
- Click on 'Parts Mgr' on the tool bar at the top
- Choose 'Part Price Matrix' from the dropdown
- Click the 'Add' button in the lower left hand corner.
- Put in a Description, this is what will show in the drop down list to choose from.
- Level 1 will start with a $0 Starting Part Cost which you will edit first then you can create more levels. The Starting Part Cost will always be $0 so this level will be all part starting a $0 up to the next level you give it.
There are 4 different pricing methods and 6 price code (A – F):
- Sales Price
- Profit Margin
- Fixed $ Markup
- Cost Mult.
You would select one of the pricing methods for each pricing code you are going to use.
Price Codes is the pricing level you give your customers and can be found in their “Customer Record” on the “Details” page.
The pricing methods do not have to be the same for each price code.
Once you’ve finished the first level you would click the 'Add' button again for the next level. You would keep clicking 'Add' until you’re done will all your levels. Levels are the starting price cost.
Example: Level 1 is $0 starting price level 2 is $5.00. That means that any price between one cent and $4.99 selling price will be based on the pricing method you set up on level 1. Level 3 starting price is $25.00 which means that any price from $5.00 to $24.99 will be at level 2 pricing method. Once you have all your levels done, click OK. You can create as many Matrices as you need. Follow the same steps giving it a different description. Once you have the Matrix done, you can apply the Matrix to Part Records. This will only apply the Matrix to the parts that have that Matrix set up.
Setting up a Default Matrix
- You can set one of the Matrices as the default Matrix and automatically have it assign to the new part numbers.
- To do this go to 'Parts Mgr' from the top menu
- Choose 'Part Price Matrix' from the dropdown
- Right click on the Matrix you want as the default Matrix, click 'Set as Default'. Exit this window
- Then go to 'Setups' from the top menu
- choose 'Repair Order and Part Invoice'
- Click the 'Inventory Setup' Blue link on the left
- Under Price Matrix click the “Use Price Matrix For New and Catalog Parts” box and any other applicable boxes and click OK
Applying a Matrix to a Part Number
- Choose 'Parts Search' from the tool bar
- Bring up your Part Number and click edit. This brings up the 'Part Record'
- Click the 'Price' blue link on the left
- Under the pricing list, check the box 'Use Price Matrix'. This will activate the Parts Matrix and you can select your Matrix from the drop down box. Depending on which Pricing Method you have chosen for that Matrix you will need to have a price in the “Base Cost” and the “List Price”.
Applying a Matrix to a Vendor
- Click on 'Vendors' at the top of the tool bar
- Choose 'Accounts Payable Vendor List' and select your Vendor. Click 'Edit'. This brings up the Vendor Record.
- Click the 'Catalog' blue link on the left.
- Click the down arrow by 'Price Matrix' and select your Matrix. (This only works on Vendors you use online through MaxxTraxx) Click OK.
Related Articles
Repair Order and Part Invoices Setup
Repair Order and Part Invoices Setups are a bit lengthy but will help the users to see the various features in MaxxTraxx and help decide what they want to program to do. Have them navigate to the Setup Menu and click on Repair Order and Part ...
Part Restock not showing in Inventory
?️ How to Add a Missing Part to Inventory and Update Related Tables This article outlines the steps to resolve issues when a part in a vendor invoice appears blank or has a zero Parts ID. This typically requires manually adding the part and updating ...
Adding Product Codes to Part numbers or Labor Services
Product codes are a great way to extract greater detail from parts sales, inventory, and labor sales reports. MaxxTraxx has two default groups built in: GI for parts General Inventory, and GL for General Labor. You can add to those groups for ...
How to Find How Many Part Numbers in Inventory Have a Positive Quantity
Open the Report: Go to Reports from the main menu. Select Company Reports. In the left pane, click on Inventory. Select the Report Type: Choose General Inventory Summary. Run the Report: Click Run Report. In the “By Quantity in Stock” section, set ...
How to Set up and Use the "Customer as a Vendor" (Barter) Feature
It sometimes occurs that you purchase parts or service from a business that also uses you to repair his or her vehicles or that purchases parts from you. If both parties agree, the charges for the repairs can act as part of the payment for the ...