How To Add Pricing Rules per Business Type
Give every customer of one business type (for example Distribution or Contract) the same cost or resale adjustment, by tagging customers with a business type and pointing a pricing rule at that type.Updated Nov 9 2026
Before you start
- Data Maintenance is under Admin > Maintenance and needs the Admin role plus the Can Edit Maintenance function (Maintenance role by default), or a role that has been given the BUSINS table.
- Customer List is under Sales > Customers.
- Pricing Rules is under Parts > Pricing and needs the Parts role.
-
Add the business types
- Go to Admin > Maintenance > Data Maintenance.
- Click the filter search bar (Filter or search…), choose Data Type, type
BUSINS, and click Apply (1). - On the BUSINS (Business Types) row, click the pencil icon (Edit) at the right end of the row. The table's editor opens with columns Business Type Code and Business Type Description. (This new editor opens only when your site has turned it on; otherwise you get the classic editor with Submit, described in the note at the end.)
- Click Add Record. Cetec saves a blank row straight away (Saved - 1 created, 0 updated, 0 deleted). In the new row, enter the business type code (required; up to 2 characters, usually the same number as the row's Id) and the description, such as Distribution.
- Click Save Changes. You'll see Saved - 0 created, 1 updated, 0 deleted. Repeat for each business type.
-
Assign a business type to each customer
- Go to Sales > Customers > Customer List.
- Find the customer (use Filter or search… and the Customer filter, then Apply (1)) and click its Name. The list starts filtered to Active is Active; remove that chip to find an inactive customer.
- In the customer's left menu, click Edit.
- In Business Type, pick the type. The list shows each type as code - description; N/A clears it.
- Click Update. You'll see "Customer Details Updated".
-
Create the business-type rule
- Go to Parts > Pricing > Pricing Rules.
- Click Create Rule. The Create Pricing Rule window opens.
- Enter a Name and check the Pricing Rule Type (it starts on the first type, for example Contract Pricing; clicking the selected type again clears it).
- In Customer Business Type, pick the business type. Leave -or- Customer empty: the two are either/or, and picking one greys out the other. (All applies the rule to every customer.)
- Optional: tick Exact if you'll limit the rule to one part number and don't want it to match longer part numbers too. Qualifier Custom and Qualifier Value limit the rule by a part field (for example Description).
- Click Create Rule. You'll see "Pricing Rule Created" and the rule appears in the list, with Qualifier: Customer showing Bus. Type <description>.
-
Set the rule's price change
The new rule has no price change yet, so it does nothing until you set one.
- On the Pricing Rules list, find the rule (filter by Name with Filter or search…, then Apply (1)) and click the pencil icon (Edit) at the right end of its row (scroll the table right if you can't see it). The Edit Pricing Rule window opens.
- Optional: in Qualifier: Prcpart, search for and pick a part number. A trailing wildcard is added, so ABC also matches ABC1 and ABC12, unless Exact is ticked. Leave it empty to apply the rule to all parts.
- Enter Resale Rule and/or Cost Rule:
10sets the price to 10.10%sets a 10% margin;10%msets a 10% markup.+10adds 10;-10subtracts 10. A rule can take a price below zero (for example-10on a part with no starting resale).
- Optional: set Run Order (lower runs first), Last Rule? (stop applying rules after this one), Valid Dates and Quantity ranges. Quantity 0 to 0 means any quantity.
- Click Save. You'll see "Pricing Rule updated: <id>".
-
Check the price a customer gets
- Go to Parts > Pricing > Pricing Rules and click Test Rule.
- In Test Pricing Rules, pick a Customer of that business type and a Prcpart (and Revision if needed). In each picker, choose the row that shows the customer name or part description, not the Search for "…" row at the top of the list.
- Click Run Rules. The window shows the resulting Cost and Resale (or "No Rules Found"); click Show Rule Details to see which rules were applied (a table of the rules with their rule_id, prcpart, resale_rule and the resale after each).