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…

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…

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…

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…

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…

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.…

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…

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…

Hello, I'm working on a project and I need to be able to pull the same information the "Invoice History Printing" report pulls for a date. For my selected date, in our database we have about 3,000 invoices. The report, however, only pulls about 140…

Hello, I'm working on creating a barcode that needs to meet USPS requirements. Currently the formula I am using is: BarcodeUCC128("420" & "56901" & "92" & mid({SO_InvoiceHeader.UDF_TC_USER_8},3,24)) The font for the barcode Code128. …

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, We are looking to automate statement printing for our customers. I looked through the "Task Scheduler" provided by MAS and noticed that this was not an option. I have no experience with this sort of thing, but it seems that this should be possible…

I need to link these 2 tables in order to see a report of user roles and related tasks. But there doesn't seem to be a clear link. The SY_RoleSecurity table has key field called TaskKey which ha values of 9 characters, whereas the SY_Tasks table has a…

Sage 100 ver 2015 The items within the kit are included in the inventory sales history, but not included in the Inventory Reorder Report as either qty sold or qty issued. How do we get these sales to be included on the reorder report?

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…

I am trying to create a new report through the reporter. When I give the report a name and choose where it will be in the reports it puts me to the next screen where I should select a template (Landscape, Portrait, Shipping Label.) At this point no matter…

Hi, Let me start by saying I am new to MAS90. The issue we have is trying to create an 846 doc (using Gentran Director). We have a report called Inventory Stock Status Report, that give's the information that I need for my 846 document. but when I try…