Sage 100

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…

In GL_CompanyActiveBatch it appears the batch status field is always blank. Trying to write a Sage Alert that filters out any batch "in use". Is it even possible? Sage 100 v2021. Thanks.

Hello! I am trying to find a way to automatically export sales order data (specifically ship date) from business insights sales order view into a locked excel document provided by my customer. It would be nice if i could filter a whole list of orders…

Has anyone installed the F9 software version 4.5 with Sage 2019? We currently have 2016 and it works fine but we are about to upgrade and before we make a change I thought I would check.

I inherited a custom-built program that talks to SAGE. The program relies on the following query to work: SELECT AR_InvoiceHistoryHeader.InvoiceNo, AR_InvoiceHistoryHeader.InvoiceDate, AR_InvoiceHistoryHeader.Last4UnencryptedCreditCardNos FROM AR_InvoiceHistoryHeader…

Is it possible to filter the records when using the Next / Prior navigation buttons in a panel? Using the Payroll...Employee Maintenance panel for example, I know it is possible to filter the Lookup list when selecting an employee, and I have my default…

I want to create a calculated field (say Gross Margin) in the Item View Explorer. Calculation would be (Standard Price- Last cost)/Last Cost. However there are several items that do not have a last cost yet because there has not been any inventory produced…

I have a customer that has a very large number of items with lot numbers. Their products are lumber of various dimensions. 2 x 4 x 10 or 1 x 10 x 12 etc. We want to add a UDF or possibly an alias that will allow a lookup of a all "2 x 4"'s or all…