• Sage 200 Api Access Clarification

    One of the clients I am working with for my company is switching to Sage 200. They want me to integrate Salesforce with Sage. Does Sage 200 have a api with a REST endpoint that I can make requests against without having to register for the developer program…
  • Matching Transaction Report

    Hi everyone, I'm fairly new to Sage 200 and still trying to discover it's possibilities. I've been wondering if anybody has any idea if there is any report or how to create one that will basicaly generate you a list showing all the Credits and Debits…
  • SQL Help

    Can someone help me with the below code? In the below which I have put in bold it only picks up if there is information in Analysis Code 9, but not if the column is left blank. Is it possible to update the below so it picks up where the Analysis Code…
  • Item Code within SQL

    I have just created a query which brings back sales order information but I am struggling to bring in the Stock Item Code as well - below is the current code I have done but could someone help me to add in item code? SELECT DocumentNo, DocumentDate…
  • Communication error

    Hello, A user has logged onto his PC and this message appears Any idea how to resolve it?
  • Price Change History

    I am trying to work out if there is a part of Sage200 which logs what users are accessing and or changing product pricing on Sage 200 ? Previous Sage 500 had a log of who and when things were accessed and I wondered if Sage 200 also had this?
  • How to get current user programmatically?

    Hi all, I see that Sage 200 have this class: Sage.Accounting.User, but how do I get the current user? Thank you
  • How to remove the selected customized menu folder from menu file "MenuDifferentialFile"?

    Hi all, In my developer environment, I have customization for multiple customers, lets say customer A, B, and C. I create folder in the menu for each customer, and place the customized forms for each company accordingly. When I export the MenuDifferentialFile…
  • How to write off quantity programmatically?

    Hi all, My Stock Item is sold by weight quantity in decimal. this situation often left the balance as less than 1 i.e.: 0.002, 0.003 and so on. This happen to a lot of stock items, so I wanted to write off the Actual Quantity and Free Stock Quantity…
  • Error Sage.Common.ProgrammingByContract.PreconditionException: 'Contract Failure: A referential integrity exception on update has occured. This method should be overriden by the subclass.' when trying to add new financial currency on another compa

    Hi all, Lets say I have 3 companies of the same base currency, Company A, B, and C. When I add new financial currency on Company A, I want to add to Company B and C as well. So I am using the code below, which I refer to this site https://my.sage…
  • Disable option to dispatch an order if customer account is over credit limit

    When an account is over credit limit and you add a sales order it rightly goes on hold. However users are able to change the order status to off hold, then dispatch the order via the sales order list screen. (if the order is opened, click save and dispatch…
  • Sage 200 Product Release – Coming Soon

    We’re delighted to announce that the following releases are on their way: • Sage 200 Professional 2023 R1 • Sage 200 Professional 2023 R1 (SPC) • Sage 200 Standard and Sage for Education 2023 R1 What's New? In these releases, we’ve introduced some…
  • Handling error code of Ex11073Exception kept going in infinite loop

    Hi all, I wanted to bypass this error message with the code below, by referring to https://my.sage.co.uk/Sage200SDKDocs/html/DOC0078_Overview.html#ERRORS . But I only went into infinite loop if I click Yes, and stop the loop is I click No, but my…
  • How to get the transactions of stock item, programmatically?

    Hi All, I have an inactive stock item that have not been use for so long (>2 years) and the known transactions has already been archived. My customer would like to remove it from the system. But we encounter this error as attached. So I attempt to delete…
  • Report Designer

    Hello, I have a question about getting a net value on a nominal transaction report. I have a column for Debit and Credit but the net value is not calculated. Thank you
  • Sage 200c Professional upgrade

    Currently on sage 200c Professional, now been told by the sage partner that this is coming to end of support January 2023, which means we have to upgrade to Sage 200 2022 R2. We are under support contract etc with the sage partner, but they have quoted…
  • How to sort currency on Currencies & Exchange Rates with default currency on top?

    Hi all, I need to sort the order of the currencies & exchange rates but with several important currencies such as EURO, Pound, and USD on top, while the other currencies (in the red circle) should be sorted alphabetically. I have tried "Allow…
  • MPS Read Demand routine is already in progress

    Hi, For some reason our MPS read demand routine failed last night and now we cant run it again as it says its in progress "somewhere", but its not and there is no disconnected logins, so obviously its a flag set somewhere. I have googled around and…
  • How to automatically add customized form to Menu after assign roles?

    Hi all, I am a developer making customized solution for my customer. Usually when I create forms, I will have to assign the roles to the forms, and after that I need to add the forms 1 by 1 to the Menu. If I have 20 new forms, then I will have to do…
  • Integrate Sage 200 with PayPal

    find out how to integrate Sage 200 with PayPal to help ensure you get paid faster:
  • Sage 200 64-bit

    When are we going to get Sage 200 as a 64 bit app? There have been plenty of requests for the Sage BI and Outlook integration to support 64-bit but the truth is, the core product needs to be 64 bit. The latest Microsoft Visual Studio version 2022 is now…
  • sage bank feed login window cannot be displayed

    Hi there, I am trying to set up a bank feed, but I am getting this error message.
  • Sage 200 budget allocation/amendment

    Is there a way of adding budget values within a project? For example, we have a project agreed for £5,000.00 materials, £2,000.00 sub-contractors and £1,000.00 lab analysis = total £8,000.00. When the contractors are on-site they realise they need additional…
  • How to set up Salary & Supplier Payments in Sage 200

    This video overview is a step by step guide to setting up Salary and Supplier payments in Sage 200.
  • Sage 200 & Go Cardless

    Get paid faster! Find out more about the integration of Sage 200 & GoCardless in our new video