Sage 100

 View Only
  • 1.  How to print fields from GL_MICR on blank check stock for AP checks in v2019

    Posted 10-16-2019 19:33
    We have a AP check template some of our clients use for printing checks on blank check stock.  We do this with a subreport using address and comment fields from GL_Micr.  The field used for linking the work file and the subreport is the Bank Account No, which is now PII.​  Data does not display on the check forms, even with permissions to view PII.  How have others solved this problem?

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------


  • 2.  RE: How to print fields from GL_MICR on blank check stock for AP checks in v2019

    Posted 10-16-2019 21:35
    I have a real check with most everything suppressed and have them do a bogus manual check and delete it.

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 3.  RE: How to print fields from GL_MICR on blank check stock for AP checks in v2019

    Posted 10-17-2019 14:12
    Edited by Barbara Goldstein 10-17-2019 14:12
    I got it working by creating a UDF in AP Check work file, pulling the GL_Micr bank code data.  Use the UDF to link to bank code field in the  subreport so I can access the address fields viewed in Bank Code Maintenance.  Seems odd to me that the address fields "live" in Gl_CheckMicr rather than in GL_Bank.

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------