• Crystal Reports 2020 Database connection Error

    Have a client that upgraded from Sage 100 2019 to Sage 100c Advanced 2023 PU1. They run several reports outside of Sage using Crystal Reports Writer version 2020. They can run these reports with no issues some of the time, but then later in the afternoon…
  • Sage 2021 PU2, PR 2.21.3 Upgrade - Have to re-add Payroll Custom Reports with PII Wrk table from 2018/2019?

    Howdy - I have had 3 separate upgrades where the client is upgrading from 2018/2019 with fairly recent Payroll updates (2.21.1 and greater) to Sage 2021 PU2 with PR 2.21.3, and after data conversion, if they have any Payroll custom reports from the previous…
  • Crystal Report Page Layout not previewing any width greater than 8.5"

    I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name. I added the Sales Report…
  • Custom payroll history report never stops running.

    I've tried converting a custom 401k report from v2017 to v2019. In v2019, the new report never stops running. The selection criteria allows the user to specify a beginning and ending check date, and choose a pay cycle. It doesn't seem to matter how…
  • Payroll Deduction Report for a specific date range?

    Prior to payroll 2.0, there was a Consolidated Deduction History report under Payroll -> Reports -> Deduction Reports. This report allowed the user to specify a specific date range for the report. We would use this to report on deductions for a single…
  • Sage 100 ERP 2013: How to generate a list of all accounts that have special pricing methods set, like price overrides, price discount amounts, etc.

    Hi everyone, I'm wondering if anyone knows how to generate a list of all customers that have special pricing methods set, including: Cost Markup Amount, Cost Markup %, Price Discount Amount, Price Discount % and Price Override. The one that's chiefly…
  • 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…
  • Historical AP Aging for YE doesn't match GL Balance

    I had this same problem last year. My AP Aging for 12/31/13 does not match the GL Balance for AP at 12/31/13. I checked the setting in the report parameters to exclude future dated transactions but they still do not balance. Could someone help me with…