Sage 200 UKI

Hi all, I would like to add new fields from my custom tables, to existing Sage 200 reports. What is the correct step/best way to do it? I was thinking of just amending the reports in "C:\Sage\reporting\default\reports" and save. But what is the dos…

I am unable to post anything that resembles code in here, sage uk developer, and the new developer site. what is wrong? I really2 want to ask someone so I will post as image

Hi All, I am doing customization on few standard Sage 200 forms, and I found an odd behavior when selecting customer code in different way. For example, on Sales Ledger>New Invoice, we can select customer code in 3 methods: 1. click dropdown and…

Hi, I work on lots of different projects each day and presently have to keep a spreasheet to translate project titles into Sage project codes because these aren't shown on our company timesheet entry screen. Having the project titles shown would save…

Hi all, I want to amend the grid inside a dropdown programmatically so the Name column is wide as soon at the form open. But I am unable to get the grid inside it because its control is PopupTextBox+Dropdown which I cannot initiate in the code. Also…

Hi All, On desktop list, I would like to change the background color of the cell is the value is below margin. When I export to excel, I need to cells to be red as well. I see that the "this.list" control is available but the color did not change…

I would like to do query as below: but I found that sage 200 only provide simple query & filter function. This query is to get the TOP 1 of each group select top 1 with ties m.MovementID, m.ItemID, m.CostPrice from MovementBalance m group by m.ItemID…

Hi All, I would like to add bracket to "-" if the value is negative & separator. I successfully do it on the "Gross:" field but not able to add it on values in the grid. Any idea how to do it?

Hi all, I would like to force hide the cost center & department fields from Nominal List. unticking it from the columns list will not be acceptable as user can still tick it and display the fields. Any idea maybe by using code or anything? Thank you…

Hi all, for some reason, I want to update specific fields but these fields have read only status. Any other way to update it programatically? the fields is DocumentValue, UnitBuyingPrice, LineTotalValue in Sage.Accounting.POP.POPInvCredItem …

Hi All, I need to do the following: Update multiple company from one company. Lets say I have company A, B, C, D, E. Login in Company A, I add new customer and company B,C,D,E must add the same new customer, and vice versa. Is it possible to…