• 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…
  • 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).
  • 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?
  • Inquiry with last invoice date for a job/contract

    I have been searching everywhere to find an inquiry that has the last billing date for a contract. Does anyone know if such a thing exists? I can't even find where this information is stored in contracts, billing, job cost, AR, anywhere. Your help is…
  • 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…
  • 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?
  • Add field to Report Designer AR Aging Detail by Customer

    We run the AR Aging Detail by Customer (RD version) and lately we have had some payments that have come in that don't get applied to an invoice right away. So, they get entered as customer cash receipts and we indicate which project they relate to by…
  • 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 ?
  • Sage 300 CRE Payroll - Work Comp Audit Reports

    I am new to this program and cannot seem to find the right reports that I need that would include everything for the auditors. Any suggestions?
  • 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.
  • AP Pending Invoice Register with Detail

    We have started using the enter pending invoices function. How do you print a pending AP register with detail that shows the distributions so I can proof the invoices? Thanks.
  • 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
  • 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…
  • 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…
  • W2 Reports

    Is there a report or a small set of reports that I can give to our accountant to produce our W2's? A summary of the W2 information?
  • Run multiple reports at once?

    Is there a way to create a report group? When I make financial statements, I can combine multiple financial statement reports into a financial statement group and by choosing that group to print, it will print all my financial statements for the selected…
  • Change Company name on reports Sage 300 CRE Accounting 20.0.1

    Hello, Recently we have moved from a publicly listed company to a limited liability one and looking to change the name on sage reports .
  • Estimating reports into Power BI

    Hello, I’m new to Sage and looking to access estimates through Power BI. I’ve connected through ODBC, but I do not see how to get estimate information, only Database information. any ideas?
  • When will the Year End be posted?

    When will the year end be posted?