Welcome to the Sage 200 Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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…
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…
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…
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…
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…
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…
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…
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…
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 - apparently this is a technical issue with sage so cannot pay any new year invoices - anyone else had this issue?
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…
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…
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
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?
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…
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…
Hi all,
is it possible to add a job/function that will run once the Sage 200 is open?
I want to do something like this: if (DateTime.Now.Date=='07/01/2021') {//Do something }
I want to do it with windows scheduler where everyday it will run a program…
Hi all,
I want to change the order of the item code appears on the SO invoice.
I have tried something like this
line.PrintSequenceNumber = printSeqNo; //where printSeqNo is already set
and on the report I set to order by PrintSequenceNumber. …
Hi,
I work for a company that produces a piece of business software that can be configured to export invoices & credit notes to a company's (our customer) accounts package. We have a number of customers who use various versions of Sage, including Line…
Hi all,
I am looking for the column name of "Use the same sequence of numbers for both invoices and credit notes" and "use separate sequences of numbers for invoices and credit notes" from Sales Order Processing>View Invoice and Order settings screen…
Hi All,
I'm a web developer and I'm just wondering how I would approach a requirement for PayPal transactions to be feed into Sage 200. I assume there is nothing I need to do on the website side? I've seen something about setting up PayPal as a bank…