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 19

    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

    Populate Supplier Reference with Sales Document Number on back to Back Orders

    When creating back to back purchase orders there is no visibility of the sales order number when viewing the purchase order
    Anita Gilson over 1 year ago in Back to back orders 3 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

    Purchase Order does not balance after changes in linked sales order

    We do a lot of back to back orders. When an amendment is made to a sales order after a linked purchase order has been created - the change occurs on both the sales and purchase order - but the net value of the purchase order does not change. The i...
    Oldschool Oldschool almost 2 years ago in Back to back orders 0 Idea Accepted - Gauging Support

    Ability to amend Back-to-Back Orders

    When a customer reduces the quantity of the product ordered, there is no way to amend the PO. Example, your customer orders three copies of Sage 200 software, you raise a SO, delivery direct from supplier, and 'save and generate' a PO is raised fo...
    Debbie Hunt about 9 years ago in Back to back orders 3 Idea Accepted - Gauging Support

    SO to PO trace - and to invoice numbers

    Ability to be able to easily trace back a SO to PO (and vice versa) when raised as the 1 thing, i.e how to know which PO was raised from a SO direct delivery. And to identify invoice numbers raised on both SO and PO's too
    Guest almost 8 years ago in Back to back orders 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

    Back-to-Back Order Generation to permit Supplier selection

    Sales Order Processing, entered sales items with fulfilment method of Supplier via Stock. When closing the sales order entry using the Save & Generate PO option, and where a sales item has multiple suppliers (i.e. not a single default) then it...
    Guest about 8 years ago in Back to back orders 0 Idea Accepted - Gauging Support

    Allow back to back ordering for service items

    We want to set-up some product codes using the service product group. These service items will form part of a sales order that will include other standard stock items. At the point of despatch, we need the facility within sage to generate a linked...
    Guest over 6 years ago in Back to back orders 0 Idea Accepted - Gauging Support