• 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
  • 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.
  • 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…
  • 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…
  • 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?
  • Job Cost Accounts Receivable Paid Report

    I'm looking for a report in Job Cost that shows what we've invoiced to a particular job, when it was paid, invoice number, etc. The Job Cost/ Receivables Aging by Job report only shows open invoices. Once the invoice is paid, it is removed off of the…
  • Payroll

    I have posted my checks but the report is showing nothing was posted. I am unable to print reports under "current" because there are none? How would i fix this problem? Is there a way I can go back and find out what happened? I think what i did was I…
  • Job summary JTD balance is not matching trial balance

    Hi, I'm closing month and job summary balance does not match with trial balance. It only total month to date and does not include total from last month. Any idea how I can fix this? Thanks.
  • Deleting Cost Codes

    If I have a Cost Code that we no longer use and I want to delete it from the list, what are the ramifications of doing this? If I ran a report where costs were associated to the Cost Code, would they disappear? Would to Description of this Cost Code…
  • Job Cost Report Missing Entry

    On the Job Cost Report for one of my jobs, the Subcontract total for a specific cost code is missing the amount of one invoice. The invoice was correctly put to the corresponding Commitment. The correct amount shows up on all other JC reports. But for…
  • Sage 300 Construction - Job Cost Sheet Cost Code Collapsed

    When you run a Job Cost Report and some of the Cost Codes show no details and the JTD Cost column is 0.00 but the Remaining column has say $15,000.00. This tells me there are entries for that Cost Code (say Hvac - Rough in 10-18-010) but the report shows…
  • 2024 Payroll

    Is any one having issues with the new 2024 YTD totals on salaried employees. I have a few, but not all salaried employees, that are taking the last P/R of 2023 + the First Payroll of 2024 in the YTD totals?
  • Quarterly Employee Count Report

    I have just run my Quarterly Payroll Reports. My Quarterly Employee Count Report is missing 4 employees. But these 4 missing employees have wages on the rest of the reports (Subject to Employer & Subject to Employee). The one thing in common with these…
  • Sales Lead in SM

    Does anyone use the Sales Lead feature in Service Management? I have set up Lead Types under Setup- Sales Lead. Now when I go to a work order, on the general tab, and use the drop down meanu for 'Sales Lead', nothing is listed. It says NONE. How can I…
  • Is there a way to edit Schedule of Values template?

    We are looking to edit the way our format for the schedule of values outputs & prints, is there a way to edit this? Or is this a default that is unable to change? The same goes for our estimate template.
  • Subcontractor List

    How do I create a report that will show me a summary balance total paid to a Vendor/Subcontractor in a specific time period ?
  • Report showing employee hours and wages

    I m looking for a report that shows employees hours and wages
  • Payroll

    What is the correct steps to run a payroll register for the year?
  • Report Formulas

    I would like to create a report that shows me vendors without an invoice during the past 15 months. I know I can create a condition each time for "last invoice date <= (date 15 months prior). Or create a condition based on input. Is there a way to create…