• 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…
  • 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..
  • Populate UDF with existing data

    How do I populate a UDF with existing data? New records add the data just fine, but I have a lot of existing data, too. Thanks!
  • 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 customizer…
  • 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…
  • Totals UDF miscalculating during AR Repetitive Invoice Selection

    Hi all, not sure if I have gremlins or have missed something. Running Sage 100 Advanced 2018, I have created two numeric fields in AR_RepetitiveInvoiceDetail that automatically sum to Totals UDFs in AR_RepetitiveInvoiceHeader: so far so good--amounts…
  • Generate PDF from UDF and create save/email functions from Sales Order/Invoice Data Entry custom tab

    Hello everyone, I created an extra tab in Sales Order/Invoice Data Entry and I have a few questions: Most importantly, how can I use the data that's selected and inputted here to generate a PDF or other type of document? Each of these fields is built…
  • Additional header tab to a screen via custom office... say SO Entry or PO Entry?

    Is there a way to add an additional header tab to a screen via custom office... say in SO Entry or PO Entry? Then populate it with whatever we want?
  • How to create custom UDFs in PO or SO memo?

    We are in version 2016, and want to customize the memo in both Sales Orders and Purchase Orders. I see an old post from 2010, but no further information on this or if it is even possible on today's versions.
  • How to use the same UDFs in PO ROG and IM Transaction Entry

    I have nearly 30 UDFs in PO Receipt of Goods Detail file and linked to posting/update files, work files and history files. These are working great. Staff wants these same UDFs to appear in IM Transaction Entry for Receipts for those items without a…
  • String Type UDF with Mask displays zeros when editing data

    I'm trying to create a mask for a string UDF that displays <blanks> for missing characters. If I use 000 000 000, the empty field displays the zero mask even when the field is empty. This is confusing as there's no way to tell if the entry is truly 000…
  • UDF's - Validating Letters to Words

    If I want to add a UDF similar to the Product Type, how can I have a list of descriptive options in the field drop down but only store one character in the database? As an example, Product Type has 4 options - Finished, Raw Material, Kit, and Discontinued…
  • The record is not in an editable state

    I am trying to remove the user defined fields from the sales order entry form. I removed the fields from the customization panel, deleted the customization, deleted user defined fields, rebuilt customizer log, updated custom panels to current level, rebuilt…
  • Error# 1: LOGICAL-END-OF-RECORD reached

    Hi, I am trying to customize sales order entry form and I get this error, I believe it is due to the amount of data I am putting into the table. I was able to get rid of the error, by reducing the number of User-defined fields considerably. But, I am…