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 21

Sales Ledger Allocation Date

(Same applied to P/L) Could a warning be displayed if the allocation date is before any transaction that is being allocated - when the allocation date is before the transaction date, particularly if the dates span a period end, there are problems ...
Andrew Dunn 4 months ago in Allocate 3 Idea Accepted - Gauging Support

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

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 2 months ago in Allocate / Allocate 2 Further Information Required

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

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

Ability to amend allocation date on corrections

Hi, I cannot amend the allocation date on corrections, this effect the aged reports and creates a problem when reconciling to nominal. I have to do the correction manually to avoid this. Thanks Robert
Robert Burke over 3 years ago in Allocate 1 Already Exists

Sales and purchase allocation on Sage 200 should the same as Sage50

Sales and purchase allocation on Sage 200 should the same as Sage50 instead of credits and debits being in 2 separate boxes,these should be in the same box it makes it easier to find and match off, less time consuming.
Guest over 9 years ago in Allocate 0 Idea Accepted - Gauging Support

In Sage200, can the auto-allocation pick up the VAT element of the settlement and write it off correctly

currently if you auto-allocate a payment, it only allocates the discounted invoice total and the goods discount amount, leaving the VAT element outstanding. Can this be amended as it is very time-consuming to then try to deal with the outstanding ...
Guest over 8 years ago in Allocate 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 almost 9 years ago in Database 1 Idea Accepted - Gauging Support