Sage 200 UKI

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…

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…

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…

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 have the following code where I list all the companies that have the same base currency as the current company. public List<CompanySelection> GetTheCompaniesSameBase() { List<CompanySelection> companies = new List<CompanySelection>();…

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, I wanted to import a lot on project accrual from an excel file. But I cannot find any guide or tutorial on my.sage.co.uk/Sage200SDKDocs about it. I am also checking out the PCAccrual classes such as Sage.Accounting.ProjectCosting.PCAccrualFactory…

Hi, I need a way to detect the changes on Currencies and Exchange Rate form whether the change is in Exchange Rates tab, or the Settings tab. On AfterClick Save button I need to prompt the user the change that have been made.

Hi all, I tried setting the reference like this, but I guess the Journal Entry reference field is not BatchReference. Anyone know how and which field is use to set the Journal Entry reference? Sage.Accounting.NominalLedger.NominalNextJournalReferenceNumber…

Hi all, I want to import journal entries from excel files. Unfortunately, I get this error: The value are like this: My code are like this: Sage.Accounting.Common.NominalSpecification nominalSpecification = Sage.Accounting.Common.NominalSpecificationFactory…

Hi all, how do I get the value of UpdateNominalImmediately from SYSSetting table programatically? I tried Sage.Accounting.SystemManager.SystemSetting but its not in there.

Hi All, how to handle the Exception "Ex20235Exception" and make the answer always No? I do not want to show the message to user. Ex20235Exception content is " There is an order value discount available. Do you wish to apply the discount?" I catch…