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 13

    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

    Restore form settings however the form is launched

    When a form is launched from the Sage 200 Desktop, the form's settings (size, column widths etc) are restored from the "FormState" file But if the form isn't launched directly from the desktop, the settings aren't restored. For example, if the Vie...
    Geoff Turner 3 months ago in Tabs/ Open Forms 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

    allow multiple forms open without having to edit size of main program window (2015 and onwards)

    since the open forms has changed to bottom of screen you can no longer have multiple forms open at the same time unless you edit the main program window size (ie not maximised) client has just upgraded from 2011 to 2017 and finds this an inconveni...
    joanne scott about 8 years ago in Tabs/ Open Forms 2 Further Information Required

    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 over 8 years ago in Database 1 Idea Accepted - Gauging Support

    The ability to close a list tab at the bottom of a Sage 200 2015 desktop.

    You can have 5 list tab in Sage 200 v2015. The use would like to be able to close any of the tabs they no longer wish open.
    Guest about 10 years ago in Tabs/ Open Forms 0 Idea Accepted - Gauging Support

    Flag imported items in the SQL Database

    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

    Why can you not close just 1 page in Sage 200

    I have noticed that you can only open 5 different pages on Sage 200, if you open a 6th you loose the first, so to get the 1st back you re open it and then loose the 2nd etc, why can you not just close the 1 that you no longer require, eliminating ...
    Guest over 8 years ago in Tabs/ Open Forms 0 Idea Accepted - Gauging Support

    Improve Open Windows - Users often end up with multiple windows open by the of the day

    Users are ending up with say 20 open windows by the end of day
    Saeed Malik almost 10 years ago in Tabs/ Open Forms 0 Idea Accepted - Gauging Support