• 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
  • 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).
  • 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…
  • Emailing Stubs in Direct Deposit

    My company is currently considering switching to direct deposit from paper checks. I think I've more or less figured out how setting up direct deposit works, but what I haven't been able to find is if emailing pay stubs is possible with Sage 300 CRE?…
  • 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?
  • 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.
  • 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…
  • 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…
  • Sage 300 CRE 2023 T4 Reporting - Any info about the new Box 45 on Canadian Payroll T4's for Employer offered Dental Benefits?

    Sage 300 CRE 2023 T4 Reporting - Any info about the new Box 45 on Canadian Payroll T4's for Employer offered Dental Benefits?
  • 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…
  • Property Management Batch Rental Invoice Processing?

    Can the Property Managment module allow for Batch Rental reoccurring invoices via e-mail to multiple tenants? Is anyone doing this and how can it be set up and processed monthly.
  • 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…
  • 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…
  • 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?
  • Colorado FAMLI Q1 Reporting

    I am trying to prepare the reports I need in order to file our first quarter for the new Colorado FAMLI tax deduction. When I try to use Aatrix the report is only one page (not in the format the state is asking for) and is showing zero as the value for…
  • 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?