• Crystal error when running reports

    Fresh install of Sage 100. I ran the installer as domain admin as well as the WksUpdate Standard file. I have already tried reinstalling the software over 5 times and verified all necessary files were present in the C Drive file path. Is there any other…
  • AP invoice and the AP Trial Balance Report compared to the GL

    Hello, I ran the AP trial balance report for January and compared it to the January GL. I discovered it didn't match. I found out that someone had entered a January invoice into February. Then to correct it, they adjusted the invoice to 0 in February…
  • Previous employees on Vacation report 5-1-8-86

    On report 5-1-8-86 How do remove old employees from the report? Some of these employees have not been employed for quite awhile, but still show, even with a zero balance.
  • Oregon Corporates Activity Tax Report

    HELP! What reports are you pulling/printing to do the Oregon Corporates activity report? We are a WA. based business, but we also do jobs in Oregon. Need to be able to separate the states or tax district. What I'm looking for is a report that will…
  • Full Inventory Inventory List w/filters

    Hello fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…
  • (REPORTING) How to link invoice line items to GL Detail Posting?

    Hi all, We do most of our customer reports based off the GL_DetailPostings table. I have a few reports filtered to only show "SO" module transactions and I pull in some additional data from the InvoiceHistoryHeader table but now am being asked to…
  • 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…
  • Inventory Valuation report Sort question

    I'm looking for assistance on an Inventory Valuation Report. I'd like the report to sort via valuation. The highest values descending to lowest. I can't export to Excel and sort that way because of serial numbers. Does anyone have ideas on how to…
  • Automated Inventory Reports

    Hello, I am looking at sending an automated monthly report to a customer with a list of the items they supply us. If possible, I also wanted to provide a breakdown of any work orders, inventory adjustments, etc against each item. Is this report possible…
  • SAGE random pdf export cannot be opened

    Hello, We are having an issue with exporting reports to a pdf file. Random reports will not open and acrobat gives the message "Adobe Acrobat could not open 'name_of_file.pdf' because it is either not a supported file type or because the file has…
  • 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…
  • Print List of All Jobs from 2015 - present -

    Please forgive me if already answered somewhere, but I could not find it. Sage 100C - I need to print a list of all jobs from 2015 - present. Just need the Job Number, Job Name, Job Address. This should be so simple, but I was not able to find…
  • Unable to print this report while a G/L update is in process

    I'm trying to run a report in one of my Sage companies and I'm getting the following error message "Unable to print this report while a G/L update is in process". I've been getting this error message for over one 24 hours. I also checked with my colleagues…
  • 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…
  • Intelligence Sales Report does not tie to P&L

    When I run a standard Customer Sales report in Intelligence for a month (Nov in this instance) it does not tie to the PL or sales recap report . Intelligence is typically higher than the PL. I can trace it to a specific product line but I don't see anything…
  • 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…
  • I want to print an Accounts Receivable Invoice History report sorted by Customer Type.

    I need to print an Accounts Receivable Invoice History Report sorted by Customer type. I have created the UDF for Customer Type and added to all the work and history files. When I run the report just selecting invoice dates I get my report showing the…
  • RECEIVED PO / MISSING INVOICE #

    Hello, Is there a way to show which PO's that have been received in are missing an invoice? We just switched over from Sage 50 and when the warehouse would receive material in, they would check off the box "waiting on bill". That way I could then just…
  • Print SO Line Number on Packing Slip & Invoices on crystarl report

    Hello Everyone, Looking for a little help on how to print the sales order line number on Packing Slips & Invoices. We are finding every time a partial order is shipped the line numbers are renumbered starting at one based on the remaining lines…
  • 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…
  • AR Customer Sales History Report displaying more than 2 years of data

    Is there an AR report to show/compare the Customer Sales History by Fiscal Period and Fiscal Year for more than 2 years?
  • Allow another user to access custom report in their Report Viewer

    I have created a custom report in Report Manager that I want another user to be able to run in their Report Viewer. How do I share these reports?
  • General Ledger Analysis Report- Operational Efficiency Ratios

    We have 3 company codes in our system. The operational efficiency ratio data on the general ledger analysis report populates for one of our companies but not the other. Has anyone experienced this issue before?
  • Visual Integrator Job Log Report

    The Visual Integrator "Job Log Report" is cutting off the information on the errors that occur. For example, a recent report looked like this: You can see that the error description is being cut off and so I can't see which batch or invoice I need…
  • WE WANT TO PRINT/EXPORT TRANSACTION DETAIL FROM ACCOUNT MGMT/INQUIRY

    FormerMember
    FormerMember
    We've always wished that we could export or print the transaction detail that we see under the Transaction tab in G/L Account Maintenance and Account Inquiry. Yet that's not possible. What's most frustrating is that a Print button is staring you in the…