- Home
- Blog
- EDGEBIC How-To
- How to Set a Product Cost in EDGEBIC
To set a product cost in EDGEBIC by User Solutions, open the Product tab, click the edit button on the product's row, enter the new Rollup Cost and Sale Price, and click Save. Both fields sit on the Product Configuration dialog and both feed quoting immediately. Existing quotes keep their original figures. This post covers the single task of changing the numbers. For what every product field does, read how to set up products in EDGEBIC.
Before you start
- The product exists in the catalog. If not, see how to add a new product.
- You know which number you are changing. Rollup Cost is the per-unit cost including materials and labor. Sale Price is the per-unit revenue.
- You have the source figure to hand: the supplier quote, the revised standard cost, or the new price list.
- If the change spans more than about twenty products, plan an import instead of a series of dialogs.
Steps
- Open the Product tab from the main navigation.
- Find the product using the search panel above the grid, or the toolbar's Category filter.
- Note the current values in the Cost and Sale Price columns before editing, so you can confirm the change afterwards.
- Click the edit button in the row's Actions column. The Edit Product dialog opens.
- Enter the new Rollup Cost per unit.
- Enter the new Sale Price per unit if the revenue side is changing too.
- Click Save.
If the price you entered is below the cost, expect the warning "Unit price is less than unit cost. You may be selling at a loss." It is a check, not a block. Confirm the numbers and save if the loss is intentional.
What changes when you save
| Surface | Effect |
|---|---|
| Product grid Cost and Sale Price columns | Updated at once |
| New quote simulations | Use the new figures for cost estimate, total, and margin |
| Existing quotes | Keep their historical cost and price, deliberately |
| Routing steps that carry their own labor cost | Unchanged. Stored step values do not auto-refresh |
| The schedule | Nothing moves. Cost is not a scheduling input |
The important boundary is the second and third rows. A quote is a document you sent a customer, so it holds the figures it was built with. Anything you simulate after the save uses the new values. That split is what keeps historical margin reporting honest.
Cost also does not feed the scheduling engine. Changing a price never moves a job. Cost belongs to quoting and reporting, and the scheduler ignores it entirely, which is why a price revision is one of the safest master-data edits you can make mid-week.
How to check it worked
- Confirm the new figures in the Cost and Sale Price columns of the product grid.
- Build a quote for the product, or re-run the simulation on a draft quote, and expand the cost breakdown. The material and unit figures should reflect the new rollup cost.
- Check the margin percentage on the simulated quote. If it barely moved on a large cost change, the quote is probably an existing one holding historical figures rather than a fresh simulation.
- If the product is routed through a work center whose rate recently changed, review the labor cost stored on those routing steps too. That value is inherited at step creation and does not follow later rate changes.
Common mistakes
Expecting sent quotes to update. They will not, by design. Re-simulate or re-quote if the customer needs the revised number.
Leaving rollup cost blank on a quoted product. A blank cost makes the margin look excellent and is the single easiest way to quote a job at a loss. Keep the number current on anything you quote.
Editing 200 products by hand. A plant-wide revision belongs in an export, a spreadsheet edit, and a re-import with a preview step. The dialog is for the trickle.
Forgetting the labor side. The product's rollup cost is per unit. Work center hourly rates drive the labor component of the rollup, so a rate change can leave stored routing values stale even when the product record is perfect.
Once costs are current, keep the rest of the record in step: how to change a product's lead time covers the field that changes promise dates. More single-task recipes are indexed in the EDGEBIC how-to library, and the EDGEBIC product page shows how quoting and finite capacity scheduling share the same data.
Expert Q&A: Deep Dive
Q: A supplier raised prices across 200 parts. Do we edit each product?
A: No. Route bulk cost revisions through the import module rather than the dialog. Export the current product list to a spreadsheet, revise the cost column, and re-import with a mask that maps it back, which turns a 200-dialog afternoon into one file and one preview. The preview step tells you which rows will be created, updated, or skipped before anything is written, so a mistyped column shows up before it reaches the database. Reserve the dialog for the handful of parts you touch between imports.
Q: We changed a work center's hourly rate and quotes still show the old labor cost. What did we miss?
A: Routing steps can carry their own labor cost per hour, inherited from the work center's rate at the time the step was created. Changing the work center rate afterwards does not reach back and rewrite those stored step values, so existing routings keep quoting at the old rate. The fix is to update the labor cost on the affected routing steps after a rate change, then re-run the quote simulation. It is worth checking any routing built before a rate revision, because the symptom is silent: nothing errors, the numbers are just old.
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
How to Create a Watched-File Integration in EDGEBIC
Create a watched-file integration in EDGEBIC: point it at the file your ERP drops, pick the target entity and import mask, set the debounce, and let a new file trigger the run.
How to Rehearse an Integration With the EDGEBIC Simulator
Use the built-in Simulator to provision demo data, watch real integration runs happen, and prove the mechanism before you point anything at a live ERP. Includes the tear-down rule.
How to Run an Integration Now and Pause All Schedules in EDGEBIC
Force one integration to run with Run Now, cancel a run in progress, disable a single definition, or tick Pause all schedules to stop every automatic sync for the session.
