Sage 100

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.

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…

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…

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…

I'm trying to build a consilidated trial balance report using an external BI solution (Qlik) by querrying the SQL database of Sage (GL_DetailPosting) Credit and Debit amounts of the current period are wokring perfectly, but i'm not able to figure out…

I am trying to a task scheduler to run a GL detail report but when I test the task, it runs for a whole year instead of just date that I would need the scheduler. How can I fix this issue? thank you

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

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…