Sage 100

The ScriptBasic distribution comes with a web server version of the language. It runs as a Windows process and is multi-threaded. The best part is you can run your BOI external scripts on the web server with no modification to your BOI specific code.…

Any help is greatly appreciated. Using Sage 100cloud Standard. My company uses Access to query Sage data. This works well, but I'd like to run more advanced and rapid queries. My system administrator has allowed me to install Postgresql on my computer…

I seem to recall a Sage KB that indicated there were only 3 Join Types supported by Sage (MAS, back in the day). Inner Join, Left Outer and something else. I don't recall hearing about the "Enforced" setting. I ask because we have a client who are very…

I am developing a Windows Forms application which is required to connect to Sage 100 and get order information. I am using ASP.NET and SQL Server 2008. Is there a way to connect to the sage 100 database? myprepaidcenter login

We have Sage 100 2014 running on a Server 2012 VM. We have a custom application that runs on a client machine which reads data from a couple system tables. Here's the odd thing. When Sage is running on the client machine, everything works fine on…

In prior versions the Microsoft OLE DB Provider for ODBC was available in SQL to setup the Linked Server. In SQL 2019 I dont see it nor can I find a download to add it. Am I missing something? The Sage 100 2020 32 and 64bit ODBC connectors are both…

Has anyone used Sage Alerts & Workflow v10 w/Sage 100 providex yet? When I try to add a calculated column, the top where it says calculations to perform is blank and I can't choose a calculation. If try to do it manually whatever calculation I receive…

We're using the SODAMAS90 4.0 ODBC driver from sage. Our excel is part of office 365, so it is the latest version. We were able at one point in time (a few weeks ago) to run queries in excel via Data > Get Data > From Other Sources > From Microsoft Query…

Can you use the connector module to connect your Sage 100 ERP to an excel spreadsheet and match up the invoice number from Sage 100 to a column in the spreadsheet called invoice number for example? (sage 100 std v2018)

I have a client who is migrating from Sage 100 4.5 to Sage Intacct. I'm trying to take Job Cost lines posted to the GL and break out (tag) the summary lines by job number and cost code (dimensions). But when I look at the JC tables such as JC Transaction…

We have Sage 100c 2019. We use Sage Intelligence that sends reports via Windows Task Scheduler to Power BI Desktop. We use Power BI Cloud that pulls the data. This has been working successfully for a long time. I am testing a DIRECT connection between…

Hello, I'm trying to use MS Query to get quantity of some Components shipped to each country in past years. I am able to get such list of data for Items using tables of AR_InvoiceHistoryHeader/Detail. How can I get to quantity of Component then? I…

Hi all, would like a better understanding of best practice in setting up an ODBC link for Sage 100 VI jobs. We are currently still on Sage 100C Advanced 2018, and I am working to beef up what began as a home-grown Access solution to meet a specific accounting…

I am creating a GL Detail report (GL_DETAILPOSTING) and need to have the fiscal year and fiscal period columns added to the report. What table do I use to join?

Hi, I've been wondering if there's a way to get the latest revision number from A Bill of Materials. I've tried to get the value by uising oProduction.nGetValue("Revision$", strRevisionNo) but im still getting the "000" revision number. Thanks…

Which Sage 100 IM table contains the Standard Cost field? I need it for a Crystal report, but can't seem to locate it.

why is the container importing my excel file with blank (NULL) values for items with alpha numeric labels? additionally the columns have switched order? Excel Output Connector Module Sample Run Original Excel FIle Import

We are using a 32-bit System DSN with SOTAMAS90 to connect our Knowledge Sync Tool (Sage Alerts & Workflow) with Sage 100 Advanced (Providex). It works great 29 days out of 30. On the first day of the month all users are locked out so month-end process…

I have set up a linked server in SQL 2017 set up from Sage 100 using the v4.40.0004 ProvideX ODBC Driver. We are looking to create a data warehouse to mirror Sage 100 ProvideX tables in full and refresh deltas throughout the day. Pulling FULL tables…

What are the differences between 'Time Created' and 'Time Updated' fields in the invoice history? Assuming they are my local times and that it is based on a 24 hour clock with decimals as fractions of the hour (e.g. 15.5 = 3:30 PM)?

The SO_SalesOrderDetail has just about every field I need except the customer number. What other table can I use to link them and report this field in Sage Intelligence 100? I am using Microsoft Query.

I have a client that is basically holding company, several companies, each with their own Sage server. They are wanting to do consolidated reporting in Sage Intelligence, for all companies. Can this be done? If so, how?

Had a Crystal report using the JTDActualCosts and JTDInvoiceBilled fields from the JC1 data file. Recently upgraded to 2018 and the JC data file no longer has these fields. Where can I find them?

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…

We just updated our Sage 100 to the 2019 Advanced version. We also use Sage payroll and downloaded the latest version. In previous versions, there was an ODBC database file named PR1_EmployeeMaster. I don't see that file is available in the 2019 version…