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 27

set correct allocation date on an allocation only entry SL / PL

When entering an allocation for a payment on account transaction would like the system setting payment rule to apply - i.e. to set the allocation date to the receipt date in case of sales ledger and payment date in terms of Purchase Ledger - most ...
Adrian Evans about 2 months ago in Allocate / Allocate 2 Further Information Required

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

List unallocated credit notes and payments on the purchase ledger

This would be useful to ensure we do not over-pay our suppliers. Also useful for reporting on the effectiveness of ledger clerks in allocating these items.
Dick Dick over 1 year ago in Allocate 1 Already Exists

Show invoice numbers on allocation session drilldown

When looking an allocation within the SL module you can only see the invoice number and the date of the allocation. It would be very helpful if you could also see the invoice date in this view. Thanks
Guest over 3 years ago in Allocate / Allocate 0 Idea Accepted - Gauging Support

Supplier Transactions - ability to update memo field for individual transaction, when allocating

Update Memo field for individual transaction
Val Johnstone over 1 year ago in Allocate 7 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

Allow access to the SQL back end on Sage 200 Online

Sage are blocking this and it makes fixing problems very time consuming. The Azure platform will allow it.
Guest almost 10 years ago in Access To SQL database on Standard 0 Idea Accepted - Gauging Support

Supplier Allocation - include the query field

Currently the query field is not visible in the supplier allocation screen.
Val Johnstone over 1 year ago in Allocate 0 Idea Accepted - Gauging Support

PL AND SL ALLOCATION SESSION DISPLAY

Allocation session screen columns - not the most useful information currently displayed, suggestions include removing URN and showing 2nd Ref
Guest about 4 years ago in Allocate 0 Idea Accepted - Gauging Support