Sage 100

Has anyone ever experienced no companies showing in rebuild sorts? They are there for rebuild keys, etc but just not sorts. I tried replacing all the query files & dde & ddf and sy_exportlink but no luck. Tried creating a custom lookup to see if they…

Preface: We are only on Sage 2014 for a few more weeks:...so no comments about how old it is..(smile) A user created a custom filter for the Customer Maint table which included a value which is not in the UDT (user defined table) lookup When the user…

I would like to read through the lines of an invoice in ascending ItemCode order during a SO_InvoiceHeader Pre-Write script, but they seem to be unaffected by a SetBrowseFilter and appear in entry order. Any ideas? Here's my 5 line test case: sItemCode…

Need a tutorial on Pick Tickets Other than SO_PickingSheetWrk.M4T, where Sage end the picking process? There are no fulfillment functions in Sage, correct? How do the Pick transactions end in Sage 100 (without AddOn/Exteneded features Scanco etc…

Silent ODBC is working, but cant add a SQL linked server. error code below Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "SAGE200". OLE DB provider "MSDASQL" for linked server "SAGE200" returned message…

Is there somewhere in Sage 100 that I can see the field lengths for each field in each table? Here is why I ask: the stock Sales Order printing report shows only the first 100 characters of SO_SalesOrderWrk.CommentText. We have many records having…

I have successfully been able to create queries that can access the data in Sage but I am now trying to query data from a UDT and I am getting an error. Can anyone advise how to workaround or solve this error? This query runs fine: select * from …

Using Sage 100 ERP v2017. I am trying to run a very basic MS Excel query in order to build a database for our new website. Literally, all I am trying to get is the product part number, description and the name of the item image. My query is as follows…

I have a VI job that is exporting just 2 little fields. However, I need to do the Select criteria based on two fields in two files being equal. My base file is the IM_ItemWarehouse file, and I only want to export records where the warehouse field is equal…

I am trying to go through the the AR_InvoiceHistory and find invoices with a balance. However I can't find a field for balance due. Yet in A/R Invoice History Inquiry there is a section under main for Balance. Where does this balance data come from? …

Is it possible to query Sage 100 data in Excel, using Office 365 (Excel 2016). I installed the 64 bit ODBC Sage 100 driver. In Excel 2010, it's pretty easy. I always used the steps listed in the link below: https://support.na.sage.com/selfservice…

Hi There - I don't know if this group is still active, I'm having trouble trying to query resources by date. For instance, using this query to get sales orders: mydomain.com/.../*** /SO_SalesOrderHeader The query parameters I've tried: …

Hi Forum, i am trying to connect to a MySQL DB from a vbscript. I want to be able to update new customers entered in Sage to a table in a MySQL DB. I setup the script as Table - Pre-Write and also as Table - Post-Write and i am getting an error…

I'm trying to get a script to trigger when a General Journal Entry batch is being posted, but nothing I'm trying works. Pre-delete events on the header and detail tables work when in the data entry screens, but not during posting. The history tables aren…

I'm trying to set up a VI import from Sage 100 table data, using an ODBC data source (DSN pointing to another company code). What I want to do is filter the records to rows with a DateUpdated of today, but I'm not sure how to set that up. Whenever I try…

Using VI to import into physical count. On serialized items, if I import a new serial number (did not previously exist in the system), the "frozen" qoh (which should be 0) is incorrect. If I had 3 new serial numbers for the same part, each new line shows…

I have a number of access 2007 (but 2003 format) queries using ODBC pass-through, they all were working on MAS 4.5 upgraded to Sage100 on a new server and now they can't connect to the new tables and are only returning data through the upgrade date on…

We loaded Service Pack 14 this morning for 4.3 and now all of our custom look-ups for sales orders are corrupt. It says to delete and reenter, which I did, but that didn't help. Anyone else have this problem?

We just installed MAS 200 v4.5 on a new server and will migrating to it very soon. I wrote a custom API to expose MAS data as XML through a web site. The server that it is installed on is running Windows Server 2008 R2 64bit. I installed the MAS…