Skip to Main Content
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 23

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

Sage 200 Form Launching with Remote Desktop / Azure Virtual Desktop

Add support for the Sage 200 Form Launcher in Remote Desktop and Azure Virtual Desktop environment. According to the following article NOTE: Please Note: As of the 2017 R2 release of Sage 200 CRM, Form Launching on RDS/TS environments are no longe...
Alison Alison 9 months ago in CRM 0 Review Required

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

CRM connector - the ability to allow custom Sage 200 fields to be surfaced via CRM out of the box

CRM connector – the ability to allow custom Sage 200 fields to be surfaced via CRM out of the box, for example, surface Sage 200 analysis fields within CRM
Guest over 8 years ago in CRM 1 Will not implement

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

Integrate Exchange Rate between Sage 200 and Sage CRM

Allcurrencies present in Sage 200 have to be added to Sage CRM or integration will fail, but the exchange rates are not maintained as part of the integrationand therefore need to be updated in two places. I would suggest that on an integrated Sage...
Guest almost 11 years ago in CRM 0 Idea Accepted - Gauging Support

CRM connector quotes and orders. - use form popping to bring up the Sage 200 Quote / Order screen when using Opportunities within CRM

CRM connector – quotes and orders. The ability to use form popping to bring up the Sage 200 Quote / Order screen when using Opportunities within CRM. (i.e. rather than at a Company level). This will allow an association between the quotes and orde...
Guest over 8 years ago in CRM 1 Will not implement

Quote to a Prospect in any Currency

If you use the &Connector& to link to CRM you are restricted to only being able to Quote to a Prospect in GBP... The system should support the standard functionality of setting the currency against the Quote not being restricted to a defau...
Guest about 9 years ago in CRM 1 Will not implement