Adding the "Reprint Check Stub" Checkbox to Custom Payroll Stub

I have created a custom paycheck stub and everything works great except I can't find the reprint check stub checkbox to add the to the report.  I started with a copy of the system report and modified it, but this option seems to have disappeared and I can't find the field in the database . Can anyone tell me what sql script they used to add this to the report?

  • Hi, Kate. That option is not form-specific. It's a checkbox called "Reprint Check Stub" in the 5-2-4 paycheck printing window. It's available for all check types and check forms.

  • in reply to ghollister

    Thanks but please see images. The option is not showing on the custom report selection.

  • in reply to Kate LaMare

    There is specific coding in the system checks (not the check forms) that makes a call to a function that enables the Reprint box and the sorting radio buttons. You would need to reach out to a Sage business partner who does custom reports to see about getting that code into your custom checks. Any time you see a system report where there are checkboxes and/or radio buttons, these are specially coded and cannot be modified or reproduced in the in-program Report Writer to show those elements.

  • in reply to ghollister

    I agree with Greig.  But if you figured out how to get gross to date to work let me know.  The pre-built formula pulls quarterly earnings and will always be current gross to date not back when the check was originally created.  Greig, I tried several things, is the gross to date field just not set up?  Its available to select but does nothing.

  • in reply to Char DeLange

    Hi Char. A couple of years back we updated the standard paycheck forms to a new global calculated field called payrec^ytdwge, which pulls the YTD from the payroll record instead of the employee earnings. This change would have only been applied to standard check forms, not any custom check forms. So, for custom forms you would need to change the calculated field from the one using the employee to the newer global one that uses the payroll record.

  • in reply to ghollister

    This comes directly from the system check 11b, it is not custom.  If I add just the field itself I get no results.

    IF(Payrec.Ytdgrs = 0 )THEN([Select Employ.Qt1Grs+Employ.Qt2Grs+Employ.Qt3Grs+Employ.Qt4Grs From Payrec,Employ,Payrec Inner Join Employ On Payrec.EmpNum = Employ.RecNum Where Payrec.RecNum = {Payrec.RecNum}] )ELSE( Payrec.Ytdgrs )

  • in reply to Char DeLange

    From what can see it's working. First make sure the payroll records are Computed or Posted. Then you can edit the standard Payroll Records~by Employee query in 5-2-2 and add the YTD Gross and YTD Net fields from the main Payroll Records table. Run the query and verify the checks you are printing have graduating YTD totals. I know that records that were created (like in the Sample Company) in a version prior to those fields be added will not.

  • in reply to ghollister

    I was testing in the Sample Co.  When I go into my own data it only works on the system forms, not any modified form. So I went into the system form and copied the formula into the modified form and now it works fine.  Sorry I did not notice that before.  Thanks Greig!

  • Hi Kate

    So all you really had to do was update the calculation from one of the revised system "report forms" to your check form.  Not design a whole new report.

  • in reply to Char DeLange

    Hi Char,

    The issue is that I need to modify the report, not the report form. When I copy the system report, the "coding" that produces the reprint button doesn't stay with it. I just need the coding to reproduce the calculation. I've designed in crystal for years  and haven't run into this issue with any of the Sage products before. The new customized REPORT works great, but I can only run it once with out this button. 

  • in reply to Kate LaMare

    IF(Payrec.Ytdgrs = 0 )THEN([Select Employ.Qt1Grs+Employ.Qt2Grs+Employ.Qt3Grs+Employ.Qt4Grs From Payrec,Employ,Payrec Inner Join Employ On Payrec.EmpNum = Employ.RecNum Where Payrec.RecNum = {Payrec.RecNum}] )ELSE( Payrec.Ytdgrs )