• 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…
  • Sage 100 PM WT Traveler Crystal Report - Steps Repeat

    Hi, Hoping someone knows how to get the details sections of a crystal report to not repeat the same values as I can not have step instructions and signoff information repeat I moved things around in the PM WT Traveler report that came with the install…
  • Sage100 Production Management Crystal Report for Work Ticket Traveler

    I am looking to add the Routing (now Template) description to my printed Work Ticket Traveler. I want it to appear in a header section of the crystal report. The routing description is now step 000000 of the route instead of its own field. How do I get…
  • 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…
  • Trial Balance Report "Hangs" for a specific customer selected?

    Hello, We are having an issue with the AR trial balance report. If we run this report without specifying a customer, and leave the Customer Number field set to All, the report runs fine. However, we have a specific customer we want to run this report…