Sage 50 2016.2 and Crystal Reports

If you use Sage 50 2016 - US Edition, and you run any custom Crystal Reports that utilize the GETPEACH formula, DO NOT LOAD THE 2016.2 UPDATE! Loading this update will break Crystal Report's ability to calculate any formula value that pulls from the GETPEACH file. It is unknown, at this time, if Sage is going to address this issue as their position is that they no longer support Crystal Reports. I'll post any updates as they become available.

  • 0

    SOLUTION FOUND: Any time a Sage 50 update is installed, which requires a conversion of the database, make sure that in addition to resetting your Crystal Reports User Security Settings, that you also click on the "Install Sage 50 Data Functions" link to the right of the screen. This will update the u2lpeach.dll file with the new Sage 50 Data Functions, which directly impacts Crystal Reports. After doing this, I have now found that Crystal Reports which use the GETPEACH file (this accesses the u2lpeach.dll file), now appear to be operating correctly.