• Information libre de type TABLE - Afficher valeur dans une facture

    Bonjour la communauté, J'ai créé une information libre pour mes articles de type Table. Pour certains de mes articles, dans leurs fiches, j'ai sélectionné le choix souhaité dans l'information libre. Maintenant, je souhaite dans mon édition de facture…
  • Required UDF

    We have a required UDF in Sales Order. I noticed that the UDF doesn't seem to showing up consistently. Is there a way to fix this?
  • CI_Item Image Files

    Been reading up on ways to utilize the "Image File" associated with itemcodes. Since the actual file is just saved in the Image folder would it be possible to save an image in the folder (not through an actual item) and add a script on the SO_Detail to…
  • Copy Required UDF in Sales Order to RMA

    We have a required UDF in Sales Order. When we try to generate the RMA, it's requiring the UDF, except the UDF is not in the RMA panel. How do I go about getting the UDF added to the RMA panel? Thanks.
  • Mass Change Primary Ship To Salesperson when assigning new salesperson to customer

    We have instances where we change the salesperson assigned to our customers and I am able to use visual integrator to import those changes. However, this does not change the salesperson assigned under the primary ship to address on the customer. Is there…
  • Visual Integrator Receipt of Goods Entry

    Hello, I'm trying to import multiple Receipts of Goods Entry against open POs, but keep running into this issue - the quantity received is imported but the quantity ordered column for the PO is coming up as 0. It should pull the open ordered quantity…
  • Return UDF Descriptions

    I am trying to find a way to return the description of a UDF using SQL. I am currently using the following: Select * FROM JT_Employee But I need to bring forward the descriptions of the UDF's. So for example, "UDF_F_Name" would return "Employee…
  • Import Mass UDF

    Is there a way to import new UDFs into Sage and to place multiple fields on a panel at one time? I have 50 UDFs that need to be created and I would prefer not to have to manually create and place each one of these fields. Is it possible to mass create…
  • 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.
  • 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…
  • 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…
  • 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…
  • 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…
  • UDT in AP Invoice detail

    I've created a UDT in AP. Populated the data and then created a UDF in AP Invoice Detail. The Code field appears from the table but i cannot select it. what needs to be changed? UDT AP Invoice Detail UDF in AP Thanks for your assistance…
  • 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…
  • 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..
  • 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.
  • 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!
  • 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…
  • 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?