When matching the TB to the aged debtors, there can sometimes be a discrepancy and then you have to try and find this. For example, the discrepancy is £5000 and sometimes, it can be just one figure and you find that the allocation date was incorre...
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
SAGE 200 Aged Creditors Report to have the description of the Invoices
Our Partner is charging us £2,800 to just get the description added to aged creditors report and have the description field on the main screen of the supplier page, rather than drill down each time. I have never seen an accountancy software packag...
Russell Russell
over 6 years ago
in Aged Creditors / Reports
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
almost 9 years ago
in Database
1
Idea Accepted - Gauging Support
Retrospective Aged Debtors & Aged Creditors Locked to the Closed Nominal Ledger Period
If invoices are entered late, the retrospective aged reports will no longer agree to the balance on the control account as the invoices will go into the next period in the nominal. Need to be able to produce an aged report that agrees to the contr...
Saeed Malik
over 9 years ago
in Aged Creditors
2
Idea Accepted - Gauging Support
Aged Creditors - Retrospective - Reconciliations - Show Payments in the current year which have been allocated to invoices in the future
The report does noes not show Payments in the current year which have been allocated to invoices in the future. A key audit and accounting check is to reconcile control accounts. If payment has been allocated to a future dated invoice, the retrosp...
Saeed Malik
over 9 years ago
in Aged Creditors
0
Idea Accepted - Gauging Support
This will assist support on the product, I needed to on several occasions try to find how data has got into the system when a customer is sure the data was not imported. It would be great if when a item is imported into sage via one of the standar...
Guest
over 10 years ago
in Database
0
Idea Accepted - Gauging Support
