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

    SSA - Update All Companies In Name sequence

    A small thing but sites usually have test databases etc. added to the end of the company list by prefixing the name e.g. xxx My Test or zzz Support Test When updating all companies the process updates databases in reverse name order It would be be...
    Andrew Dunn 3 months ago in Companies 0 Idea Accepted - Gauging Support

    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

    Multiple databases - colour coded

    As we have multiple databases, one per school, it would be helpful if the background or tool bars could be differently coloured for each school to help easily identify which database is being used and prevent posting transactions in the wrong data...
    Guest over 6 years ago in Companies 2 Idea Accepted - Gauging Support

    Disable bespoke option at company level

    We are often asked to test a customer's data using a vanilla system - due to some database sizes, it is often not practical do this "off site" Would it be feasible to have a company level setting (in SSA) to tell Sage not to run any bespoke agains...
    Andrew Dunn 5 months ago in Companies 0 Idea Accepted - Gauging Support

    Add the database version to the Companies list in Sage 200 System Admin tool

    Can we add the database version to the Companies list in Sage 200 System Admin tool? If we are updating a lot of databases but cannot do them all in one go, being able to see the current database version would be very helpful.
    Guest over 4 years ago in Companies 0 Idea Accepted - Gauging Support

    The ability to change the name of your company in Sage 200 Standard ( change Database name )

    Sage 200 Standard and “unable to delete a database or restore into a different database name” if you only have a one-company licence. The need to change a Company Name can happen for the following reasons:- a) Someone got it wrong when the company...
    Guest over 5 years ago in Companies 0 Idea Accepted - Gauging Support

    Add Update Company to tblAudit (When an user runs Update Company)

    We have problems when someone has updated a test company from a live backup It's difficult to trace when this has happened or who did it - it would be of great help if tblAudit included entries for Company Updated There are audit event types 15,16...
    Andrew Dunn 6 months ago in Companies 3 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

    SSA - Confirm before Update All Companies

    I have found myself on multiple occasions, meaning to select Add New Company but accidentally selecting Update All Companies ... and of it goes for ages unless I end task A confirmation prompt before the Update All Companies process starts would b...
    Andrew Dunn 8 months ago in Companies 0 Idea Accepted - Gauging Support