Verify Data

We've had a few customers whose Quantity on POP order has become out of sync as it thinks there are balances on order that are not. This would normally need investigation, deletion of incorrect records from 2 tables and a manual amendment. It woul...

There are a number of known issues around Quantity Reserved values being left behind, which can be fixed by running the Verify Data routine. The problem with this is that in order to run the routine all users must cease work on the system. On a lo...

A common issue can be that the tables associated with Batch/Serial Items can be in disagreement with the Stock Item Header balances with respect to: 1. Quantity in Stock 2. Quantity Allocated 3. Quantity Available These often have to be manually a...

Would be useful for the Error Details on Verify Data to be able to be drilled down on so can see what fix/changes are being made. Clients find this very confusing as the explanations are very basic and top level - would be useful to be able see ex...

Currently, If an allocation of a Batch/Serial numbered item gets &stuck&, the Balance Ledgers Routine will not fix the problem. The problem can only be fixed manually through SQL by deleting the corresponding TraceableAllocationBalance/All...

For Commercials, you can run the utility on SOP, POP and Stock all in one go. Financials, you have to run individually for Sales, Purchases, Nominal and Cash Book. To enhance and make the process more efficient, to run balance ledgers and be able ...

ONLY MAKE CHANGES TO THE STOCK FILE ALLOCATED QUANTITY WHEN YOU ASK IT TO "FIX" AND NOT WHEN YOU ASK IT TO "VALIDATE-ONLY" AND ALWAYS PRODUCT A REPORT FOR EITHER OPTION. By way of detailed explanation, yesterday I was advised to run Balance Ledger...

1) Have Balance Ledgers always produce a report even if it's to say "No errors". It should also indicate if it was a Validate Only or a Validate and Fix. This is an audit trail and *may* be of use when discussing a problem with the Sage Support Te...