x Want to participate? Join the group to interact

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

  • Sage 200 ODBC

    Hi, I am trying to amend a query from Sage as needed to add in the delivery address details but doesn't seem to be working. Below is the original code that I need to amend and have highlighted in yellow in the table below what I am trying to add - any…

  • How to get transaction values for the nominal ledger in ODBC Sage 200 connection.

    Hi, i'm new to using sage 200 and have been given access to our ODBC connection to review some of the reporting tables available to us. I'd like to create a connection that allows me to pull nominal transactions but while the table "NLPostedNominalTran…

*Community Hub is the new name for Sage City