Using the Bookings Report to Audit Sales Order Changes

Nov 7 2022

Why Change History Matters on Open Orders

It is common to adjust an open order as a job moves from quote to shipment. Dates move, quantities change, and pricing fields get corrected. The problem is that when a value looks wrong at invoicing time, you need a fast, defensible answer for what happened.

Cetec ERP supports this with the Bookings report, which functions like an edit log for sales orders. It shows what changed, when the change occurred, and which user made the edit, with before-and-after values for key fields.

Where to Find the Bookings Report

In Cetec ERP, navigate to Sales > Orders > Bookings. From there, search by order number and a date range to pull the relevant change history.

What the Report Shows

The Bookings report compares old and new values for common order fields, including ship dates, dock dates, cost centers, part/pricing references, quantities, extended cost, extended resale, and gross margin/profit fields. This makes it useful when you need to confirm whether a change was an intentional update, a correction, or an unexpected edit.

Example: Tracking an Extended Resale Value Change

A typical use case is reconciling pricing changes that show up late in the process. For example, if an order was originally quoted with an extended resale value of $0 and later shows $25,000, the question becomes: when did that change happen, and who made it?

To investigate, enter the order number and choose a start date that covers when the order was created. The results will list the edits in that range. In the legacy example (Order 2108), the report indicates the extended resale value was changed to $25,000 on September 27 at 12:25:28.

How to Choose a Search Date Range

If you know the order creation date, start the range there so you capture the full edit history. If you are troubleshooting a recent discrepancy, start from the most recent date you know the value was correct and narrow the range until you isolate the change event.

Key Takeaways

  • Use the Bookings report when you need a clear history of edits made to an open order.
  • Search by order number and date range to find the exact change event.
  • Review before-and-after values to confirm what changed, who changed it, and when.
  • Use a creation-date start range for full history, or narrow the range to isolate a specific discrepancy.

Conclusion

When pricing, dates, or quantities change on an order, the operational risk is not just the change itself, it is losing clarity on why it happened. The Bookings report in Cetec ERP gives your team a practical audit trail so you can answer customer questions quickly and keep order history transparent.