It is common to adjust a BOM while you are building a quote, especially when engineering is iterating and sales needs an accurate roll-up for pricing. The risk is simple: if changes live only in a worksheet, the quote and the permanent BOM can drift, and your team loses track of what was actually quoted versus what was actually engineered.

Cetec ERP supports this workflow with a BOM worksheet tied to the quote or order line. On the Quote/Order Worksheet screen, there are four buttons that control where data is pulled from and where it is pushed to.

Refresh BOM

Refresh BOM pulls data from the permanent BOM into the temporary BOM worksheet. Use this when you want the worksheet to match the current saved BOM before you start making quote-specific edits.

Commit BOM

Commit BOM pushes data from the temporary BOM worksheet back into the permanent BOM. Use this when the worksheet changes should become the saved engineering record, not just a quote-line experiment.

Update

Update saves your edits on the temporary BOM worksheet only. Use this when you want to preserve the current worksheet state while you continue working, without changing the permanent BOM yet.

Transfer to Quote

Transfer to Quote pushes the temporary BOM worksheet data to the quote. Use this when the worksheet reflects what you want priced and quoted, even if you are not ready to commit those changes back to the permanent BOM.

How to Decide Which Button to Use

If you need the worksheet to match engineering before you start, use Refresh BOM. If you are mid-edit and just need to save the worksheet state, use Update. If the quote should reflect the worksheet for pricing, use Transfer to Quote. If the worksheet represents the new baseline BOM for future work, use Commit BOM.

Key Takeaways

• Refresh BOM pulls the permanent BOM into the temporary worksheet.
• Update saves changes to the worksheet only.
• Transfer to Quote pushes worksheet changes onto the quote line for pricing and quoting.
• Commit BOM pushes worksheet changes back into the permanent BOM record.

Conclusion

BOM worksheets are a practical way to manage quote-line BOM edits without losing control of what is temporary versus permanent. When your team uses the four worksheet buttons intentionally, engineering records, quote pricing, and customer expectations stay aligned.