• 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…
  • Total Compensation/Benefit Statement

    Can anyone tell me what benefit statements or compensation statements they use that they really like?
  • Job Cost Extra

    I setup a job cost extra. Job Cost > Setup > Extra. However, when I go to run the Job cost extra report the extra number I just setup does not appear. Why?
  • AP - Office Connector - Invoices Selected for Payment

    Can anyone line up the office connector reporting to the following report within AP AP --> Reports --> Invoice Regesiter --> Invoices Selected for Payment I would like to generate this report within Office Connector to have the information within…
  • Subcontractor Retainage billed through Procore.

    We are currently integrated with Procore, so all our subcontractor invoices are created in and synced from Procore to Sage, so we do not enter invoices manually. When our subcontractors bill their retainage, it creates a $0.00 invoice in Sage. Does anyone…
  • AIA Style Crystal report for Billing when using Procore.

    Apparently Procore send JC trans for Contract CO's and the current AIA style billing designs don't take that into account. So, the knowledge base article says to call sage professional services. They can't help until after Sept 12. Does anyone have a…
  • job cost

    I am looking for a job cost from 2017. When I go to look for it, I select new, current and history and there's no 2017 showing up in the system. It goes from 2014 to 2019. Can someone explain where I can find my missing job cost please?
  • Vendors being excluded from Insurance Audit Totals

    We are beginning a project in which our subcontractors are to be excluded from our insurance audit totals. Since these same subcontractors may be working on other projects for us that will be included in the audit totals, does anyone have a solution would…
  • Job Cost Report with Invoice Images Included

    We need to run a Job Cost report in Sage 300 CRE for a specific job and period that includes the invoice images for the invoices included on the JC report. We import invoices from Timberscan but the TS Job Cost Inquiry report file is too large to email…
  • Crystal Report Question

    I have a column of values that are the result of an equation. When I try to sum these values, I do not get the correct total. I have been trying to insert a sum and selecting the formula field for the column in the field explorer. The column is part…
  • Payroll

    Is there a report that can provide the information requested from the US Bureau of Labor Statics?
  • 941 Report (Aatrix) Employee count

    When running our 941, it is coming up short for our total employee count for box 1. It appears if an employee is terminated in the middle of a quarter, they are excluded from the total employee count even if they received a paycheck during that quarter…
  • Payroll Report that calculates Workers Compensation basis by job?

    Does anyone have a report they are willing to share that correctly calculates the workers comp basis by job? Sage only tracks workers comp basis by workers comp state/code. Thanks in advance.
  • Formula for Report Designer Union Rate

    I am trying to correct a formula on one of our Certified Reports (in Report Designer) to where I need to be able to calculate an hourly fringe rate based off their fringes and Union Class/Certified Class. I can correctly calculate the total fringe amount…
  • Closing a Job

    When billing a customer with a quick bill, to see which jobs are open for a certain customer, I first run a report from Job Cost - Reports - Lists - Jobs. Then I enter 2 conditions: 1.Status not equal to closed and 2. AR Customer equal to the Customer…
  • EFT & Nacha files

    EFT payments fail to print on check registers. And I called support & was told the direct deposit (Nacha) file automatically generates-it does not. The report only shows employee names with total of all deposits to multiple accounts, no routing, no account…