• UDFs in Transaction Entries

    I'm attempting to make a UDF that will appear on the 8. Cost Detail Tab in Item Maintenance and be available to report on for some government requirements. I've been able to add the UDF in IM_Transaction Tier Distribution Entry, PO_Receipt Tier Distribution…
  • Mass Update GL_Account table via SQL update query

    We have upgraded to Sage100 Premium (SQL version). We have been using a separate Excel workbook for special coding we like to use. We would now like to get all those special codes into Sage100 into the rollup codes and UDF's. We do not want to manually…
  • Can you add a UDT to a custom financial report?

    We have a business that has two locations, so we use a UDT when entering transactions to split them accordingly. In order to show separate income statements, we have been manually creating them in Excel each month. This is tedious and leaves room for…
  • UDF is Added to SO Detail but Doesn't Display on the Screen

    UDF is Added to SO Detail but doesn't display on the screen. Verified the UDF is not marked as hidden. Below is what I tried so far: Removed all of the UDFs from the SO lines panel. Deleted the ###-### and all other folders from the SO\custom folder…
  • What is the 'best' way to auto populate "UDF" City and "UDF" State from "UDF" Zip Code

    I am currently using the following (which works), but is there a 'better' way to do this? (I don't like hardcoding the connection string with username and password.) '-------------------------------------------------------------------------------…
  • Customizer salesperson UDF

    Is it possible to create a field (UDF) that replicates the salesperson lookup using business object fields for salesperson? I need to add this secondary salesperson lookup in AR_Customer and SO_Shiptoaddress. I was hoping against hope that I could do…