• 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…
  • 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…
  • 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…
  • 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…
  • 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…
  • 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?…