• Information on fields from Wrk tables? Needed for Knowledge Sync.

    Hello, I'm looking to re-create a Crystal report so that it can be run by Knowledge Sync. I initially wanted to just use the report provided by SAGE, but it looks like I can't use this report as the information the SAGE report pulls is only generated…
  • SQL Table for batch history? AKA Batches not located in GL_CompanyActiveBatch?

    Hello, I am creating a report for our accounting department which shows all A/P batches that either remain open, or were created today. I have the first part, where I can pull up all active batches through GL_CompanyActiveBatch. However, I am having…
  • Crystal Reports not the same version for Sage 100 and HRMS

    Sage HRMS uses Crystal Reports 2011, which is the latest version of HRMS from Sage. Sage 100 2018 uses Crystal Reports 2016. How can I get the crystal reports to work when both Sage products are installed on the same computer?