Sage 200 UKI

When installing Sage 200 client on local PCs i recieve the following error: I have read that this could be due to the certificate not being on the local PC, however i have since copied the certficate to the PC and i still get the same error message…

Hi, I’m running safe 200 on a Remote Desktop, when I try to download files from safe into my local computer, it says windows is unable to use the network resource. Has anyone experienced this?

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.

Hello, new to this community. We are trying to set up BACS in order to pay our suppliers. BACS are asking for a Software Package SFP Reference number. Does anyone know where to find this in SAGE 200 please.

Hi, I'm looking to change and update the product groups of all stock items we have on our system. Is this something that can be done by exporting and importing records, or would each product need changing one by one? Thank you!

Hi, I am trying to build a excel report using SQL to give me MRP demand. I have built 90% of the report but need to add in the works orders required/demand quantities which haven't been allocated to stock. Below is my current query - any help would be…

Does anyone know what is this field and how it is populated in the reports. I have a EUR account and when I post entries into this account it randomly takes iso code 46/49 on its own. I want to understand what is driving the postings in this field.

Hello there After having a chat with Sage 50 support, I have been informed that you cannot run a TB with individual monthly movements from the moment of the new year, unless you close the year in SAGE, action which is irreversible. I would like to…

is it possible to do volumetric pricing in Sage? eg 1-9 = £x, and 10-100 = £x? thanks

Hello, Does any one know if there is a way in Sage 200 to copy a sales order from one customer account to another customer account without having to re-input all the products? So as an example, one of the team has put a complete order on the wrong…

I have linked our Sage 200extra account which runs on a remote server with Power BI. It works sometimes at refreshing data but 90% of the time is returns the below errors. The refresh tends to work on in query editor but basically never in the data view…

Hi All, We receive orders through our website, and the sales orders are entered and the payment recorded under the tick box "Record Payment with order" However, this has caused issues because we part despatch orders, and you cannot generate part invoices…

Can someone help with an issue I have please? We need to process a sales order but the order has staged payments. For example, the sales order would show a stock item with a value but we need to invoice the customer 20% in advance, 50% upon despatch…

We are a GB Based company reporting in Euro. Does anyone know how to deal with payroll (HMRC for PAYE) and Cortax nominal ledger accounts that are affected by journal entries in Euro and payments in Sterling for revaluation purposes?

Hi There, When I used to view my sales list I could select multiple sales orders and the footer at the bottom would show me the total amount of the selected rows, However i was adding new columns to my sales list and removed the amount column by accident…

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, the API documentation discusses that field nominal_analysis_items is returned when querying endpoint sales_transaction_enquiry_views. but it doesnt seem to return. is there a way to get this data? thanks Gareth

Afternoon, Can anybody tell me how to reverse the criteria for this report? It is currently showing my works orders by number starting from 1 in the drop down, whereas I would like it to be the opposite and start from largest number first. Thanks…

Hi, I have the below code but need to add in the the delivery postcode (highlighted yellow below) - how would I add this in, I'm not to sure of the joins? SELECT DocumentNo, DocumentDate, DocumentTypeID, DocumentStatusID, SOPOrderReturnLine.ItemCode…

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>();…

One of the clients I am working with for my company is switching to Sage 200. They want me to integrate Salesforce with Sage. Does Sage 200 have a api with a REST endpoint that I can make requests against without having to register for the developer program…

Hi everyone, I'm fairly new to Sage 200 and still trying to discover it's possibilities. I've been wondering if anybody has any idea if there is any report or how to create one that will basicaly generate you a list showing all the Credits and Debits…

Can someone help me with the below code? In the below which I have put in bold it only picks up if there is information in Analysis Code 9, but not if the column is left blank. Is it possible to update the below so it picks up where the Analysis Code…

I have just created a query which brings back sales order information but I am struggling to bring in the Stock Item Code as well - below is the current code I have done but could someone help me to add in item code? SELECT DocumentNo, DocumentDate…