• Sage 200 MRP SQL Query

    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…
  • Sage200 on High Availability

    We are currently upgrading our sql servers and have a setup where we have sqla and sqlb which both replicate each other in case of any issues one then fails over to the other (high availability). We are having an issue where it looks like our sage200…
  • POP Order Status

    Hi community, We have a small issue with the POP List. Sometimes, an order is fully received but hasn't been invoiced yet. In the system, it still appears as "Live." It's okay, but we need a better way to see what's going on. Each user as their specific…
  • Sage 200 OBDC adding in Delivery Addresses

    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…
  • SQL Help

    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…
  • Item Code within SQL

    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…
  • Sage 200c with remote SQL

    Hi. So I am not a sage engineer, but a Linux system admin, I work for a company that also has an external sage IT provider that handles a local on-site server with Sage/SQL etc. The current setup is a traditional DC and separate sage/sql combined…
  • Upgrading Sage 200 - Windows 2008

    We have recently been contacted by our Sage Support, telling us our Sage 200 system needs upgrading. We are currently running on Windows 2008, and the support have told us Windows have announced they are turning off the server(?) that our Sage connects…
  • Sage 200 Report Designer - Join Not Detecting New Column in View

    On our picking list report we've got a join to an SQL view called 'SOPAdditionalChargeView' which is used to display the additional charge line for the order at the top of the picking list. Without going into too much detail I have added a column to this…
  • Create custom database using AddIn.sql failed with SQL error

    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…
  • Sage 200 Is the view created for custom reports stored somewhere on the sql server.

    Hi, Is the view created for custom reports stored somewhere on the sql server. We have a custom report for purchase legers that pulls a lot of data together. I was wondering if this view is stored somewhere in the sql server so that we can easily…
  • Sage 200c SQL View Question

    I am trying to create a SQL view that shows the order details from the SOPOrderReturn table, the email address on the order (if not using invoice address) from the SOPDocDelAddress table, and the main email address for the account (for use when there…
  • Configuration Database Update Error

    Hi Everyone, HAve a bit of an odd-ball one, haven't come across before. Just wondering has anyone seen this one before? Testing an upgrade to Spring 200C on a new server and getting below error trying - trying to update the 200 Config DB. Trying…
  • Is there any specific operations or precautions that need to be carried out before installing SQL 2014 Service pack 2 on a server that has an installation of Sage Extra 2016?

    I have a Windows Server 2012 running SQL 2014 Service Pack 1. Sage 200 Extra 2016 version 19.0.1.0 is installed on this SQL instance Can I just apply SQL Service pack 2 to this server or will this damage/destabilize the Sage 200 installation? eg…
  • Stock Balances

    Is there any way to start a fresh with basically a blank stock slate? Currently using 200c on site and we're having a nightmare with batch traceable items being booked in by HH scanners (datalinx) they are managing to slip into the system with no batch…
  • Sage 200 Update - Failed to run SQL script

    Hello all, Whilst trying to update Sage 200, I'm getting the following error message: Failed to run SQL script 'Sage.Manufacturing.Database.Sql.UpdateScripts.16000200.sql' against company dataset. Has anyone come across this before? Or any ideas hope…
  • Sage200 extra SQL server

    Hi All, I'm setting up Sage 200 extra. It says in the documentation that for the amount of people, I can split the install on to a SQL server. Has anyone got a step by step guide on how to install the SQL server itself? What options to install?…