x Want to participate? Join the group to interact

  • 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).

  • Crystal Reports and Sage 100 Contractor

    How can I add a custom crystal report into a Sage 100 Contractor menu screen?

  • 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.

  • County Request for list of subs/paid amounts/tax ID's for 2023

    One of our local counties is requesting a list of subcontractor's, Tax ID and amount paid for 2023 for their jurisdiction. Can I run a report for this?

  • Monthly Income Statement

    We are new to Sage 100. We are trying to run a report that shows what we invoiced, and any payments/debits made. We ran report 2-3-21. However, that report is showing every invoice we received for the month even though it wasn't paid. Some of our credit…

  • Aletering a custom report

    Reposrt 05-02-08-61 report I would like summarized by employee and grand totals. I have done it before, but saved as a shared report. We got a new server mid last year and I lost the report. I need it for an audit due on Feb 1, 2024. I know it is simple…

  • Is there any way to get a Union Benefit Report where I can select which benefit calculations I want under the paygroup?

    Our monthly union benefit payment is split and 9 of the benefit calculations get paid to one place and 3 get paid to another. As far as I can see the Union Reports (for ex. 5-1-7-31) total the benefits by paygroup and unfortunately the report is not modifiable…

  • 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.

  • Printing job statements is cutting off paid dates

    Report 3-4-21 (at least in the Canadian edition) is cutting off the dates when you print the payments. This has been happening for a while, but we were hoping it would get fixed in a subsequent release

  • job cost

    I need a report that shows all employees that worked on a certain job on a certain day. Can someone help me?

  • Purchase Order Audit report - no sales tax

    The purchase order audit report does not include the sales tax in the received columns, even though it has been inputted during accounts payable data entry against the PO. Can this be corrected?

  • Report writing

    I am trying to write a report, i have a if then and select syntax. Does anybody know the correct code for the tmcdln.crtfid table/column I want the report to be able to select sum from the tmcdln.hrswrk based on a y in the tmcdln.crtfid column. …

  • report error "invalid object name mscfld

    I am running a report and get report error "invalid object name mscfld. I have changed the report form to the system report, no change, and searched the code for the word invalid, none was there.

  • reports affected by rptclc^clc in report forms and custom reports

    Custom reports and report forms in Sage 100 Contractor have been "infected" with this "field" rptclc^clc001, 002, etc. I have seen this before but not to this extent. It is massive. Has anyone else seen this before? Or know what causes this…

  • 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???

  • Error message when trying to run a New Hire Report

    I receive the error message below when I am trying to run a New Hire report for Michigan. Prior to the most recent update, I had no problems.

  • 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…

  • 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.

  • 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?

  • Quarter Four Earnings report

    I closed the 2022 payroll and now I can't run a Quarter Four Earnings Report? Can someone help me run the 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…

  • payroll general ledger report

    how can i print payroll general ledger after posting payroll to general ledger?

  • Payroll Check Stub Error - YTD Gross Wages for 2023 includes 2022 wages

    Updated software to version 24.3. Closed 2022 Payroll Year. Did not archive 2022 payroll records. Printed first checks for 2023 and the YTD Gross Wages on check stub includes wages from 2022. YTD Amounts for Taxes are correct for 2023. Using the standard…

*Community Hub is the new name for Sage City