• Automatically Print a Picking List or Packing List

    Hi, I am new to Sage 100 Advanced (2021) as of Oct. 2023. I'm beginning to grasp the structure of Sage and how to customize it for business needs as they arise. However, one need I haven't been able to figure out is if the "Packing List" and "Picking…
  • VI Job How can I import a job with forced return?

    I am importing new item descriptions and it includes a character return (alt enter). If I enter it in the file, it causes the entry to error out when imported. Is there another way I can import it or will we have to go in and manually enter the hard return…
  • Linked UDF Description Field

    How would I go about adding a description field that displays the corresponding description record for a UDF? Does this require scripting or can these be linked in Custom office? I dont want someone to be able to select available descriptions from the…
  • Pay stubs

    I would like to add the Company name on all employees pay stubs. Is there an easy way to do this?
  • Editing a UDF field in SO Invoice Data Entry after going thru Shipping Data Entry.

    I've added a UDF to display the customers shipping acct number in Sales Order Entry. But I've run into an issue where the field can't be edited in SO Invoice Data Entry or Purchase order entry. I can however edit in Shipping Data Entry, but the changes…
  • ADD a UDF table to an existing ALE

    I created a UDF Table with 3 UDF fields in the Inventory Module (see photo). Is it possible to add this UDF table to the Inventory Maint./Inquiry ALE look up on Available Fields section see photo..
  • Custom SQL views used in custom reports

    I have created numerous custom SQL views in sage company databases and used them in custom reports, added to custom reports, and module forms. I just did the same for a customer and cannot print/preview the report from the custom report's menu. The error…
  • Error 20 Program SWQUERY

    Have an install of Sage 100 v2022.2 Advanced and trying to link a UDF to a UDT for a lookup. When click on the magnifying glass it errors out with error 20 program SWQUERY Line 0504. It doesn't matter what module I add a UDT or the size that error appears…
  • VI import limits data that can be imported

    I have a VI job that imports in to a UDF associated with the IM_ProductLine table. One of the UDF's; "UDF_LIC_ROY_DUE" is a number masked to two (2) digits. It is intended to hold a number between 1 and 31, representing the day of the month payment…
  • How to print Extended Description on Sales Orders?

    I was unable to find anything online, how can I print item's extended descriptions so they will show up on printed Sales Orders? Or alternatively how can I increase the 30 character maximum that the SOs will currently print? Thank you for the help.
  • Custom Reports running so slow on workstation

    I made a custom report with Business Insights. Pretty simple report, shouldn't be a big deal. But every time I try to make a custom report, it will run very fast on the server. As soon as I try to run it on a workstation, it takes forever and ends up…
  • Crystal Report using Access database in MAS menu gets an error

    Hi, I built a report in Crystal that they can input several item codes and it returns who has bought those items. It was added to the MAS menu AR custom reports. I had to build Access databases and custom ODBC to run the report. Its worked for a long…
  • Tiny Font in Sales Order Entry Lines

    I am working on an issue after a new a install of Sage 100. The font on the Sales Order Entry Module is tiny. ( See attached Pic ) . I have adjusted the resolution and scaling in Windows. But this has not made any difference. All other Sage modules and…
  • MAS_SCR_USR is user name, what is password in client script

    When use client side script, MAS_SCR_USR is the current user log on, what is the current user password constant, in my client script, it will also run an external BOI app, needs current username and password to pass to it. Thank you
  • SAGE 100 - Can I create a pop up alert in "Invoice Payment Selection" Process?

    SAGE 100 - Can I create a pop up alert in "Invoice Payment Selection" Process? I need to set a particular reminder about a vendor every time I do a check run.
  • Add Order Type to Sales Order Entry

    Is it possible to add a different drop down under Order Type in Sales Order Entry? We are wanting to add a drop down for Retainage and invoice those separately and under a different A/R G/L number. Thank you!
  • Crystal Report Balance Calculation Error

    Hello, In our current table " AR_AgedInvoiceReportWrk" has a field called balance however, it is not calculating the customer balance properly. If I create a formula the properly calculate the balance would it be: if {AR_AgedInvoiceReportWrk.Balance…
  • How to Only Fire a Script on Manual Change of the Field

    Hi, I have a script for the "UnitPrice" field in Sales Order Detail that triggers an alert if the price seems incorrect. I also have another script for "QTYOrdered" that occasionally modifies the "UnitPrice" field. The issue is that this second script…
  • Crystal Report Formula

    Hello, I am hoping someone could assist me with a formula I'm trying to create. The UDF field I created for our users displays in numbers but I want to create a form that if the number displayed is x then it should display y. For example, "If {SO_OpenOrdersWrk…
  • Event Script - Get child handle from a child handle?

    Probably not, but just asking. I have a script attached to the SO_SalesOrderDetail object. I'd like to reference a UDF attached to the Product Line of the line's item code - Ideally I would use child handles to avoid the need to give all users view writes…
  • User Defined Table fields

    I have created a user defined table with a key field name and six additional fields. I have added created a field in AR_RepetitiveInvoiceHeader so I can select the key field from my table. Is there a way I can also show the other fields in the table on…
  • Trying to create global custom lookup

    I'd like to create a global user lookup via the User Lookup Wizard for a very particular lookup - the Sales Order Entry Item Code lookup, but the Miscellaneous item version of it (the one that launches when entering '/', then pressing F2. I THOUGHT…
  • Print Copies of Picking List According to Item Quantity Per Order

    Hello everyone, I created a picking sheet form to print out as a thermal label customized to a merchant's specification. The label has two unsuppressed sections (rest suppressed), Group Header SO_SalesHeader.SalesOrderNo and the Group Footer. The Group…
  • 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…
  • How are variables passed to external VBScript files from Sage customizer

    How does Sage 100 actually pass the selected variables from customizer to an external VBscript file when a custom button is clicked? Are environmental variables set or some other method?