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

    Power BI - Reporting

    We&re investigating Power BI reports and we&d love to hear your ideas on reports you&d like to see using this tool.
    Jo Kirkup almost 7 years ago in Microsoft Power Apps 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

    Microsoft integration - Microsoft Power Apps

    A tool enabling you ability to build custom business apps, integrating with Sage 200 available within an example in the Winter 2018 release. Would you like to see out of the box apps provided by Sage?
    Jo Kirkup almost 7 years ago in Microsoft Power Apps 0 Idea Accepted - Gauging Support

    Business Intelligence - Stock/Nominal Anaysis

    In Business Intelligence, currently there are no cubes that link between the Stock History & Nominal To be able to analyse Nominal Postings behind Stock transactions/movement i.e. drill into a stock item history (any or all movements) and view...
    Paul Daly about 10 years ago in Microsoft Power Apps 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

    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

    Include Office 365 ProPlus license to allow integration with Power BI/Power Apps/Flow

    There currently is only supported for customers on Business Premium, E1, E3, E5 license types. With Microsoft's increased offerings of 365 subscriptions etc it would be a good idea to include the ProPlus license type. This license type does includ...
    Guest over 6 years ago in Microsoft Power Apps 0 Idea Accepted - Gauging Support

    Consolidated Report Functionality in B.I.

    Hi, Functionality to have the option of running a B.I. report whilst reading from the same cubes in difference companies.Currently each B.I. report is run separately based on connection on a company cube (based on the company the report is run fro...
    Paul Daly almost 10 years ago in Microsoft Power Apps 0 Idea Accepted - Gauging Support