• Crystal Reports 2016

    With Sage 100 2018, Crystal Reports Designer 2016 is now included. Sage warns us to uninstall all existing Crystal Reports Designer versions prior to installing CR 2016. This is the warning from a KB article: Caution : Avoid using incompatible versions…
  • Filtering not working on Crystal Report

    Good day all, We have a system that uses Crystal report for .NET frame 4.0 it used to work fine on that computer. For instance, We normally filter by location, date, and other parameters report would bring up the correct information respectively.…
  • Creating a Crystal Report for SO Form Code in Sage 100C Advanced 2017. Cannot find a specific field in the database options.

    I am specifically looking for the field for the SO line items comments on the lines tab of the Sales Order Invoice screen. We print a pack-list form code and would like to be able to include comments from each line. I have tried all the fields in Crystal…
  • Workstation installation error.

    Hello I am trying to install in a client computer sage 100 advance V. 5.30.2. but I do have this error. I did try to find something in the learning center but I could not find anything. how to solve this problem Thank you.
  • "index was outside the bounds array" error

    i got this error when i was trying to import from sage to excel "index was outside the bounds array" any help? thanks
  • What Crystal Runtime versions are used with Sage 100 (Advanced) 2014 and 2017?

    Is this info recorded anywhere in Windows registry or elsewhere on the client PC?
  • Question about Bill of Materials and Crystal reports

    My client is on Sage 100, 2014 Product update 7. Currently, I am trying to write a Crystal report for Bill of Materials. I need to have a field brought n that is the current bill or default bill for the bill of materials. I can pull the bill of materials…
  • Sales Order Module

    Is there a field in any table that is used for the date updated from Quote to Sales order?
  • Database login failed...issue with system.data.dll

    We are utilizing Sage ERP 100 premium 5.10.40. I have one workstation that keeps getting the following error any time they try to print or run a report: "The database login failed. Could not load file or assembly 'System.data.dll' or one of its dependencies…
  • Inventory Table

    I have a Crystal Report that pulls from table IM9 - Item Sales Detail Warehouse. Once we upgraded to version 5.0 of MAS100, the report no longer works because the table no longer exists. What table should I be using in place of IM9? Nothing is jumping…
  • Crystal Reports XI R2 Upgrade to CR 2008

    Hi. Does SAGE 100 ERP Support Crystal Reports 2008. If it does, how do I upgrade? I want to take advantage of the additional functionality, "Calculated Members" in cross-tab reporting Thanks. -Sol
  • Crystal Report Error: Unable to print PRWFXAH.rpt. The Device is not ready.

    We just upgraded to Sage 100 ERP from Mas 200 and I got this error this morning. I'm not familiar with it. I've looked through a few areas for help, but haven't found any solution thus far. I'm hopeful that someone has run across this issue before.
  • Error installing workstation.

    I think i put this in the wrong group initial so I try this again We had Kissinger Associates install/update our old mas 90 to Sage 2013, I am thinking that was a big mistake as we have had nothing but problems with the new install,but that another story…