Skip to Main Content
Sage 200 UKI Ideas Portal

Please note the following Sage 200 Ideas Portal Guidelines apply to the use of this portal.

ADD A NEW IDEA

Clear

Ideas

Showing 18

SQL Triggers

I know it is not allowed to be able to use SQL Triggers on the Sage 200 databases but I believe this should be considered
Andrew Siddles over 1 year ago in Database 2 Will not implement

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

Able to search bank standing orders

We have a long list of automatic bank standing orders and direct debits. It would be useful to be able to put these in order by choice as we can on other screens.
Christine Sellick 11 months ago in Direct Debits and Standing Orders 0 Idea Accepted - Gauging Support

Process standing orders and Direct Debits for specific bank accounts not all bank accounts in the Cash Book

When using the 'Maintain Standing Orders and Direct Debits' Screen you can select the bank account to maintain and amend data prior to posting Using the 'Process Standing Orders and Direct Debits' Screen use can process standing orders for all acc...
Victoria Hanley almost 3 years ago in Direct Debits and Standing Orders 0 Idea Accepted - Gauging Support

Prevent duplication of URNs

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

Standing Order and Direct Debit set-up to allow the Goods and VAT amount split to be amended as in Sage50

Vatable Payments and Receipts do not allow the same functionality as is available in Sage50 to change the values when creating, the goods / vat split is determined by the VAT code and cannot be adjusted - in Sage50 it can, this is causing customer...
Guest over 9 years ago in Direct Debits and Standing Orders 0 Idea Accepted - Gauging Support

Maintain Standing Orders and Direct debits screen to show values/ability to add this as a column!

The information is already there and can use the workspace or the report for it so please have the ability to include this as a column into the list view screen. especially if the user has lots of standing orders and direct debits setup!
Guest almost 8 years ago in Direct Debits and Standing Orders 0 Idea Accepted - Gauging Support

Would like extra information in the Process Standing Orders and Direct Debits screen

When processing standing orders and direct debits, would like an additional screen that comes up which simply lets the user know which direct debits and standing orders are going to be done based on the date entered. They would then be able to con...
Guest almost 10 years ago in Direct Debits and Standing Orders 0 Idea Accepted - Gauging Support

User correct DateTimeCreated in the database!!!

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

Standing Orders / Direct Debits - option to suspend payment

Standing Orders / Direct Debits - option to suspend payment
Guest about 7 years ago in Direct Debits and Standing Orders 0 Idea Accepted - Gauging Support