• Gross employee payroll report

    I'm preparing for a general liability audit. I need to report employee wages (ytd total) by position and worker's comp code. Does a report like this exist???
  • 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…
  • 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…
  • AR Tax Group Set up Report

    Does anyone know if there is a AR Tax Group set up report that exists so I can see what tax rates are part the group? Looked in standard reports and KnowledgeBase but have not been able to find anything.
  • How can I tell if I have billed retainage

    1. I m looking to see if there is a report that would show me if i have billed retaiange. 2. I m looking for a report or something that i can run that would show if I billed for my jobs that month.
  • Old Financial Statements

    Hello, I need to run a financial statement for 3/21 and 9/21, however when I try to go back to those months in GL, I cannot get the information and total to date. Does anyone have a report they can share that will pull the information I need?
  • Outstanding AP Checks

    I need to be able to run a report of any oustanding AP checks and then export that to Excel. Is there a report like that?
  • ChatGPT - Analytical insights - Sage 300 CRE

    Looking to see if anyone has begun working with ChatGPT and its functionality within Sage 300 CRE Hoping to learn if others are utilizing the software to provide analytical insights within the Payroll Module. Excited to see the potential future…
  • 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?
  • Job Actual Start Date

    Does anyone know of or have a report that shows the Actaul Start Date of a job? I can't seem to find one. Can only find reports that list if the job is In Progress or Closed, or the Closed date. TIA! Annie
  • Edit Job Number on Paid Job

    I have a situation where a job was invoiced and paid with the wrong job number. The invoice was entered via Job Cost/Enter Billings and paid via Job Cost/Enter Cash Receipts. Is there a way for me to change that job number so reporting is accurate?
  • Where Do I find Contracts

    I can't find Contracts anywhere. I need to see the history of our contract values. Where do I go to find Contracts? TIA!
  • How to remove automated email reports

    Good day, I have a job cost report for several projects that was set up to auto email every week to my email. We have long since completed these jobs and moved on to new jobs. I have two questions: 1. How do I remove the old job automated report emails…
  • Committed Item

    Does anyone have a report that will not only show invoice detail for commitments but also invoices billed over commitment? I know it is backwards but we frequently process the commitments after the invoices are entered. I then have to go in and attache…
  • Delinquent tenants inquiry error

    Hello, We use the Property Managment Delinquent Tenants inquiry to see balances that are past due. As of last week we can no longer click on the Balance column dollar amount to see the detail. We get an error that says "No open item records for…
  • Exporting all Formulas (spreadsheet based) to Excel (specifically level totals).

    Hi, I am trying to export my sage spreadsheet to excel with the stipulation that all relevant cells populate with the spreadsheet formula as it is set up in the sage spreadsheet (i.e. an item's total amount contains a formula that is the sum of all…
  • 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 ?
  • Save YTD ledger

    HI, I'm running a YTD ledger with multiple accounts selected in the ranges box. Is there a way to save this report as I have to run it monthly and it's very time consuming selecting multiple accounts each time?
  • 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…
  • Sage 100 Contractor Modify Report - Define Selection Criteria - Enable 'Or' logic

    When modifying a report, there is an option to enable 'or' logic in the selection criteria. I'm having a hard time setting this up and wanted to see if anyone has had success with this.
  • Is there an option or work-around to show multiple jobs on one Gantt chart?

    I'd like to be able to pull a Gantt chart that shows everything going on in a month/quarter, ideally for the whole business and by supervisor. I've dug through all the report options and can't seem to find anything, but the Gantt charts are kind of useless…
  • 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?
  • Change Accounting Date in JC Cash Receipts

    I just posted cash receipts in JC with a future accounting date and I'd like to change the date. Is there an easy way to do this?
  • 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?
  • 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?