• Sage 100 2022 Premium Crystal Reports Database Login Failed. Unable to connect: Incorrect log on parameters

    Hello I'm upgrading from 2018 Advance to 2022 Premium. When on the server we can run canned reports within Sage 2022 without error. When we try and run reports from a client 2022 workstation we get "The database login failed. Error in File GL_ChartofAccountxxx…
  • 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…