Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
'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…
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…
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…
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 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?
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!
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…
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?
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…