- Home
- Blog
- Quoting & Promising
- Finding One Quote in a Long List in EDGEBIC
Three controls narrow the EDGEBIC quote grid: a status filter, a customer selector, and a sales order selector, and a reset clears all three at once. In EDGEBIC by User Solutions they combine rather than replace each other, so the fastest way to find one quote among hundreds is usually two filters at a time. There is a second reason to care about which filter is active: the grid's bulk actions work on the current filter when no rows are checked, so the filter is also the boundary of what those buttons will touch.
The grid is a pipeline, until it is an archive
Early on, the quote list is short enough to read. Then a year passes, and the same grid holds every enquiry the shop ever priced, won or lost. The controls above it are what keep it usable.
| Control | What it does | The question it answers |
|---|---|---|
| Status filter | Narrows to all quotes, drafts only, or converted only | "What is still open?" or "What did we win?" |
| Customer selector | Narrows to one customer | "What is outstanding for this account?" |
| Sales order selector | Narrows to quotes tied to one sales order, itself narrowed by the chosen customer | "Which quote belongs to this order?" |
| Reset | Clears all three | "Show me everything again" |
They stack. Pick a customer and then drafts only, and you have that account's live shortlist. Pick a customer and then converted only, and you have their order history as it came through quoting.
The two identifiers, pointing in opposite directions
Filtering gets you to a handful of rows. Identifying the right one comes down to two fields that are easy to confuse.
The quote number is yours. Leave it blank when creating the quote and EDGEBIC generates one; type your own when the customer needs an external reference. It also names the manufacturing order at conversion, which is what lets a job on the floor be traced back to the enquiry that produced it.
The customer reference is theirs: the purchase order or enquiry number they will quote back at you. It is a required field, and this is exactly why. When a customer replies six weeks later with nothing but their own PO number, the reference is the only identifier you both hold. Filter to the customer, scan the reference column, done. The wider relationship between quotes, customers, and sales orders is in linking a quote to a customer and sales order.
Why the filter is also a blast radius
Here is the part worth internalizing. The grid's bulk actions follow a single rule: with rows checked they act on the checked rows, and with nothing checked they act on the eligible rows in the current filter.
That is deliberate and often exactly what you want. Filter to one customer's drafts, press one button, and the whole shortlist refreshes against today's shop load. The batch path is covered in how to simulate multiple quotes at once.
It becomes a problem only when the active filter is a leftover from a different task. The two habits that prevent it:
- Read the filter before you press a toolbar button. Especially conversion, which is one-way.
- Check the rows when you mean specific rows. Explicit beats implicit whenever the action writes something.
A stray simulation is harmless because simulating writes nothing to the production schedule. A stray conversion is not, because a converted quote cannot be converted again. See how a quote becomes an order for what conversion commits.
Filters only work if the statuses are honest
The status filter is the most useful of the three and the first to become useless, because it depends entirely on discipline elsewhere.
If quotes are created as drafts and never moved, every row reads Draft and the filter separates nothing. The pool of things genuinely still being prepared is indistinguishable from two years of dead enquiries. At that point people stop filtering and start scrolling.
The fix is not a feature, it is a habit: set the status when the state changes. Sent means Submitted, declined means Rejected, past its validity window means expired. Do that and Draft stays the short live list it is meant to be. The statuses and their meanings are in the quote lifecycle, and the reason quotes age at all is in quote expiry dates.
A worked example
A buyer calls about a quote from last month. All they have is their own purchase order number and the name of the part.
Set the customer selector to their account. The grid drops from several hundred rows to fourteen. Leave status on all, because the point of the call is unknown yet: the quote might still be a draft, or it might already be converted and the buyer is chasing the job rather than the price.
Scan the customer reference column, find the purchase order number, and open that row. Its status reads Submitted, the estimated dates and cost are from a simulation run five weeks ago, and the validity window has passed.
That is now a re-simulation job rather than a lookup job, because a five-week-old promise date is a picture of a shop that has moved on. Re-simulate against today's load, check the margin, then answer the buyer with a date you can defend. See re-simulating a quote after a change.
Before moving on, press reset. The next person to touch the grid, or you in twenty minutes, should not inherit a customer filter nobody set on purpose.
The takeaway
Finding one quote among hundreds in EDGEBIC comes down to three combining controls, status, customer, and sales order, plus a reset that clears them, and two identifiers that point in opposite directions: your quote number and the customer's reference. The filter does double duty as the boundary of any bulk action taken with no rows checked, so read it before pressing anything and check rows when you mean specific rows. And remember that the status filter is only as useful as the statuses are honest, which makes setting the status part of the job rather than an afterthought. Walk the whole workflow in the EDGEBIC quoting guide, see the status meanings in the quote lifecycle, see the platform on the EDGEBIC overview, and if you are coming from Resource Manager DB, start with the RMDB to EDGEBIC path.
Expert Q&A: Deep Dive
Q: Our quote grid has hundreds of rows and most are old drafts nobody will ever revive. Filtering still feels like hunting. What are we doing wrong?
A: The filters are working, the data behind them is not. If almost every row reads Draft, the status filter has nothing to separate, because status is only useful when it reflects reality. A quote that went to the customer should read Submitted, one they declined should read Rejected, and one past its validity window should be marked as expired rather than left sitting in the draft pool forever. Spend an hour moving the historical rows to honest statuses and the Draft filter becomes the short, live list it is supposed to be. From then on, set the status as part of sending, and the grid stays a pipeline view rather than an archive you have to search.
Q: I pressed Simulate meaning to refresh one quote and it ran on a dozen. How did that happen?
A: No rows were checked, so the action applied to every eligible quote in the current filter instead. That is the documented behavior for the grid's bulk actions, and it is genuinely useful when you intend it: filter to one customer's drafts, run one action, and the whole shortlist refreshes. It is only a problem when the filter is left over from an earlier task. Two habits prevent it: read the filter before you press anything, and check the specific rows when you mean a specific set. Nothing was damaged in your case, because a simulation writes nothing to the production schedule, but a bulk convert deserves more care since conversion is one-way.
Frequently Asked Questions
Ready to Transform Your Production Scheduling?
User Solutions has been helping manufacturers optimize their production schedules for over 35 years. One-time license, 5-day implementation.

User Solutions Team
Manufacturing Software Experts
User Solutions has been developing production planning and scheduling software for manufacturers since 1991. Our team combines 35+ years of manufacturing software expertise with deep industry knowledge to help factories optimize their operations.
Share this article
Related Articles
Deleting a Quote Scenario You No Longer Need in EDGEBIC
Deleting a scenario removes it and its overrides and nothing else. See what survives, why an applied scenario is safe to delete, and how to keep a quote's scenario list readable.
After Conversion, Edit the Order and Not the Quote in EDGEBIC
Once a quote converts, the manufacturing order is the live record. See why quote edits stop reaching production, and what the quote is still good for afterward.
What Happens to a Quoted Price When the Quantity Changes in EDGEBIC
Doubling the order rarely halves the unit cost. See the exact quantity arithmetic behind an EDGEBIC quote, where setup stops amortizing, and why the date scales differently.
