Sage 200 UKI

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, I have this SQL query where I have a whereclause l.LineQuantity>six.TriggerQty select c.CustomerAccountNumber, c.CustomerAccountName, h.DocumentNo, si.Code as ItemCode, si.[Name] as ItemName, pg.Code as ProductGroupCode, six.TriggerQty…

i'm creating purchase orders via the SDK using the examples in the help as a template. basically create a poporder, assign the supplier, add lines confirm and post. What appears to be happening randomly (on customer site, i have not managed to see it…

Hi all, I want to join StockItems and StockItemSupplier table using Sage.ObjectStore.Join below. StockItems sis = new StockItems(); try { Sage.ObjectStore.Join join = new Sage.ObjectStore.Join(); join.RightTable = "StockItemSupplier"; join.RightTableAlias…

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…

Hi all, I see that Sage 200 have this class: Sage.Accounting.User, but how do I get the current user? Thank you

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…

Hi, I would like to send reports to a printer, in my own code using the sage SDK, using the output mode of printer, but not have the Choose printer dialog come up. Any idea if this is possible? Regards and thanks in advance Toby

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…

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…

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, On the form Currencies and Exchange Rate, I need to detect if user have added new currency on the currenciesGrid and prompt user and at the moment the Save button is clicked. But I am not getting much information about it. OnClick Save button…

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, would like to know if anyone success to add Sage 200 library as reference in Excel Macro VBA? I tried adding Sage 200 assemblies to reference but get error

Hi All, I want to send/receive data to/from Sage 200 to another Web application. I want to do it by using SOAP Web services. My question is: 1. do Sage 200 support SOAP web services? Thank you.