Add UDF to Payroll Earnings Report Selection Criteria

SOLVED

Hello,

I have been asked to add the Labor Code to the Payroll Earnings report selection grid under Employee Last Name and have this field filter the report.  I was able to add a UDF to the selection grid and the Earnings report work table.  However, I am not sure how to link them together.

I am new to scripting in Sage 100 and know this may be required to accomplish this task.  Any advice or guidance would be very appreciated.

Thanks,

Brian

  • 0

    A UDF in the selection grid allows filtering of the output data before it is sent to the Crystal Reports print engine, based on the data in that new field.

    Adding a UDF to a work table allows using that field in the Crystal Report designer.

    Neither involves scripting.

  • 0 in reply to Kevin M

    I had to use one UDF for the selection grid and one for the report, because I did not see the Employee Master UDFs in the work table.  When I try to fill in the labor code UDF in the selection grid, no data is selected for report printing.  Do I need to link the UDFs together in some way?

  • +1 in reply to bp3278
    verified answer

    Work table UDF's don't affect the selection grid, and there is no way to link them.  Work table UDFs are just for use in Crystal Reports designer.  Period.

    Each report has a "parent" table, where adding a UDF to that table will have it show up in the selection grid.  (I have no idea what that table is for that report).  You have no control over this functionality.  If your UDF is not in the list, make sure it isn't marked for Exclude from Report Selection.  (This is your only control).

  • 0 in reply to Kevin M

    Thank you, Kevin.  Your help is greatly appreciated.