• Error Unable to draw Folder control - Issue with customized panels in 2022 Product update 1

    Receive an error message - unable to draw folder control on any customized panel where an extra tab has been added.  It works in 2022.0 but errors out after installing PU 1.  Deleting and recreating the tab in version 2022.1 works.  I'm working with Sage…

  • UDF PO ROI to AP_HistoryHeader & AP_TransactionPaymentHistory

    I created a Date UDF in PO Receipt of Invoice. it populates correctly. I'm trying to get this data into the AP_InvoiceHistoryHeader & AP_TransactionPaymentHistory.

    I've tried several links and can't seem to get the correct combination.

  • UDF's in A/P

    I have created a UDF in A/P Invoice Header to hold a document number (separate from the invoice number) on our A/P invoices being imported from a 3rd party solution.  That will work for invoices being created now.  What would be the best way to update existing…

  • One to many relationship

    Looking for opinions on if the the one to many scenario in Sage 100 can be created with Custom Office: one item # to many different models for example. The goal is to be able to search a model # and see all the item numbers that are compatible with that…

  • ALE Inventory

    User selected all fields and made the lookup default.  Lookup no longer works.  Gets a message "No table entry for file CI_UDT"

    Does anyone know how to make this "NOT the default" and then we will have access and can delete:

    Or is…

  • Adding a button to Sales Order Entry to print a specific picking sheet form type

    We have different types of picking sheets that we use and print multiple types per sales order. Everyone always forgets to change the form code so we waste a ton of paper. Is there a way to add another button to the Sales Order Entry page to open up a…

  • Modifying Order of Secondary Grid Lines for All Users on Sales Order Module

    I'd like to modify the order in which lines are displayed in the secondary grid in the Sales Order Module (Sales Order Entry). 

    We have several UDF's in that grid, but I am having trouble seeing the list of fields within that secondary grid. Using…

  • Sage 100 2018 Customizer question PO Receipt of Goods Date UDF to post thru to IM Cost file

    Sage 100 2018 Customizer question

    All Inventory items are FIFO Valuation

    Client wants a Date UDF added to the PO Receipt of Good Lines

    I added the Date UDF to the PO Receipt of Good grid

    I need to know the steps on how to get this Date UDF to post thru to…

  • SO entry screen

    We just did the SAGE 2021 update and something all of our people are finding an issue with is  In SO entry screen under the lines tab we used to be able to have the columns in the order we wanted and have what we wanted to see and it would remember it…

  • How to obtain Quantity of Items Sold and Issued with Custom Date Range

    I am trying to export a report, by vendor (or product line), of the quantity of items sold AND issued for the last 12 months. We would like to be able to export it using any custom date range that we want. What is the best way of getting this data? I…

  • UDFs no longer alphabetical in Selection on reports - Exclude from selection

    Hi Community,

    We have just upgraded a customer from V2015 Standard to V2020.1 Advanced and I have noticed that the UDFs in the selection grid on reports are no longer in alphabetical order - we have a couple of UDFs (12) but in the selection grid without…

  • Can't figure out Event hook

    I have a script for Item Maintenance that is connecting to Item Warehouse, summing up QtyOnHand and then writing it to a UDF on the Main Panel.  The script works when I can get it to run, but I am having trouble figuring out which Event I can associate…

  • Issues opening Sales Order with Script Sales_Order_UI

    I have used this code for years me and a handful of others, but we have a few new users that are having issues and can't appear to use my app to open Sage Sales Order.

    The only indicator they get is SO_SalesOrder_UI in a message box.

    Here is the…

  • Validate field to UDT

    Created a UDT for customer type and now trying to set validation on CustomerType field in AR_Customer to my UDT for customer type. It will only let me do this if I choose all users, all companies in advanced field settings. I don't want this validation…

  • 2016 - 2020 First oScript.SetError Method doesn't trigger an error message in Lot/Serial Number Distribution

    This UDS is a Column Pre-Validate on QuantityShipped against the SO Sales Order Tier Distribution table at version 2016 Std through 2020 Advanced. The SetError doesn't always trigger the error message, but it does fail (i.e. clear) the distribution number…

  • UDT table name vs UDF field name

    I am just curious on the best practice for User Defined Table name vs a User Defined Field name that has the UDT linked to it.  I have made both of them the same name in the past but i was talking to someone the other day that stated they usually make…

  • How to add Quantity Ordered and Back Order to Additional Packing List

    Is there a way to add the Quantity Ordered and Back Ordered fields from either the SO_InvoiceDetail or SO_PackingListWrk tables to the SO_AdditionalPackingListWrk table?

    I've tried creating an UDF via CM under SO Additional Picking List Work, but I only…

  • Changing a date field on a new line with an unrelated Pre-Write script also changes that date's format - confuses customer

    I discovered that if a date field (e.g. PromiseDate or ExpirationDate) is changed on a new SO or PO line with a Pre-Write event that also sets any other value in that line, the screen format of the changed date for that line also automatically changes…

  • Increase size of Item Maintenance Screen

    I need to increase the Length of the Item Maintenance screen to accommodate a large number of UDF fields that will be entered on a new tab.  I have never been successful at doing this.  I usually get error 65 once it's done.  Is there a special trick…

  • Connect multiple UDFs so selecting one will display extra info to be used in Crystal Reports

    I added a tab to my Invoice Data Entry panel with UDFs

    I want to be able to select an option in "SCAC Code" which will then display the proper name of the carrier outside of the SCAC Code dropdown. I want the SCAC Code and CARRIER NAME to be…

  • UDF's on old tables

    Recently upgraded client to v2019 Adv. They wanted some UDF's cleaned up and I am seeing these fields from the report on older tables that are no longer available. How can I clean these up so they do not show on the report anymore? The report I am referring…

  • How to get Child or sub file (table) level data from Sage VB Script

    Hi All,

      I need to display a message box on Shipping Data Entry interface.  I can get data from "SO Sales Order Header"  and "SO Shipping Data Entry" and "Customer....".

    On Custom Office using trigger of ""SO Shipping…

  • Can't add Employee Deduction UDF to data entry

    I've added a field to the Employee Deduction file for the garnishment account number.  Added it to the Deduction tab screen, but then realized I can display it there just fine, but I can't ENTER it anywhere!  Can't modify the Deduction ENTRY screen…

  • How to Differentiate Between Inquiry and Maintenance Panel in Script

    I'm writing a script to expose or hide selected controls based on user.  I would like the script to be operational ONLY in Maintenance mode, not Inquiry.  In the script, how do I identify whether the panel is in Maintenance or Inquiry mode?

  • Accessing Business Objects with a Client side script?

    Hello, 

    I have a script complete that runs a SQL Query and returns the results back in a MsgBox. The very last part I need to do is access the Sales Order Number to include this in my "Where" clause for my Query. 

    This needs to be run on the…