• 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…
  • NEGATIVE QUANTITY I REPORT, BUT IN "ITEM INQUERY"

    Hello all again, I've been getting some very good advice here lately, thank you all! I create a custom report in the "Item List" that includes "Total Quantity On Hand". The issues I have is when the report shows a negative qty, however the Item Detail…
  • 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…
  • What is the best report/combination of reports to see detail of inventory allocated to work tickets vs sold on invoices?

    Looking to see quantities and part numbers and value of transactions to tell how many pieces we are selling vs allocating into work tickets. We stock part numbers that could be sold directly to customers or allocated into larger bill of materials/work…
  • Table that stores monthly "beginning qty"

    Hi guys, Would you please lend me your hand in finding the table that stores beginning qty (and also value) for inventory? Basically, i'm trying to replicate the "5.History" tab in Inventory Inquiry. I've looked into IM_PeriodPostingHistory, IM_ItemWhseHistoryByPeriod…
  • 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…
  • batch report creation

    Hi There, Is there a way to run a batch file to change all items entered into inventory with a none reorder method to reorderpoint? Thanks in advance, \\shane\
  • Inventory

    I am really new to Sage program. I ran a physical count variance report after a physical count was done. However, the Quantity on Hand shows zeros for every item. What did I do wrong> Thank you
  • Point in Time Inventory

    We have purchased a company using Sage 100 and will need to identify the inventory on hand at a particular point in time. The ERP system we have has all inventory transactions in one table, thus it is possible to start at the end or the beginning and…
  • Sales Order - Stock Status on Sales Order Quantity and Sales Order by Item Report Quantity are Different

    For one item / warehouse (that we know of so far), the On Sales Order quantity listed on the Stock Status report and the quantity on the Open Sales Order Report by Item report do not match. Actually a difference of 4300. Can't seem to find a reason. I…
  • 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…
  • Report Automation with Sage Alerts

    Is it possible to set up a Sage Alert to run a system report on a schedule? I want to get the Inventory report Multi-Bin QOH and Valuation Report to email on a schedule, but I can't get the report to generate values unless I run it through Sage. I've…
  • 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…
  • INVENTORY VALUATION AND GL ACCOUNT DIFFERENCE

    My inventory valuation report is pulling around $9 million dollars and my GL account inventory is pulling around $ 1 million. anyone know how i can fix this or see what the difference is ? Thank you,
  • 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…
  • 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…
  • 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…