Find this screen
Open: Period End Routines > Verify Data > Commercials.
How to
Check data only
Use this to check for errors on your sales orders, purchase orders and stock item transactions. This checks that the total of your order lines matches the total order values, and that your stock item balances match the quantities on order and in your warehouses. Any error displays on an additional screen.
- Choose Validate and report anomalies.
- Choose the data to check
- Click OK.
Check data and correct errors
Use this to check and update transactions where there are errors.
- Choose Validate, report and correct anomalies.
- Choose the data to check
- Click OK.
Useful info
Before you start
- Make sure you've backed up your data.
-
Make sure all other users are logged off.
A list of all logged users is displayed when you start.
Why do I get errors in my data?
Unfortunately, there's no simple or single answer to this. Data errors are most often caused when your application closes unexpectedly (crashes) due to a network or other PC error, when you're in the middle of posting transactions.
It's good practice to check for these errors on a regular basis. The Verify data options check and correct your data when possible.
About verifying sales orders
This checks the following for each order:
- Order line total equals the order quantity multiplied by the unit price.
- Quantity despatched equals the total of linked despatch notes.
- Quantity allocated equals the total of linked allocations.
- Order line quantity equals the total allocated plus the total despatched.
- Total goods value equals the total value of order lines.
About verifying purchase orders
This checks the following for each order:
- Order line total equals the order quantity multiplied by the unit price.
- Quantity invoiced equals the invoices linked to order.
- Quantity received equals the GRNs linked to order.
- Total goods value equals the total values of order lines
About verifying stock transactions
This check the following for each stock item:
- Quantity allocated equals total allocated to sales orders and stock.
- Quantity on order equals total on purchase orders.
- Quantity in stock equals total quantity in each warehouse / bin.
- Free stock equals the quantity in stock minus the quantity allocated.
Fix it
Some of the errors can't be fixed
There may be occasions when an error can't be fixed. These will displayed in the Error Log. In these circumstances, please contact our support team for further assistance.
What happens when
I choose to correct anomalies?
- When discrepancies are found, the quantities are updated.
- Additional transactions are not created.
- All errors that have been fixed are displayed on the Error Log.