• How do I get a report showing Vendor Statistics for a fiscal year in Sage 300 CRE

    I need to pull a report that shows all of the following information for our past fiscal year: Vendor name, address (CSZ) number of checks, total amount paid to vendor, Type of payment (Check, cc, ACH).
  • 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…
  • Receivables

    I'm looking for a report that shows me the current contract dollar amount and how much we have been paid for that particular contract.
  • Report that shows wages for a particular job

    I m looking for a report that shows employee's name and wages for a particular job and a certain time frame.
  • job cost

    I need a report that shows all employees that worked on a certain job on a certain day. Can someone help me?
  • 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…
  • AP Retainage Billed Report

    We are having issues with getting subcontractors who have billed retainage to show up on a report since Sage 300 refuses to create a "bill retainage" button in AP. When I submit reports to management they have no idea a retainage bill from a subcontractor…
  • AR aging report

    Hello, I am new to Sage and we recently converted from another ERP.. We are looking for a report with the following information that can be exported to excel.. Customer, Customer Name, Job, Job Name, Invoice Number, Invoice Date, Invoice Due Date…
  • EEO-1 Reporting

    Can anyone help me wth how to have Sage PR mod compile the EEO-1 report?
  • Sage 300 CRE GL system has a SOC 1 Type II report in which service auditors test the internal controls over Sage reporting

    Can we create a SOC 1 Type II report in which service auditors test the internal controls over Sage reporting?
  • Sage 300 CRE Upgrade - Can no longer run AR reports

    We have recently upgraded our Sage 300 CRE to version 22. Now when we try to run our aging report in accounts receivable we always get this error. Faulting application name: AR.EXE, version: 22.2.1.113, time stamp: 0x6336a3bd Faulting module name…
  • Open Invoices

    Hi, I am new to Sage, How do I run a report that will give all the open invoices for a specific project ?
  • Invoices Selected for Payment Report

    AP-Invoice Registers-Invoices Selected for Payment For whatever reason, when I go to this report, it lists 2 items that do not have a balance due, nor are they included on my list when i go to 'Select Invoices for Payment'. I would like to get these…
  • Warnings on Check Journal

    On the bottom of my Payroll Check Journal, I'll often get a message - "2 warnings - check the System Log in the Log Viewer". But when I open the Log Viewer there are no warnings there. Is there something else I need to do to view these errors?
  • Report to show Employee Cost

    Project manager is looking for a report that will show how much an employee is costing him based on a specific job. Is there a report out there that will show a specific employees hours, for a specific job and what labor costs are included?
  • Benefit Time Tracking

    Would any users of the Sage Field Operations/Service Operations for 300 CRE time entry system who also us the Sage Payroll system like to share how they track benefit time? We are currently using Time IPS for time entry and benefit tracking but want to…
  • JC summary showing a difference in GL vs JC- how do I find out where the mistake is?

    Hello, I recently ran my JC summary reconciliation report and have a difference of $900 in my GL that is not showing up in my JC on the subcontractor line of the report. What reports do i run to narrow down where the mistake is at? Looks like it was…
  • How can I get a report like the Check Activity Detail report with only YTD Totals for all employees in a specified date range Using Sage 300?

    How can I get A report like the Check Activity Detail report with only YTD Totals for all employees in a specified date range Using Sage 300? The Check Activity detail report is just what I need with just a bit of modifications. The report only need…
  • Job Cost Detail Report

    Is there a report that shows all of the posting detail for a specific job? I am looking for a job cost detail report that shows the detailed cost for each cost code.
  • Labor Hours by Cost Codes

    I need to be able to show number of hours for the year by various cost codes but can't seem to find a report that will do that. So for example, 1/1/2021-06/30/21 I need to see how many hours were entered with drywall cost codes, electrical, etc. Any help…
  • NYS EO 162 Workforce Utilization Gross Wages Reporting

    Does anyone have a report that meets the NYS requirements for the EO 162 Workforce Utilization Gross Wages Reporting? https://www.thruway.ny.gov/business/dmwbe/purchasing-eo-162-instructions.pdf
  • Subcontractor and Tier 2 Diversity Spend

    We are getting more requirements from our Owners to formally report our Tier 1 and Tier 2 Diversity spend. We have all of our subcontractors set up in Procore with their diversity status but it looks like getting the spend report out of there is not going…
  • Report showing jobs associated to companies?

    Hi, Within a datafolder we have numerous companies - all with jobs associated to them. Is there a report or easy way to show what company each job is associated to or show a list of jobs associated to a certain company within a datafolder? Further…
  • Job Cost as of Specific Date

    In comparing one job from one month (APRIL) to the other (MAY) this report showed (APR) JTD costs that actually pulled costs from MAY. I struggled with this for about 4 hours finding the the entries were in fact correct, with the correct accounting…
  • Field Section of 'Add Condition'

    If I add a condtion to a report, it lists a bunch of items in the Field Section. How do I add an additional field to that? Right now 'Owner' is an item in the Field for Job Lists. But when I view the same report in our Archived database, 'Owner' is not…