Sage 100

 View Only
  • 1.  Installed Sage 100 ERP PU 8 so that we could updat

    Posted 12-30-2014 09:53
    Installed Sage 100 ERP PU 8 so that we could update with the IRD. All appeared to go well except today the PR person called with ""Error 29 Program SWPROM Line 2225"". This turns out to be a problem with the MICR formula and oddly enough it occurs during conversion and even if the MICR formula is not on the check. Once I changed the MICR formula as per the info below --- the problem went away. The customer was on 2013 previously so I'm a bit stumped as to how this issue crept into the process simply by loading a PU. The only thing I can think of is maybe the form upgrade utility has changed so it now also scans all the formulas in the form and will prompt for update even if the formula is not on the check. I opened the form in Crystal first and did a verify database and did not receive any errors or notices to update any fields (which leads me to think Sage changed something in their form upgrade procedures). Here's the fix you need to make to the MICR formula (remember you do have to change it even if it's not on the check): Even if the form code does not include MICR field, the conversion still verifies all formulas are valid. I think you can fix it by copying the appropriate formula (either 4.3 or 4.4-2013) from below: Modify MICR field formula in existing check form: Highlighted below all the field names that changed after version 4.30. 4.30 if {GL_CheckMicr.MICREnabled}=""Y"" then {GL_CheckMicr.CheckNumberPrefix}+{PR_31CrystalCheckHeader.CheckNumber}+{GL_CheckMicr.CheckNumberSuffix}+"" ""+{GL_CheckMicr.RoutingTransit}+{GL_CheckMicr.AccountNumber} else """" 4.40, 4.50 and 2013 if {GL_CheckMicr.MICRPrintingEnabled}=""Y"" then {GL_CheckMicr.CheckPrefix}+{PR_31CrystalCheckHeader.CheckNumber}+{GL_CheckMicr.CheckSuffix}+"" ""+{GL_CheckMicr.RoutingNo}+{GL_CheckMicr.BankAccountNo} else


  • 2.  RE: Installed Sage 100 ERP PU 8 so that we could updat

    Posted 12-30-2014 17:23
    I just did a 4.3 to 2014 upgrade and ran into this. I just commented out the formula, since the client doesn't print MICR.


  • 3.  RE: Installed Sage 100 ERP PU 8 so that we could updat

    Posted 12-31-2014 14:46
    Sage duplicated this problem. They don't know why it is happening.


  • 4.  RE: Installed Sage 100 ERP PU 8 so that we could updat

    Posted 12-31-2014 14:57
    What a surprise that they don't know what is happening. But at least they have seen it for themselves...


  • 5.  RE: Installed Sage 100 ERP PU 8 so that we could updat

    Posted 01-02-2015 07:32
    I did a 4.4 to 2014 (two) and did not encounter this.


  • 6.  RE: Installed Sage 100 ERP PU 8 so that we could updat

    Posted 01-06-2015 14:09
    Ran into this again on a 4.3 to 2014 upgrade - the problem was only in Payroll checks and not Accounts Payable. Making the change to the MICR formula fixed the issue.