Sales Order Audit Report ranges and options

Ranges

The Stage Code range is validated before the report is run to ensure correct balancing. Customer balance changes or updates are only applied if a wide open (0 to 9) stage range is specified. Similarly, customer balance changes for finance company customers or financed customers will only be performed if a wide open Customer range is specified.

Options

Update Order Files?

Select No to review the report before the sales order records are updated.

Select Yes to update the sales order records. After the records are updated, you cannot reverse the changes.

If you select Yes and a requested ship date and promised date is not specified for a line, the requested ship date and promised date from Customer Order Settings on an order are used for the line.

Update Customer File?

Select No to review this report before the customer records are updated. All outstanding orders for each customer are added together, excluding Receive on Account orders, and compared to the customer's Order Balance.

Select Yes to update the customer records. The total from all orders for the customer are used to update the customer's Order Balance. After the records are updated, you must reverse the changes manually.

Print Manual Balance Changes?

When the balances on the customer record are manually changed, the changes are recorded in a system administrator record. If the customer records are out of balance with sales order records, the imbalance may have been caused by manual changes that were made to customer records.

Select Yes to include the manual balance changes on the report.

Update Order Line Costs?

Select Yes to update orders with the latest costs using the rules set up for Sales Order Entry: average for FIFO, otherwise the cost settings specified in SA Administrator Options-Products are used.

If the cost for a line item is a sales cost from a pricing record, cost, then the sales cost is used to recalculate the cost.

Costs are not updated if the cost was overridden for returns that are tied to the original order, for warranty exchanges on correction orders, for direct orders or lines, for non-stocks, for lost business, or for core returns.

Note: This option does not affect how the Sales Entry Invoice Processing Report updates costs.

Print if Cost Change is > This Percent

To include cost changes for order lines that increased by a certain percentage, specify the percentage in this field. This is an example of a message on the report: Cost on Line 1 changed From 12.34 To 14.43.

Update Tendering If Updating Order?

Make corrections appropriate for the issue, then run Sales Order Audit Report in non-update mode to verify your audit. Then, set both option 1, Update Order Files, and option 6, Update Tendering If Updating Order?, to Yes to run the report in update mode. Do not set option 6 to Yes for a stored report without knowing which orders are being updated or what tender amount the order is being updated to.