• 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).
  • 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.
  • 2-6-0-21 Check Register Report

    Can anyone advise on what the "*" means next to the date on the Check Register Report 2-6-0-21 ? Thanks for your help in advance!
  • EEO-1 Reporting

    Can anyone help me wth how to have Sage PR mod compile the EEO-1 report?
  • 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 ?
  • Voided A/P Checks

    I just voided several checks for a vendor. How do I run a voided check report?
  • 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…
  • Releasing Subcontractor Retainage

    Does anyone have a good process they could share for this? We just switched from Yardi to Sage 300 CRE and in Yardi there was a function where you can see your subcontractors total retainage billed (match it to their retainage invoice at the end of their…
  • 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…
  • AP Electronic Payment (ACH) Remittance

    I am curous to know what people are using as remittance for their Electronic Payments (ACH) in Accounts Payable? The "notifications" report that is generated from the payment process seems pretty bare (no headings, titles etc) -- just has floating numbers…
  • 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?
  • Failed to retrieve data from database error coming when try to generate a report

    Dear team , When trying to generate a payment voucher using crystal report ,following error obtained.
  • Embedding images in shared estimate reports for Sage Estimating 20.1

    Hi all, I have been tasked with cleaning up some of the unknowns within Sage Estimating for our company. We are currently using the latest Sage Estimating 20.1 within Sage 300 CRE and since the update we have had some issues with our reports. The saved…
  • Payments by Vendor/Contractor

    I need to run a report that shows how much we paid to various vendors, that lists amounts paid and dates. Anyone know of a report out there like that? I can't seem to find one. I would think it woudl be a standard report? Thanks in advance!
  • 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 .
  • 1099 Reporting issues

    When I get to the vendor selection process it does not allow me to select the vendors I want. There is no checkbox like the Year-End guide shows below. I have selected 2020 as the year, but on my screen the "Select" row are empty and do not have a…
  • 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?
  • Report with blank lines

    We have changed the AP invoice aging w/cut off to show the job number. It worked great except that it has a huge number of lines that have no dollar amount. These lines just show the vendor number and name as well as the job number and name. Can someone…
  • Is there any type of payroll report that will show me the distribution to an entity by employee by cost code and show the employee's hours worked?

    This is a standard report in the system we currently use and is called P/R Edit List by Job. We are in the middle of programming the Sage system and have run a mock payroll but it is not yet posted. However the above mentioned edit report is provided…
  • AP invoice payment approval report

    When we setup Invoice Approval in AP, one of the things we did was setup Approval IDs, so we could tell who approved an invoice. However, now that we've used this for a while, I can't find a report which displays this data. Is there a way to create a…
  • Custom Crystal Report printing differently

    We use a custom crystal report for our AIA type billing. Previously the items in the ITEM NO. column printed in the order that they appear in the Contract (which is correct). Recently certain items are printing seemingly randomly out of order. We did…