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 19

    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 about 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

    Copy function on create new nominal account

    It would be useful to have a 'copy from option' on 'create new nominal account'. You could then amend the cost centre/department without having to re-type the nominal name and select reporting and SOFA category.
    Guest almost 6 years ago in New/Amend Account 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 over 8 years ago in Database 1 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

    Allow Cost Centre and Department descriptions in the columns list when looking at the nominal ledger

    The nominal ledger and many of the reports would be much more helpful if you were able to display the description of the Cost Centre and Department as well as just the short code. Looking after 3 schools with around 100 departments in each makes i...
    Guest over 8 years ago in New/Amend Account 0 Idea Accepted - Gauging Support

    Add credit card to cash book

    Within Sage 50 you can when setting up a new bank you can tick to show this is a credit account. This is were we processed our company business cards, Sage 200 does not have this
    Guest about 10 years ago in New/Amend Account 0 Idea Accepted - Gauging Support

    Nominal Ledger - Enter New Accounts & Generate New Accounts - Display A/C Balance

    Display A/C Balance should be ticked as default or add a setting tonbsp;choose whether the default is ticked or unticked
    Saeed Malik over 10 years ago in New/Amend Account 0 Idea Accepted - Gauging Support

    Demo Data/Migrated Data - Display Account Balance not ticked on all Nominal Accounts

    Every time a new demo data version we have to run a script to change all the accounts to True. This is also the same for when Sage 50 data is migrated to Sage 200
    Saeed Malik over 10 years ago in New/Amend Account 0 Idea Accepted - Gauging Support