• Error 88: Invalid/Unknown property' on reference to a business object from within the same object

    'Error 88: Invalid/Unknown property' on reference to a business object from within the same object I am trying to browse the records in the 'SO_SalesOrderDetail' from within a Column Pre-Validate script on ItemCode in the same table'. This works from…
  • Sage 100 2023 SQL queries not running in custom web app

    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…
  • Display Inactive Item check box doesn't appear to do a darned thing

    I (on 2023 Std) and at least 2 clients on 2 different versions have tried to uncheck the Display Inactive Items check box and have it actually stop Inactive items from displaying in a lookup, but to no avail. The Inactive continue to show up. What, exactly…
  • How to add a today's date filter to a Visual Integrator Job?

    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…
  • Build Custom Explore Views?

    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?
  • Making an Explore view a shortcut

    I am wondering if there is a way to make a custom view from the business insights explorer a shortcut within the Explore Tab? am I able to put a custom view in here somehow as a shortcut?
  • Sales Order import bypass VB scripts

    Is there a way to determine if a Sales Order is being imported, so I can bypass VB Scripts?
  • SQL statement in VI job linking to SOTAMAS90 as source file

    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!
  • Pass through variable "Last full month"

    What is the sql statement needed to get the last full month for a pass-through variable. Scenario is: On the 10th of the month, produce a GL detail report for all activity posted in the prior month. As always thanks in advance for your assistance…
  • How to find a work ticket number by using the sales order number

    Hi! I have been using SAGE for the past couple of years now; I still cannot figure out how to find a work ticket number if I only have the Sales order number. Can anyone help?
  • Visual Integrator SQL syntax

    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…
  • Invalid expression when in advanced logic filter

    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…
  • Companies missing from lookup in rebuild sorts

    Has anyone ever experienced no companies showing in rebuild sorts? They are there for rebuild keys, etc but just not sorts. I tried replacing all the query files & dde & ddf and sy_exportlink but no luck. Tried creating a custom lookup to see if they…
  • Moving a BOM to History

    Is there a way to change an old REV of a BOM to history in order for the inactive REVs to not show on every inquiry? We have been using Sage for a long time and some of our BOMs are no longer active as we no longer build those items. We need to keep the…
  • Prevent Change to Different Division

    We use divisions and sometimes the users will copy a previous sales order and change the customer. The problem comes in that items on the sale order are coded to one division and if the new customer is in the different division it creates a problem with…
  • Sage 2014 Filter Error - Cutomer Maint - No table entry for...

    Preface: We are only on Sage 2014 for a few more weeks:...so no comments about how old it is..(smile) A user created a custom filter for the Customer Maint table which included a value which is not in the UDT (user defined table) lookup When the user…
  • Script access to SO_PackageTrackingByItem from SO_InvoiceDetail script

    I need to access values in a UDF added to Item Packaging Maintenance (Shipping Data Entry), from a header or detail script, but I can't figure out how to open that object. Trying the command Window to list methods / properties for the Lines object…
  • Is there a simple way to look up part number prices for a specific customer?

    Example: A customer calls and wants to know prices on several different parts. Is there a simple way to look up prices for their specific price level on multiple parts? Currently, I go to IM and look up the part number and then click on Price Lookup and…
  • AND & OR's in VI Select

    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…
  • Daily Cycle Counts using Sage Alerts

    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…
  • How to script an AP division number restriction in Invoice Data Entry?

    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…
  • BILL OF MATERIALS

    I'm new in the community and trying to catch up on so many things particularly the inventory management and purchasing. Is there any module that will customize the accumulation of the total component lines every sales order is entered into the system…
  • Bill of Materials Option Interaction SQL Query

    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…
  • Sage - 100 Item Search on multiple Fields

    Our Item Masters contain 130k plus items. Typically I tell our sales people to enter a "z" in the item code field, then press F2. This quickly brings up the items in the item master which start with "z". Otherwise Sage attempts to bring in the entire…
  • SQL Views

    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…