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 17

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

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

Budget Holder Authorisation for Invoices

We would like to enable online authorisation of non-order invoices at budget holder level. This would eliminate the need for physical signatures and speed up our processing.
Guest about 4 years ago in Authorisation 1 Idea Accepted - Gauging Support

Overspend Approvals in Sage for Education

How can it be possible that only a budget holder only can approve overspend and there is absolutely no where in Sage that pushes this on for further approval to say the Finance Director or principal -please please please can this additional layer ...
Guest about 5 years ago in Authorisation 0 Idea Accepted - Gauging Support

Purchase Invoice Authorisation

Please can we have an editable VAT field in the authorisation area of Sage. We are partially exempt so have to use numerous VAT codes and we often have to correct the codes given by the user.
Guest over 3 years ago in Authorisation 0 Idea Accepted - Gauging Support

Invoices not requiring additional approval if NL code is amended

We are currently using Sicon WAP and have invoice approval turned on, however whenever an invoice is Corrected in Sage it automatically puts a U against the invoice in the PL account and re-sends the invoice for approval in Sicon, even though it h...
Guest about 4 years ago in Authorisation 0 Idea Accepted - Gauging Support

VAT only invoices trigger require authorisation tick box to be flagged

Currently only invoices with a value entered in the goods box trigger the requires authorisation box to be ticked, vat only ones are ignored therefore creating chance of user error not ticking this box
joanne scott over 1 year ago in Authorisation 1 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

In Purchase Invoice Authorisation provide facility to specify Suppliers whose invoices require authorisation.

Currently Purchase Invoice Authorisation only allows users to specify the amount over which purchase invoices must be authorised. It would be helpful if there was an option to mark the Supplier Record to indicate all invoices for that supplier req...
Guest about 7 years ago in Authorisation 0 Idea Accepted - Gauging Support