• BOM Bug

    Hi Sage 200 Support I have been asking for this since we migrated from Sage 50 to Sage 200. Is this ever going to be fixed? If I am not mistaken this has been like this for years. The last answer was given to my BP: " This is in the list of higher…
  • Sage 200 Report Designer - Join Not Detecting New Column in View

    On our picking list report we've got a join to an SQL view called 'SOPAdditionalChargeView' which is used to display the additional charge line for the order at the top of the picking list. Without going into too much detail I have added a column to this…
  • Sage Provisioning Portal update

    On Sunday 13 February, we're updating the Sage Provisioning Portal. This means the portal won't be available between 07:00 and 09:00. This update doesn't prevent your use or access to Sage 200, however, you won't be able to access the portal at this…
  • Sage 200 UK Trial version. Access to API

    Hello Team, I hope you are doing well. The reason I am writing is access to Sage 200 UK API. I have installed the trial version of Sage 200 UK. The link that I used is here https://www.sage.com/en-gb/products/sage-200/trial/#get-started According…
  • Sage 200 test environment

    Hello Team, Could you clarify, does Sage 200 provide the test environment? If yes, could you clarify a link to download the application?
  • Can restriction on other form restrict function on the other form?

    Hi all, Lets say I have a user that only have access to specific page. As you can see below, this user does not have access to Fast Duty feature. This user have access to Fast Delivery feature. Fast duty is about create, read, update, delete on…
  • Works order Processing - does this give you better profit per order reporting?

    We are looking at implementing works order processing. I was wondering what the advantages of using works order processing are? Does this help with costing? Does this give you better reporting on the profit of each sales order? Thanks
  • Is it possible to integrate data from Sage 200 using access to the Sage database?

    Hello Team, Could you clarify, is it possible to integrate data from Sage 200 using access to the database?
  • Setting up and removing Multi-factor authentication in the Sage Provisioning Portal

    We've developed a quick guide to setting up and removing Multi-factor authentication (MFA) as required. Read more >
  • Can't close a works order NULL value itemdbkey error

    Been puzzling over this for a couple of days now. We have a completed works order that cant be closed due to an error that comes up saying: Cannot update Field (itemDBKey) with a Null value as it is marked as not accepting 'Null' values. I did…
  • Sage 200 SDK - Copy an object and all children

    I have a Bespoke Sage Object i have created. It contains children and its children contain Children. I need to duplicate one of the children and all its children underneath. but keep it in the same parent.. Top Level Object (TLO) TLO - Child 1…
  • Sage UKI Advisory: Sage CRM patches now available for 2020 R2, 2021 R1, 2021 R2 for CVE-2021-44228/ CVE-2021-45046/CVE-2021-45105

    Announcing the UK and Ireland release of Sage CRM Patches for 2020 R2.2, 2021 R1.4, 2021 R2.2 for Apache Log4j CVE-2021-44228/ CVE-2021-45046/CVE-2021-45105 Patches can be accessed using the links below: Sage CRM 2020 R2.2 Sage CRM 2021 R1.4 …
  • Add Pay Now Button to Pro Forma Invoices

    I would like to suggest the ability to add the "Pay now" button to Pro Forma Invoices. Works well with standard invoices but we often send out Pro Formas for credit card payments so being able to add the pay now button to them would be great.
  • Sage 200 Import Supplier Transactions

    Hi Everyone, Wondering if anyone can help please. We are importing supplier invoices into Sage 200, a single invoice will have multiple lines, so that we can see each line description in the nominal account. However in the Supplier account this invoice…
  • Sales Returns - How Do I Make Them Negative On A Report

    Hi I have wrote a report which gives me sales by product, country's, analysis codes etc and is pulling through our w/o cost. However I am really struggling with the logic of how I can turn sales returns into a negative number. Does anyone know…
  • Running a addon in Sage 200 on a scheduled task

    I am not sure if this is possible, but we have an addon on Sage that was written by our consultant that updates mrp recommendations and currently this is something that is run manually every morning. I have been asked if I can make it run via a windows…
  • Sage 200 Standard & Education 2021 R3

    Good afternoon, We are pleased to announce the latest upcoming update to Sage 200 Standard & Education - 2021 R3. This update includes the following... Web screens for Sales Order Processing & Quotations, further enhancing accessibility and flexibility…
  • Error creating new company after upgrade from version 2017 to version 2019

    Hi all, after upgrading from sage 2017 to 2019, I have problem creating new company as in image below. What could be the problem and how to solve it? Thank you.
  • Customize form suddenly got error related to Sage library

    Hi all, I have a customize form that have been working for ages. On recent changes, it got error on customer side, while on my local PC the form is still working. Looking at the error, it is related to Sage library. The only difference from customer server…
  • Problem with Action Recommended box in MRP

    I have one weird error on a PC that I have tried everything I can to fix. If the user goes into Planning and the MRP Recommendations List and tries to Action something, it brings up the Action Recommendations box in the task bar but its completely blank…
  • Workspaces 404 / 403 Error

    Hello, We are having an issue with one of our customers regarding the homepage and workspaces for Sage 200, they are currently on version 10.00.0030 (Due to a lot of bespoke they have, they are due to upgrade around March next year). When you first…
  • Integration with Sage 200

    Hello Team, Could you please help me with the following questions? 1) Is it possible to integrate data from Sage 200 via web API? 2) Does Sage 200 have a cloud version? or it is just an On-Premise version?
  • Accessing custom database from company after login

    Hi all, I want to create a program where all companies in Sage 200 should be able to access and the data provided in this program should be stored in a custom database, not individual company database. I assume for the create database query, I can add…
  • Sage CRM 2021 R2 is now available in UK and Ireland!

    We’re delighted to let you know that the release of Sage CRM 2021 R2 is available with Sage UKI from Friday 27 th August 2021. What's New in Sage CRM 2021 R2? Enhanced screens and lists for new installs Configurable choice of pipeline style …
  • Detect if the current company does not have custom table and specific data

    Hi all, I am having this situation. I have A,B as my existing companies and have my custom table added to their database. Then I have a new company C, and this company does not have my custom table yet so none of my customize form is working on company…