Sage 200 UKI

Hi all, is there any functions to do the following: 1. find the item 2. find the all transactions that uses this item 3. remove the items and transactions. 4. in the meantime, take care of the data to avoid data instability. thank you.

Hi Guys The Sales Ledger has now been closed for December, but I am still not able to print the invoice in Sage. How do I get the invoice into Sage Spooler for printing. I don't want to post but just print.

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, My users, lets say user A,B, and C have their own preferences on the menu sorting/arrangement/naming. Whenever customization update installed, the menu arrangement will reset according to Sage 200 default sorting/arrangement/naming. Each user…

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, 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…

Hi all, on SalesReceiptForm, I added a new custom field "BankDate" and I assume I shall add the field to SLPostedCustomerTran table as extension (SLPostedCustomerTranX: column BankDate; data type datetime). Then I see that this form is using Sage…

Hi all, How to check the customer whether it is already exceeded credit limit or not, programmatically? Because I do not find any standard function to check it. I only find the exceptions, but I do not know how to trigger the exception during customer…

Hi all, I have a customize form that have been working for ages. On recent changes, it got error on customer side, while on my local PC the form is still working. Looking at the error, it is related to Sage library. The only difference from customer server…

Hi All, I have a StockItemLookup and add it to my custom screen.I know how to embed additional columns (see below PKG, Size) from my StockItem extension (I have a table that is an extension from StockItem, called StockItemX). My question is, can…

Hi all, I have a sql script and previously successfully updated to Sage 200 company database. Now I add the following line EXECUTE spCreateColumn 'UnprintedInvoice', 'FormNumber', 'bigint', '13', '2', 1, 0, 0, 1, '0', 'None' EXECUTE spCreateTable…

Hi all, I see there is tblParameter in configuration table, I would like to store my key value such as custom database name, servername, username, and password in tblParameter to be used in my custom form. In Sage.MMSAdmin.DBSchema.Others, I see there…

Hi all, I want to create a custom database using addIn.sql file from an Add on, so user do not have to go to MSSQL to create himself. But I have problem installing the add on because of this error: "CREATE DATABASE statement not allowed within multi…

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