• Sage 200 Product Release - Professional

    We're delighted to announce the release of Sage 200 Professional 2023 R2, which is also available via the Sage Provisioning Portal for Partner Cloud deployments. This release marks a significant milestone in our modernisation journey for Sage 200, building…
  • Report Designer Reverse Criteria

    Afternoon, Can anybody tell me how to reverse the criteria for this report? It is currently showing my works orders by number starting from 1 in the drop down, whereas I would like it to be the opposite and start from largest number first. Thanks…
  • Sage 200 OBDC adding in Delivery Addresses

    Hi, I have the below code but need to add in the the delivery postcode (highlighted yellow below) - how would I add this in, I'm not to sure of the joins? SELECT DocumentNo, DocumentDate, DocumentTypeID, DocumentStatusID, SOPOrderReturnLine.ItemCode…
  • Sage 200 Standard and Sage for Education - 2023 R2 is here!

    We’re delighted to announce that the following releases are now live: Sage 200 Standard 2023 R2 Sage for Education 2023 R2 What's New One of the key highlights of this release is the introduction of the ability to customise existing web screens…
  • how to Import dif file for each user?

    Hi all, My users, lets say user A,B, and C have their own preferences on the menu sorting/arrangement/naming. Whenever customization update installed, the menu arrangement will reset according to Sage 200 default sorting/arrangement/naming. Each user…
  • How to get the users under specific company?

    Hi all, I have the following code where I list all the companies that have the same base currency as the current company. public List<CompanySelection> GetTheCompaniesSameBase() { List<CompanySelection> companies = new List<CompanySelection>();…
  • 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…