• Customize Employee Maintenance Screen with "Tabs"

    Hello, I am hoping to find a way to add a tab (or a few) to the "Employee Maintenance" screen in Sage to allow for more fields to be added under different department specific details. Running Sage 100 Premium 2021 (Sage Version 7.00.2.0) (Payroll…
  • User Defined Script for Sales Order

    I am calculating a UDF (by script) on each SO Line. I need a script that will accumulate those Line amounts and save it to a header field. I'm hoping some smart guys knows how to do this.
  • Barcode Usage with BOM in Shipping

    We use Sage 100 Advanced 2023. We have an item, Honey Straws that we make up into 50 packs to sell. We buy these in boxes of 2000. There are about 2 dozen flavors we offer, but for the examples, I will use Apple as the flavor. All items have similar setup…
  • 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…
  • Designer Report

    I am new to designing reports in Sage 100. Is there a good YouTube video or documents on this? I just need something simple for an audit (employee name, job title, gross wages, and overtime wages).
  • Open Sales Order Report - Filter fields

    The Sage 100 Open Sales Order Report has a list of stock criteria fields, and some fields we added using custom office..see attached. Are we able to add additional standard Sage fields to this list eg; CustomerPO?
  • Default Bill Value to Single Level Report

    Hi... I'm trying to find a way to add a value from the bill of materials bill number field in bill of materials maintenance to autopopulate the bill number when you run the Single Level Report from the screen. As it works now, the report will appear…
  • Script for Auto-Updating UDF on Kit Lines

    We have a UDF "Total Quantities" that we use for Kit items to show the total quantities of all the components. Currently, we manually sum the quantities of the component lines and enter this into the UDF "Total Quantity" on the Kit line. I need help…
  • Missing Labels/Controls from Panels After Panel Modification

    We are having an issue where control labels are missing after panels have been modified. This is occurring for labels/controls that were not part of the modification. As a result, we have to keep continuous backups of our panels and roll these back in…
  • How to have a script on the Sales order Header trigger another script on each detail line?

    I added a new script for all new orders on the sales order detail to fire on the column post validate of "Item Code" My concern is for any old quote that will be changed to an order and will not have the script run, how can i add a script on the Header…
  • Sorting Sales Order line by Item Code

    Hi, I have a request from a client to sort the Sales Order Lines detail section by Item Code. I feel like I should be able to do this with a script, but not clear on what Object to reference. Can someone give me a hand, perhaps point me in the right…
  • exporting invoice detail lines

    is there a way to export the line details on current open AR invoices. When I use Business insights the current open AR invoices just give the balance of the invoice not the line detail for those invoices. If I use invoice history I get more then open…
  • 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…
  • Sage 100- Print Customer type on packing slip

    I am looking to print the customer type on the picking sheet. I added the AR_Customer table to the database, used a left outer join. Added the Customer Type to the crystal form (browsed the data-I could see the customer types) BUT when printing it does…
  • 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!
  • Multi-Part Form Picking Sheets

    We print large batches of picking sheets a couple times a day, when this process is run the printing prints all of the picking sheets form 1 first, then goes back and prints the second form for the picking sheet. The process is run on 20-100 sales orders…
  • How to have Copy From not copy UDF field value

    Is there a way to setup a UDF so that when the Copy From button is used on a record to copy values from an existing record to a new record that the UDF field value is not copied? For example, in Inventory Management, if we have a UDF field to store…
  • Conditional field suppression in Crystal Reports

    MN has enacted Safe and Sick pay that must show on an employees paystub. I have added this field and label to the DD stub but do not want it to print for employees that are not in MN. The hours are helfd in time off 2. How can I suppress this field from…
  • Row and Bin by Distance for the Picking Sheet, is this possible?

    We have 170+ rows and they are separated into 4 different groups of rows. First group of rows is 1-54 and behind that one is 108-55 and then 109-138 & 162-139. We could have a order that has an item that's on row 1, row 54 & 108 for example. If they pull…
  • Can you auto-generate comments on Sales Order lines?

    I need my team to be able to see certain information on Sales Orders for a few product lines - is there a way to auto-generate comments on those products? Or would it be easier to implement extended descriptions to SOs instead?
  • UDF numeric mask ending "-" warns of too many decimal places?

    Create a numeric UDF, and edit the mask to include a trailing "-" (so negative values are accepted and displayed properly). #,###,###.000- This presents a warning about too many decimals / rounding, when I am clearly not exceeding three digit decimal…
  • 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…
  • Crystal 2020 No Longer Includes MS Access, Excel, or Text Connectors

    There are additional efforts to use Crystal Reports 2020 (@Sage 100 2023) with MS Office or text files. I have Custom Reports that include links to Excel and MS access. Without the native connectors we will have to use downloaded add-ins. Does anyone…
  • Attempting to import multiple POs into the same Receipt - Next isn't working.

    I am trying to import multiple POs into the same Receipt of Goods. I chose Next for the Receipt Number and pointed it to the field I want to use to determine the change, but apparently it ignores that and changes whenever any header field changes, i.e…
  • 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…