Hi all,
I want to create a program where all companies in Sage 200 should be able to access and the data provided in this program should be stored in a custom database, not individual company database. I assume for the create database query, I can add…
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,
I need some help with Report Designer, I am currently trying to make some alterations to a report that was created that displays a list of all of the outstanding PO's on our system and I would like to try and get the POPOrderReturns.RequestedDeliveryDate…
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 experts,
Coming from a small company that produce self-made product and customizations (so relation with client is key). We just purchase sage200 under the promise we could manage all invoicing and stock management, and rely on external consultant…
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,
I have created a new Field ZDesc in my ITM screen and i want to display that Data in WorkOrder Screen and allow the user to enter additional data and finally should save in workorder table.
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
…
Hello,
I want to share how to customise the time entry list by adding translation.
By Time entry list i mean the dropdown list we get that allows us to select the start time and end time for an appointment(scheduling appointment).
For eg: by default…
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…
Securing web applications can be tricky. One surefire way securing the system is to lock it in a box, where no-one can switch it on, much less enter data into it. Unfortunately, this is not the making of a useful CRM system. In Sage CRM there is a feature…
I apologise if this is covered somewhere but I cannot find the answer anywhere.
When creating a new multi-select field the actual field within the database is created with a data type of nvarchar(255). This means that if you combined multi-select values…
Hi,
From where can I customize the communication lists for Order and Quote?
I noticed that:
Administration -> Customisation -> Communication -> Lists -> CommunicationList is implemented for Company, Contact, Case and Opportunity communication lists…
Hi All,
Using standard CRM Reports on a custom entity
I have a standard report with grouping (Group by company) and the details are listings of qty's from my custom entity Then I have a (sum) total at group footer
Is it possible to suppress the…
Hi All,
On the Wave Activity screen - there is an option to: Show/Hide analysis
When you show analysis - this shows a summary total of Opp/Comm/Leads etc..
On leads as an example - I would have say 50 leads as part of the Wave Activity Is it possible…
Hi
We have made a number of customisations to a Test CRM system (adding some entities, fields, tabs, screens etc). We now wish to apply these customisations to the live system. Is there any way of doing this without having to go through and manually…