Sage 100

Sage 100 2016 client is using Job Cost. They have a user defined field on the Job Cost Header for Jurisdictions for required reporting. It is a Drop Box. They have reached the maximum space allowed for the values in the validated list. I know this because they get the following message. ""The maximum space allowed for list box and drop box items has been exceeded. The list has been automatically truncated to 900 bytes."" I have tried to add a User Defined Table to the System and then validate against this table without success. Anyone have an answer to this other than shorten the current values and prune older ones no longer used?

I do not believe you have any other option with legacy modules, Larry. You could get a master developer customization to do it, if the cost is justifiable.

So, where I am going is to add a UDT to the System and then add a button in JC maintenance that calls that UDT Maintenance. The table would be Job Number and a separate field for Jurisdiction. Jurisdiction is validated off a secondary table to ensure uniqueness and control. I tried to call it using ""program"" but Custom Office is not one of the listed programs. I am thinking I need a script to call the UDT Maintenance for that specific UDT. Any thoughts? @AlnoorCassim

JC is legacy. UDT's and scripting don't work in legacy.

Ye of little faith. I understand it does not work directly. I am looking for options.

What would you do once the correct UDT Maintenance screen is up? Are you expecting to ""select"" the appropriate record from that grid and have it stored it into a UDF? Going back to your original question, from a Custom Office button there is an M/D hook for Perform Logic (yes Perform Logic is not just for V/I) and that could be coded to open the correct UDT Maintenance grid (but what would you do with it once that grid is up).

I want them to be able to go to Job Maintenance and while creating a new Job click a button that will pull up the grid for the Job/Jurisdiction UDT so they can add the Job Number to that Table and select the appropriate Jurisdiction.

I don't need to write anything back to Job Maintenance as I will link the JobNo in Job Masterfile to the JobNo in the UDT.

How about a VB script to call a shell command of the specific grid in UDT Maintenance?

Thanks for explaining the purpose. No not VB Script in this case. The button based Perform Logic is best.

So, I would need the MD and the Perform Logic? Which MD? You interested in the Perform Logic?

If you like I can yes. So can @MarcosDeluna @RandyMarion @LeeGraham @PhilWhirley and others I'm not remembering.