Browse By Tags

  • How to have a custom stock list with the same right click functions as standard list?

    Hi all, I wanted to add a bespoke columns from completely different tables to this Stock list. I think the fastest way to do it is to have a custom stock list. However, my customer also need the same right click function that able to have options as…
  • Sage 200 Developer Community

    If you're a Sage Developer, there's a separate forum for all things related to Sage 200 Web Amendability, the API and SDK. Developer Community >
  • Revalue Foreign Supplier Accounts screen: how to print the report with temporary value?

    Hi all, on customization on the Revalue foreign supplier account screen, where the Period Exchange Rate field is enabled. When user click OK button, I need the report generated to use the value from the edited Period Exchange Rate field. I have…
  • How do I trace Transaction Listings in Sage 200C On-premise

    We have Sage 200c On-premise. The schema comprises of a Cube, Warehouse and Finally Sage Database. How do I know how data is being surfaced? Example: How do I trace data from Opening Balance, Transaction Listings (movements) through to Closing balance…
  • Need explanation how POPStandardItemLine works

    Hi all, I am looping the POPStandardItemLine or an Order using foreach loop. The item lines in the order consists of standard order line and a charge line. While looping, I encounter an error. this is because 1 item in the POPStandardItemLine is…
  • Communication Error: There was no endpoint listening

    A customer is getting this communication error when attempting to access SAGE 200 HELP! Any advice is welcome.
  • 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…
  • Sage.Reporting.Engine.Integration - "invalid report file" error when trying to run report

    We are using Sage Accounts 50 v28. I am trying to write sample report generation app using C# and I am stuck at very beginning because Sage is reporting me back that report file which I am trying to use is not valid even if it runs without any problem…
  • 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…
  • Sage 200 API - change the way the licensing works so we can have more then one developer on a 365 license being able to develop using the API

    We are looking to try and get our developers using the API rather the SDK, but we cannot progress with this due to the complex nature of the setup of the API, and also the restriction to only have one log in in our 365 subscription being able to develop…
  • 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…
  • 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…
  • UK SAGE 50 Developer contact

    I am trying to find a phone number of someone who can help me chat to someone about getting a developer license and access to sdk or API details for SAGE 50 UK. I have been dealing through the SA office, but after about 8 weeks they still cannot give…
  • Sage 300 Windows 2020 SDK Development

    Hello, I am new to Sage SDK development ,I am creating add-on in Sage 300 windows 2020 by using SDK.So I want know number of views we can created in add-on .I also want to know how to generate unique key (both long,Integer and string type)? How to compose…
  • Developers - What is ENTRYSEQ?

    I am developing an import file for Sage for an inhouse Onboarding program. I am importing in to the Employees table. My limited understanding of ENTRYSEQ is that it has something to do with payroll being pulled and that number is changed when payroll…
  • committed cost-developer

    Report 6-1-12-51 Committed Cost-Developer. How does this report for Developer differ from regular reports? There are asterisks after some items, but no description of what the * means.
  • 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…
  • Currently at year end and working in P12 and P1 however pay run will not work in P1

    Currently at year end and working in P12 and P1 however pay run will not work in P1 - apparently this is a technical issue with sage so cannot pay any new year invoices - anyone else had this issue?
  • 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…
  • Insert/update row to tables of all other companies

    Hi all, is it possible to do the following: - user update some foreign exchange rate on Maintain Exchange Rates Form of company A, - on click Save button, it will update on company C,D, and E as well. I know it is possible on executable application…
  • Dll to get the table LicenseCredentials data

    Hi all, which dll should I use to get the information of LicenseCredential table? I found Sage.MMS.SAA.Client.Licence but there is no AccountNumber and SerialNumber field? Please lead me to the correct dll. Thank you
  • Save report as Excel Programmatically

    Hi All, is it possible to save a report as excel? On the desktop application, I can see we can do it manually. But how about doing it programmatically with Sage 200 SDK?
  • Get the unencrypted email password in Sage200Configuration table

    Hi all, I need to send bulk email of reports every week, so I am planning to create a program that will generate a report and send an email by using the email setting on the Sage 200 configuration. The program will be schedule to run every week on Windows…
  • New Developer Community - Sage Developers

    Hi Developers, We have just released our new and improved developer community. The community is designed as a space for you to get social. Help each other out with technical and business issues, share your knowledge, thoughts and ideas, and keep…