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

    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

    Add Nominal Transaction Analysis as a field on the Budget Import

    Please can you consider including the Nominal Transaction Analysis codes as a field on the Budget imports in Sage 200 (we use for Education), as we use this field a lot but currently don't have an option to budget against it in Sage. We can apply ...
    Samuel Peach-Barnes almost 5 years ago in Budgets 0 Idea Accepted - Gauging Support

    ESFA Budget Forecast return outturn (BFRO)

    All Schools have to prepare a Budget Forecast return outturn (BFRO)by 21/5/2020. In order to help with this it would be really useful if you would create a report to support this. There is already a field that should provide an analysis of the dat...
    Guest almost 6 years ago in Budgets 0 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

    Multiple Budgets per Financial Year

    eg To able to haveseparate valuesBudget, Forecast and Re-Forecast for the year. Many customers operate in this way Using Multiple Year Budgets for this is not the best way as you then cannot set Next Years Budget if you are using this for a Forecast
    Saeed Malik almost 11 years ago in Budgets 0 Idea Accepted - Gauging Support

    Nominal Maintenance - Zero Nominal Budgets

    For re-forecasting purposes - Add an option that allows you to clear down the budgets - Current & Future years.At present you have import zerovaluebudgets on every account that has an existing budget either for all accounts, one cost centre, o...
    Saeed Malik about 10 years ago in Budgets 0 Idea Accepted - Gauging Support

    Budget Imports need to overwrite everything

    When you import a budget using the import template, at the moment it will overwrite only values of 0.01p or over. If you leave a value blank or a zero it will leave the previous allocation as it is. The ramification of this is that the whole Nomin...
    Guest over 7 years ago in Budgets 1 Already Exists

    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