Sage 100

Hopefully there is a way to do this. We are currently in a major backorder situation due to material shortages and have many orders that are partially shipping. For example, We enter an order containing pages of items (100-300 parts) We are able…

Hello Everyone, Our CS dept have been reporting to use that they are receiving a popup message in SAGE when try to print a pick sheet from the Sales Order module. Please see below. I can't figure out what could be causing this. I have checked permissions…

Hi. How do I generate a report that will show me how a cash receipt was applied? I need to know what invoices were paid by each individual cash receipt in the year 2020 and early 2021. During the early days of COVID ach payments were sent in randomn…

The Customer Sales History by Period >> Dollar Sold does not match our income statement revenue. I tried reverse-engineering the data and it appears that any values that touch the customer A/R account are included in Dollars Sold, regardless of which…

Hi, I run a net sales report from AR explore=>customer history invoices view. I use the invoice total minus sales tax, which gives me the net sales for that period. However, this number does not tie my income statement number. My June net sales total…

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…

Hello, We are trying to set up an invoice report for a 3rd party company to help us manage our taxes. They require that we put taxable amounts on one row, and non taxable amounts on another row per invoice as we have some invoices that have both taxable…

Hello, I am trying to put together a report for tax purposes and am not confident I am pulling paid invoices correctly. My initial thought was that all invoices in the ar_invoicehistoryheader table were paid, but I was told that these invoices are…

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…

Hi, I have the code below for automatic registration/update of the inventory register transactions. In the nProcessReport part, my return is always Nothing. I'm encountering same issue on Sage 100 2018 and 2020 oSSRegister.nSetProgram(oSSRegister…

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…

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…

Hello, There is error message on the Sage100 as shown below. How to fix the error? Thank you in advance for your help!

We're running the A/P month end process for the first time. However, there are no period end reports listed in the Period End Report Selection. These are the reports I expect to see listed How do I get the A/P period end reports to list in the…

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…

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…

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…

Is it possible to get a Active Vendor List? Lets say vendors that have been paid in the last 3 years?

I've looked through the payroll module overview and other sources and cannot determine whether employees' federal and state withholding elections (filing status, including exempt) from the W-4s are reportable fields. If some report, somewhere, captures…

I am working on a Crystal Report that shows a grid with sales history and would like to graph the history by sales period. For instance showing each period in 2018 as blue, 2019 as red, 2020 as green. So you will see each year clearly in each period.…

Is there an AR report to show/compare the Customer Sales History by Fiscal Period and Fiscal Year for more than 2 years?

Where does the QuantityOnHand value come from in the SO_OpenOrderWrk file? The field value is always zero when I try to use it in an Open Order Report. I would like to pull the QuantityOnHand from the IM_ItemWarehouse file based upon the WarehouseCode…

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?

As the title says, we'd like to separate our year end aje's. We'd like to have an unadjusted trial balance, aje's, then the final trial balance. Sage was not setup with a period 13, and I'm not sure if that can be added at this point. Our Sage guru…

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?