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…

Hi, I am trying to export transactions out of sage 100 through a VI with a filter on date updated set it to today. I used different functions such as {DAY}, {DATE}, {TODAY} and DATE$. Unfortunately all my methods failed in using the system date as the…

Is there a way to build custom explore views. For example, If I go into Business Insights > Explorer am I able to create one of those views from scratch?

I am using SOTAMAS90 as my source in an import and I need to sort the records before importing (AR_InvoiceHistoryHeader and I want to sort in InvoiceDate order, ascending). How can I add that to the SQL statement? Thanks!

Hi there! I hope you're all doing well. I'm attempting to modify the SQL query of an ODBC Import Job, but it crashes when I press the Test button. I'd like to know if there's a resource where I can find the exact syntax of SQL required for VI Jobs…

I'm trying to create an advanced logic filter that will only capture a few specific customers. With the operand's available I've tried just about every way I can think of including all 20 of the companies. Does anyone have any examples for formatting…

I want to have a select condition for a VI job for Active customers that have been modified or created today (to be run each evening) For the select fields, would something like this be ok? Since there are no Parentheses, I wanted to confirm. What I am…

We have racks/shelves labeled (for example) C01-01, C01-02, C02-01, C02-02, C02-03, etc. (C is the aisle, C01 is the rack, and C01-01 is the shelf.) For our inventory to be more accurate, we've implemented daily cycle counts using Sage Alerts. We…

I need to restrict certain divisions from use in AP Invoice Data Entry for certain roles. The division restriction is the challenge. One cannot use a Pre or Post Validate script on the VendorNo field as would be done in S/O with CustomerNo. Since VendorNo…

Hi All, Just curious if anyone has ever created an SQL query to match up a Sales Order Line's selected bill options with any records in the BM_OptionInteractionHeader that would apply to that combination of selected options. Trying to wrap my head around…

I got a script to timestamp when a udf is updated, now I am trying to create a view in the SQL DB to display on an excel sheet of what SalesOrders have been updated today. Is there something specific with Sage on not being able to create a "view" through…

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.

We are upgrading to Sage 2021 from 2017. The MP_04SuppliesAndDemands view has been retired from Sage 2021. However, my staff does not want to give up the (very robust) MRP tool we developed in house. Consequently, I need to recreate it. Can someone provide…

Looking for opinions on if the the one to many scenario in Sage 100 can be created with Custom Office: one item # to many different models for example. The goal is to be able to search a model # and see all the item numbers that are compatible with that…

Hello, I have a request to setup an aggregate query linked to an email event which lists the total sales by salesperson for the day which is pretty straightforward; however on this same email they want a breakout of those sales listing the order number…

Hi Everyone, I am wondering if there is a script that can be written in Excel to look up an item number in SAGE and return the required date back to the excel sheet? Following the screenshots below I would like to have excel pull the next required date…

I am trying to ask a question about querying historic aging but for some reason the question won't post? Is there a limit on question size or attachments?

We are using SQL Linked servers and are receiving the error [ProvideX][ODBC Driver][PVKIO]Invalid segment number in one company (JAN). We are getting this error when doing a Select * From GL_DetailPosting. (Other tables work without error.) We can get…

I have a script for Item Maintenance that is connecting to Item Warehouse, summing up QtyOnHand and then writing it to a UDF on the Main Panel. The script works when I can get it to run, but I am having trouble figuring out which Event I can associate…

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…

Hello All, We utilize a number of kits on a daily basis, and I'm looking for a way to check stock/backorder when a component is not available. This tends to cause a bit of an issue when receiving product and the backorder report doesn't produce the…

Hello, I am trying to put together a report for tax purposes and am not confident I am pulling paid invoices correctly. My initial thought was that all invoices in the ar_invoicehistoryheader table were paid, but I was told that these invoices are…

Where do I go or can I add fields to the "Select Field" options that filter out what sales orders you want to group on one PO? I am assuming the fields in there are by default but it seems like there would be a way to add other fields, we have some UDF…

Created a customized Accounts Receivable Invoice History Report that is to be sorted by a UDF. Parameter comes up and asked for the UDF and I choose one and then the report prints all UDF records. Any suggestion on where to look to see why the sort…

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.