Error: "Sage 100 ERP has stopped working" when printing AP Checks in Sage 100 versions 2013 or higher
Description

Note: This issue may also happen in versions above Sage 100 2013. Or, the check form may appear to work fine in version 2013 or 2014, then intermittently fail in 2015 or 2016, etc.

Note: The error has also been known to continue to occur even if the formulas have been changed for the main check report and for all four stub subreports. In such an instance, it turned out that the form on the server (AP_Check#.rpt) was correct, but somehow the workstations were accessing a different form that did not have the changes made. All workstations should be accessing the same form on the server, so in such a situation, the culprit could be incorrect mapping to the wrong installation, or the workstation set to access offline files (files stored at the workstation) rather than the network.

Cause
  • Forms from prior versions (4.50 or earlier) use formulas that are no longer functional on Sage 100 version 2013 and later
  • Check form was modified and @LastDocument formula was removed from the form
Resolution
[BCB:1:Backup warning:ECB]
  • Considering creating a new Form Code:
    1. Open Account Payable, Check Printing and Electronic Payment, Check Printing and Electronic Payment
    2. Place cursor in Form Code field and enter name for new form
    3. Select Form Template to use (Preprinted Laser, Plain, Marbled, Dot Matrix)
    4. Select OK
      • Note: To modify the new form code, open in Crystal Reports Designer. For more information, see the Related Resources section below.
  • Considering updating the PrintGLVariable and PrintGLDistribution formulas in the existing Form Code:
    1. Open report in Crystal Reports Designer (see Related Resources section)
    2. Replace the following formula on the main check form (from Crystal ReportsView menu, Field Explorer pane, Formulas Fields section, right-click the formula, select Edit to open Formula Workshop - Formula Editor):
      • PrintGLVariable
        • From:
          • formula = StoreStringVar("PrintGL",{@PrintGLDistribution})
        • To:
          • Shared PrintGL As String
            PrintGL =
            {@PrintGLDistribution}
            Formula = PrintGL
    3. Replace the following formula by editing each subreport (right-click each subreport section, select Edit Subreport. then from Crystal ReportsView menu, Field Explorer pane, Formulas Fields section, right-click the formula, select Edit to open Formula Workshop - Formula Editor):
      • PrintGLDistribution
        • From:
          • formula = FetchStringVar("PrintGL")
        • To:
          • Shared GLPrint as String
            Formula = GLPrint
        • Note: To access each check stub subreport, double click on the appropriate subreport. Ideally, the PrintGLDistribution formula in each of the four subreports should be corrected. However, you may modify only two if desired:
          • For Stub, Stub, Check: you may modify CheckStub1 & CheckStub2
          • For Stub, Check, Stub: you may modify CheckStub2 & CheckStub3
          • For Check, Stub, Stub: you may modify CheckStub3 & CheckStub4
  • Note: Verify that Basic Syntax is selected in Formula Editor when modifying formulas in Formula Editor - not Crystal Syntax! Then, save the changes.

Note: Possible Resolution if you do not receive a prompt to update the Check Register (should not apply to modern check forms):

  • Add the @LastDocument formula field to check form


DocLink: Error: "Bank code in use by another task", "Check Printing in Process" or "Other Check Printing in Progress"
DocLink: How to add the Designer button to report or form printing task windows (to launch Crystal Reports Designer)
DocLink: How to install Crystal Reports Designer for Sage 100

[BCB:155:Chat 100 US:ECB]
Defect ID
Steps to duplicate
Related Articles