Skip to Main Content
Sage 200 UKI Ideas Portal
ADD A NEW IDEA

Verify Data

Showing 8

For Verify Data to identify and fix issues with Quantity on POP order

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...
Gary Butler over 1 year ago in Verify Data 0 Idea Accepted - Gauging Support

Verify Data (previously Prove Balance) to have option to run for 1 stock item only

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...
Guest over 5 years ago in Verify Data 1 Will not implement

Prove Ledger Balances (Commercials) to include Serial/Batch Number Items

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...
Guest over 8 years ago in Verify Data 0 Idea Accepted - Gauging Support

Adding Traceable Tables into the Balance Ledgers routine

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...
Guest over 9 years ago in Verify Data 0 Idea Accepted - Gauging Support

Verify Data Error Details

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...
Phil Edmondson about 5 years ago in Verify Data 0 Idea Accepted - Gauging Support

Balance Ledgers - to be able to select all Financials modules in one click!

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 ...
Guest almost 7 years ago in Verify Data 0 Idea Accepted - Gauging Support

Balance ledgers - change the way you "fix" things (when you shouldn't!)

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...
Guest about 9 years ago in Verify Data 0 Idea Accepted - Gauging Support

Balance Ledgers - Stock Items - Fixing and Reporting

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...
Guest about 9 years ago in Verify Data 0 Idea Accepted - Gauging Support