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 2 years ago
in Verify Data
0
Idea Accepted - Gauging Support
The Nominal Transaction table must have VAT Code/VAT Period ID fields against each NL Posting
When it comes to reconciling VAT Transactions for a submission period Vs Nominal posted transactions, there is no direct link between the two. It will be useful to have each transaction's VAT Code, VAT Type, VAT Period ID stored in Nominal Transac...
Rustum Khedkar
over 1 year ago
in Database
0
Idea Accepted - Gauging Support
On very rare occasions you may see duplicate URNs posted to the Sales Ledger due to environmental issues (deadlocks etc), this could possibly be prevented by setting a constraint on the SLPostedCustomerTran URN field field in the database to preve...
Tim Critchley
over 1 year ago
in Database
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
almost 7 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 9 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 10 years ago
in Verify Data
0
Idea Accepted - Gauging Support
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
over 6 years ago
in Verify Data
0
Idea Accepted - Gauging Support
We create a number of reports in Sage based on data directly from SQL. We use the DateTimeCreated field in a number of tables to provide KPIs and time triggered reports. DateTimeCreated has always been generated from the Server time that SQL is ru...
Guest
over 8 years ago
in Database
1
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
about 8 years ago
in Verify Data
0
Idea Accepted - Gauging Support
