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 25

    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

    Imports - Update -further improvements to the update of stock records

    Imports - Update -further improvements to the update of stock records as outlined below. Adding / removing suppliers to a stock record Adding / removing locations to a stock record Adding BOM details to a stock record - e.g. can specify that the i...
    Guest over 6 years ago in Stock 0 Idea Accepted - Gauging Support

    Add POST Stock Adjustments Endpoint (including Traceable Items) to Web API

    Allow stock to be added to and written off via the Web API, allowing real-time integration with production systems.
    Feechan, Glen about 2 years ago in Stock 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

    Import bin locations to stock items

    Seems like such a simple thing yet not available. It would be extremely beneficial to us and probably many other Sage users to be able to import bin location to stock items. An example we have over 1000 stock items all with over 100 bin location a...
    Guest over 5 years ago in Stock 0 Idea Accepted - Gauging Support

    Import/Export Search Categories

    One to save some time, if you could export and import Search Categories/values, then this would save a whole heap of time because if you're moving the contents to another database then you can save the details to SQL using a script but you have to...
    Gary Butler almost 7 years ago in Stock 0 Idea Accepted - Gauging Support

    Import Stock adjustments

    I have a large amount of stock transactions to import, Adding to Stock or 'Writing off' as a result of stock taking. We cannot use the Stock taking facility because of it's limitations in not reading a retrospective date for the Stock level, just ...
    Jon Watkin about 6 years ago in Stock 0 Idea Accepted - Gauging Support

    Stock Item Import - Specify BOM Item Type

    When importing new Stock Items in to Sage 200, you cannot specify a BOM Item Type on the CSV file, e.g. BOM, Component, Phantom item or Built/Bought. Therefore, the newly imported Stock Items have to be amended manually once they're in Sage. This ...
    Guest over 9 years ago in Stock 1 Idea Accepted - Gauging Support

    Export Product Groups

    You can import Product Groups, much like stock items, and they can be a complicated structure with all of the Search Categories, Batch/Serial settings and what not, but you cannot Export them. This is useful if you are moving Product Groups to oth...
    Gary Butler almost 7 years ago in Stock 0 Idea Accepted - Gauging Support