Sage 100

 View Only

  • 1.  Added UDF to AR Invoice History Detail table - The column () is not in the IOList

    Posted 11-04-2025 17:34

    I added a UDF to the ARInvoiceHistoryDetail table today.  While VI'ng data into the UDF, I encountered the error below (the field was in the VI import list).  DFDM'ing the table, the UDF does not exist.  Is it a matter of waiting for the tonight's invoice update before seeing the field in DFDM?  Or should I just delete the field and try again?  Is there a way (easy) to rebuild the data dictionary?

    TIA



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------


  • 2.  RE: Added UDF to AR Invoice History Detail table - The column () is not in the IOList

    Posted 11-04-2025 20:50

    Open the table again, open the column, edit something simple (like the description) then run the Update.  This should force the field definition into the table properly.

    Specifically do not save UDF changes for update later on Premium.  The multi-update feature doesn't work.  You must update one table at a time, from that table's Update button.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Added UDF to AR Invoice History Detail table - The column () is not in the IOList

    Posted 11-04-2025 22:02

    I just deleted the UDF, rebuilt the table (as a precaution) and then added the field back.  2nd time was the charm.  Thanks



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444

    Improving bottom lines for over 25 years!
    ------------------------------

    Original Message


Related Content