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 16

    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

    Shift + Right click on Sage 200c to be able to login as another Windows User

    In versions 2015 and 2016 it is possible to right click on the Sage 200 icon and choose "Run as different user" & you can then type in a user's windows credentials. This allows you to log into Sage 200 as a different user to who you are logged...
    Guest about 8 years ago in Authentication 2 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

    Sage ID Email Address Length On API Tab

    When assigning a Sage ID to a user within System Administrator the email address for the Sage ID is limited to 50 characters. A valid email address can contain up to 340 characters so it is possible to create a valid Sage ID which will not be acce...
    Alison Alison about 1 year ago in Authentication 0 Idea Accepted - Gauging Support

    Enable 2FA IP Whitelisting for organisations

    As two-factor authentication is now being mandated on Sage products, it would be great to be able to IP whitelist, making it quicker for our staff to log in when they are working on the schools network. So anything from behind school's public/e...
    Stuart Mathis almost 2 years ago in Authentication / Sage ID (Sage Account) 1 Idea Accepted - Gauging Support

    Please supp the client credentials grant type on your API

    More and more customers are wanting coupled integration with Sage 200 / Standard using the API from their e-commerce sites so this is getting to be an urgent requirement for a lot of developers. This then requires a service to written to get order...
    Guest over 2 years ago in Authentication 0 Idea Accepted - Gauging Support

    Force users to login in to Sage using username and password.

    Since removing the function between Sage 200 2011 and 2013 where a user must use their password to login to Sage, this has opened up a massive opportunity for fraud. If a PC is left on and unlocked, anyone who can gain access to that PC is guarant...
    Guest about 8 years ago in Authentication 1 Already Exists

    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

    Password Protect Companies

    To prevent accidental entry of transactions in the wrong company - new V2015 feature of Colour Coded Companies is useful
    Saeed Malik almost 11 years ago in Authentication 0 Idea Accepted - Gauging Support