x Want to participate? Join the group to interact
  • Replies 11 replies
  • Subscribers 142 subscribers
  • Views 1915 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
9k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
16
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
Kate LaMare

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

Posted By

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?

Parents

  • 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 )

Reply Children
No Data

*Community Hub is the new name for Sage City