Sage 100

I have this query returning the error message. Any idea? SELECT A.SalesOrderNo, B.UDF_COMPLETE_PART, B.UDF_CUST_PART, E.ExtendedDescriptionText, B.UDF_Serial, A.CustomerPONo, A.UDF_EXT_CUST_PO, A.ARDivisionNo, D.CustomerNo, D.CustomerName, A.ConfirmTo…

Sage 100c 2018 SQL server I want to add a database to my production Sage 100 Server instance. Will this cause any issues with Sage 100? I may also be able to use a linked server, but I'm not familiar with the limitations there, either.

We have many customers that require we treat their various ship tos as bill to's. So, despite the customer locations having a common owner, the billing and account maintenance of each location must be treated as it's own entity. Since MAS90 (sage 100c…

We have one user for whom every time they go to print any form, the Template Selection dialog pops up so she has to select 'Preprinted,' 'Plain,' 'Marbled,' &c., before proceeding to the main form printing screen. This has only been happening since our…

Hello, We had something strange happen once last week, and now once again today. We had an order which was not acceessible through Sales Order and Quote History, so accounting contacted me. After checking our database, I noticed that there was no…

Hello, I have a script complete that runs a SQL Query and returns the results back in a MsgBox. The very last part I need to do is access the Sales Order Number to include this in my "Where" clause for my Query. This needs to be run on the Client…

Hello, I'm working on a project and I need to be able to pull the same information the "Invoice History Printing" report pulls for a date. For my selected date, in our database we have about 3,000 invoices. The report, however, only pulls about 140…

Hello, We have been trying to troubleshoot our slow performance with SAGE 100 PREMIUM 2018 and are running out of options. I have read all the articles here and on the knowledge-base, and nothing seems to be improving our performance. My last inquiry…

Hello, I'm looking to re-create a Crystal report so that it can be run by Knowledge Sync. I initially wanted to just use the report provided by SAGE, but it looks like I can't use this report as the information the SAGE report pulls is only generated…

Hello, We are looking to remove some data from the "Customer Maintenance" screen as some customers take roughly 30 seconds to load all of their history. I am specifically talking about records under tab 6 "Invoices", and tab 7 "Transactions". I am…

Hello, I am creating a report for our accounting department which shows all A/P batches that either remain open, or were created today. I have the first part, where I can pull up all active batches through GL_CompanyActiveBatch. However, I am having…

Hello, Our company MAS system has been running very slowly and I would like to delete some records form our database. There does not seem to be information on certain tables inside of SAGE under File Layouts and Program Information. Specifically, I…

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…

Hi; Please someone can help me ; i need a manuell of structure database SAGE 100 ; thnks!

Hi all, I have recently created a script for the field "invoiceDate" that restricts how far into the future a user can enter the date for. I am wanting to apply these restrictions as well for the posting date. This should be relatively easy, except…

We are using Sage Premium 100, and have crystal reports for sage installed. We have the SQL version of sage. My user role is an 'admin' in sage. I know how to get to the place to make a new database connection, however, I am lost after that. I would appreciate…

Using Sage 100 Premium 2017 Using Crystal Reports 2011 I have six production SQL databases, all structured identically (for regional purposes). I have created a Crystal Report using a Connection based on OLEDB using one of the 6 databases. It uses…

Hello, I am trying to do a SQL query to see which users have had activity on a specific company ABC by doing a SQL query on the SY_ActivityLog table. When I do a query where CompanyCode = 'ABC', I get MOST of the users that have had activity on ABC…

Good morning. During the refresh of an upgrade from 2017 Standard to 2018 Premium, the system activity log shows the following messages for each company that was converted. XXX Company data conversion to version 06.00.00.00 started XXX Company data…

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 …

I am trying to use subqueries and joins in my PHP script that is pulling data from SAGE, but I keep getting this error: Warning : odbc_exec(): SQL error: [ProvideX][ODBC Driver]Expected lexical element not found: <identifier> Here is my query: SELECT…

We have an application that wraps around the Sage 100 data base using the Sage 100/Providex 64-bit ODBC driver as a linked server to an instance of MS SQL Server 2014 Express 64-bit. Various views are then defined against the S100 tables in the SQL Server…

I have a client that's interested in using 100 Premium in a SQLaaS (SQL as a service) environment. I can't find ANY documentation on this, so am assuming it's not supported by Sage. Has anyone had any experience with SQLaaS at all, or with Sage 100 Premium…

Last night I was doing some maintenance on one of our warehouse (zeroing out product), and noticed a problem I'm not quite sure how to solve for. I found that we have an item in our SQL database (Running Sage 2014 premium) that says we have .014400…

We are currently running Sage 100 2014 premium edition with SQL Server 2008 R2 Standard. I am looking to upgrade to 2016 or 2017 in the next month or so. I was double checking the 2017 Supported Platform Matrix and noticed that it did not mention SQL…