x Want to participate? Join the group to interact

  • Stored Material Presently Stored in Sage 100 Contractor

    Regarding the stored material in 3-7 Progress Billing, we are getting many complaints from our clients when we remove the previously stored amounts by entering the negative and positive. It adds into the column under the "This Application Total". The…

  • Job Cost Reports

    We are relatively new to reports in Sage 300. What is the "go to" report to get the amount committed/paid vs. the estimate. Basically remaining liabilities I believe. Any hints to help us make sure this is accurate? We use SCPC as our Project Management…

  • Parts Listing 9-1-1

    When creating a list of Parts, SAGE includes all parts ever utilized. Is there a way to only list ACTIVE Parts? For example, in other screens there are options to filter a report by only Active Jobs or Current Employees. I do not see such an option…

  • 941 Report - use Period End Date or Check Date?

    What is the difference between running a payroll report by period end date and running it by check date?

  • Crystal and special tsar functions

    In the users guide there are these functions for AR but it does not tell us exactly what they are doing and how it is determining it. In the AR Statement (CR) uses these functions, but i am getting some strange answers. I believe it has to do with the…

  • 1099 report

    I updated the date in AP for the current year, but the misc 1099 report is still pulling amounts from 2023. How do I get it to populate from 2024?

  • Client Average Days to Pay Report

    I need to build a Client Average Days to Pay Report. Has anyone built one? Any suggestions? Thanks,

  • User defined "Number" option has no decimal places. Is this new?

    I'm sure I've used the usrdf1/usrdf2 in places and changed it to be a number value, but i have noticed lately that when i change it to number it is only accepting and integer and not a decimal. I know i can make custom fields but i avoid them as they…

  • Closing Accounting Month Issue

    When trying to close my Accounting month, for the last 4-5 months, I get an error advising "GL Master File in Use" and the Accounting cannot be closed. No one is using the Master File when trying to complete this task and the only way we've been able…

  • Change Order Detail Report/Inquiry

    Looking for a report or inquiry that provides the detail data below. Any suggestions? Job # CO # Cost Code Category Units Price Total Price Cost Total Cost

  • Report Form- Check

    Hello, I have transferred Sage 100 from my old computer to a new computer and moved my customized forms for printed checks. In doing this step, I had to upgrade Sage from 23.3.23.0 to 25.3.98.0 I tried to pay a vendor using check. However, the spacing…

  • Job Cost

    Is there a job cost report that will print only what has been paid? We are needing to know what has been paid by cost code on a specific job.

  • Crystal Reports and Sage 100 Contractor

    How can I add a custom crystal report into a Sage 100 Contractor menu screen?

  • Why would a Macro DOUBLE all the entries within a job?

    When building a macro, if I select "new" file and "current" file, all the costs double when the report prints. This happens when there is nothing in the "new" file (everything is posted in all applications. All conditions are equal.) I've changed the…

  • Edit Reports with full version of Crystal Reports

    I already own Crystal Reports. Is there a way to edit the Crystal Reports from Sage with my existing license and not purchasing the Sage version of Crystal Reports?

  • Job Number Inquiry on Payroll and Invoices

    Is there a way to run an inquiry simply on Payroll by Job Number and export to Excel (not a report) I find the Sage Reports very clunky and hard to manage. Similar question can you run an inquiry with Job # and Amount Invoiced Thank you

  • Payroll report showing detailed company totals by pay date

    I am new to Sage and looking for a report that shows the pay details for the entire company. The Employee Totals by Period has the look I want, which shows a breakdown of pay items, deduction items, etc, for each employee: I tried adding totals at…

  • JTD cost showing on job cost report, but amount was not paid

    I have a cost showing on JTD cost in job report, but amount was not paid. We send POs to a vendor, but only pay off of invoices. In POs by job, it shows a PO amount and amount invoiced, but Amount Paid is 0. What do I need to do to eliminate this from…

  • County Request for list of subs/paid amounts/tax ID's for 2023

    One of our local counties is requesting a list of subcontractor's, Tax ID and amount paid for 2023 for their jurisdiction. Can I run a report for this?

  • Report Designer

    Does anyone have a way of pulling specified text from within an alpha field, from right to left? Example: Job Description field contains: Hudson - Model I want to report to be able look through all job descriptions and identify which ones have 'Model…

  • Gross wages and hours report for the prior year

    How do I get the Gross wages and hours report for the prior year and is there one that also includes 401k, Roth and loans on it?

  • Payroll Expense Check Only not on Check Recap

    Doing payroll and for one employee, I'm only paying them for an expense due. The $250 expense shows up on my time journal, Payroll Post Checks Report and the actual direct deposit check printed out. But when I look at my Check Recap by Employee, which…

  • Accountant asking for a list of Revenue for the year by Customer.

    Sage 100 Contractor. Where would I pull this type of report from? If I go into the 3-6 and choose a specific client and click on the payment button those payment total for that year are different than if I run the Report 3-1-2 78. So where do I find a…

  • Job Period Aging report 3-1-3-46

    When I print this job period aging report for the period Dec 2023, the report displays the retainage in the aging portion of the report instead of the retainage column, but only for jobs that we received the retainage payment in January 2024. Since…

  • Cost Codes last used

    Is there a report or an inquiry I can run to show when a cost code was used last on any project, current or closed?

*Community Hub is the new name for Sage City