Sage 200 UKI

Hi, I am currently trying to work out where the suppliers email address's are stored, if I go to Purchase Ledger > Suppliers List, there is a column here called "Contact Email" and if I double click an entry then click "Account Enquiry" the address…

Hi all, I store data on tblParameter (in config database) because this data need to be accessed from multiple companies. the problem is, only admin user can access this tblParameter. How can I allow normal user to access (read only) to this tblParameter…

Hi, City Crew. Hoping someone might be able to shed some light on the Sage 200 database. Specifically, I am trying to find the table/Column (should be binary) that drives the Supplier Transaction indicator (paperclip icon) on whether or not a transaction…

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 have a custom database(not company database) to store information to be retrieve by all companies in a custom form. I am able to query its table using plain query in MSSQL Management Studio. With Sage 200, I am able to make a connection…

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 looking for the column name of "Use the same sequence of numbers for both invoices and credit notes" and "use separate sequences of numbers for invoices and credit notes" from Sales Order Processing>View Invoice and Order settings screen…

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…