Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.
How can I discount or override my list prices when entering a customer’s order?
Let’s say you have a table for Products, another table for Line Items, and a relationship between the two where the product table is the master. Let’s also assume you have a lookup field called List Price which displays the price of the product on the line item.
First you’ll want to add a Numeric – Currency field called Price Override to the Line Items table. This will allow users to enter a different price when adding a line item.
Next, create a Formula – Numeric field called Price with this formula:
If([Price Override]<>0,[Price Override],[List Price])
The Price field will display the List Price if there is no override, otherwise it will display the Price Override.
Some helpful tips:
- Some companies require a manager to enter a price override. To implement that restriction, edit the properties of the Price Override field, check “Restrict access by role”, and set the field access to View for each role that is not authorized to enter overrides.
- You also may want to customize your line item form to set the List Price and Price Override fields to only display when editing or adding a record, and the Price field to only display when viewing a record. This can simplify entering line items for your users, as t1he only price likely to matter once they’ve saved the line item is what the customer will be charged.
Browse by Category
Knowledge Base Categories
- Accounts (29)
- Application (54)
- E-Mail (7)
- Fields (40)
- Forms (19)
- Formulas (19)
- General (65)
- Other Product (7)
- Pages (1)
- Product (4)
- Reports (15)
- Roles (4)
- Search (1)
- Tables (5)
The QuickBase Blog
- How to Win Your Team’s Trust With Better Communication
- Smart Iron – How Caterpillar is Leveraging Data to Maximize Customer Experience
- Solve Complex Problems With Smarter Collaborations
- Team Productivity – Stories of the Week
- How Citizen Development Drives Business Process Efficiency – Webinar Q&A with Micron