Sage 100

Is there a PO Return of Goods History Report? I see Inventory Sales History, Inventory Receipts History, and Inventory Issue History Reports under IM module, but I don't see an Inventory Return of Goods History Report. Nor do I find one under the PO…

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…

Just upgraded Fixed Assets to 2023 for a client and they are still using Sage 2018 (in the process of upgrading to 2023 just waiting for a new server) and now they cannot print in Sage or in Fixed Assets. Getting this error. Report file C: ProgramData…

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…

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…

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…

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…

Working with Sage 100c Advanced v2019 and need to clean up Purchase Clearing Report where some PO's on report have Misc Charges on them, they go back years. Example: Qty Ordered = 7.00 Qty Received = 0.00 (Can't receive Qty on a Charge) Qty Invoiced…

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…

Just wondering what financial report alternatives are available for Sage 100. I have seen Sage Intelligence years ago, but was not impressed, it was clunky, difficult to use and not flexible. I have worked with F9 which is user friendly and is super flexible…

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…

Is it possible to get a report of all client emails from Sage?

Hi, In Sage 50, I was able to pull a report showing me all the payments we made to a particular vendor quite easily, but in Sage 100 I'm not sure how to go about it. I would like for example to see what we've paid to Vendor XYZ from August 1, 2018 to…

Is there a way to do a profit report per customer?

I have a Consolidated Financial Statement that contains up to 30 companies. It appears to be hitting the data limit. I talked to Sage Support and they said that the data can be filtered to generate the report. I wanted to pull the last 2 years of history…