• 941 Report - use Period End Date or Check Date?

    What is the difference between running a payroll report by period end date and running it by check date?
  • 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…
  • 1099 report

    I updated the date in AP for the current year, but the misc 1099 report is still pulling amounts from 2023. How do I get it to populate from 2024?
  • Change Order Detail Report/Inquiry

    Looking for a report or inquiry that provides the detail data below. Any suggestions? Job # CO # Cost Code Category Units Price Total Price Cost Total Cost
  • Why would a Macro DOUBLE all the entries within a job?

    When building a macro, if I select "new" file and "current" file, all the costs double when the report prints. This happens when there is nothing in the "new" file (everything is posted in all applications. All conditions are equal.) I've changed the…
  • Edit Reports with full version of Crystal Reports

    I already own Crystal Reports. Is there a way to edit the Crystal Reports from Sage with my existing license and not purchasing the Sage version of Crystal Reports?
  • Payroll Expense Check Only not on Check Recap

    Doing payroll and for one employee, I'm only paying them for an expense due. The $250 expense shows up on my time journal, Payroll Post Checks Report and the actual direct deposit check printed out. But when I look at my Check Recap by Employee, which…
  • Job Cost Accounts Receivable Paid Report

    I'm looking for a report in Job Cost that shows what we've invoiced to a particular job, when it was paid, invoice number, etc. The Job Cost/ Receivables Aging by Job report only shows open invoices. Once the invoice is paid, it is removed off of the…
  • 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.
  • Deleting Cost Codes

    If I have a Cost Code that we no longer use and I want to delete it from the list, what are the ramifications of doing this? If I ran a report where costs were associated to the Cost Code, would they disappear? Would to Description of this Cost Code…
  • 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…
  • job cost

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