Sage 100

I am trying to find a way to return the description of a UDF using SQL. I am currently using the following: Select * FROM JT_Employee But I need to bring forward the descriptions of the UDF's. So for example, "UDF_F_Name" would return "Employee…

Hello folks, We are starting the process of upgrading from an older version of MAS 90 which ran on Providex to 2023 Premium. There are a number of custom apps that we've developed over the years to run with our MAS data and they all used the MAS ODBC…

Currently on Sage 100 Premium 2021; I need to track changes to AR_RepetitiveInvoiceHeader and AR_RepetitiveInvoiceDetail, but no built-in audit log exists. I've toyed with scripting to a UDT but now that we've moved to Premium, the power of MS SQL is…

Hi All, Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script. I right clicked on the…

Hello, We are trying to set up an invoice report for a 3rd party company to help us manage our taxes. They require that we put taxable amounts on one row, and non taxable amounts on another row per invoice as we have some invoices that have both taxable…

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

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…

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…

Been looking for a way to do that in Sage 100 when using Premium version, but not finding anything. In Sage 500, we commonly will create a custom SQL view and make it available to users in BI Explorer. Anyone else out there mastered this? Thanks…

I'm doing a Pass Through Query using Microsoft Access, the SQL statement below works fast and fine. Is there a way to request the date parameters from the user in the WHERE statement each time the query is run instead of the parameters being hard coded…

First of all, this is for Sage 100 ERP (5.00.2.0) and SQL Server 2008 R2 I've been scratching my head. I have a simple code that is triggered at post-write in SO_SalesOrderHeader, i.e. a user hitting "Accept" in Order Entry window to execute. The…

Hello, I am new to the world of Sage ERP. I have designed this query and it works fine in SQL: SELECT o1.*, ( Select isnull(SUM(D002_DollarsRented)+SUM(DollarsSold),0) FROM openquery(TESTSWRMAS, 'select * from AR_CustomerSalesHistory') o2 WHERE…

I am working on a Sage 100 (MAS 90) Visual Integrator Job and trying to upload data from SQL. I created the ODBC connection, but I can't pick the database. Does anyone know how to select the SQL database once the ODBC connection is connected to the…