• Job Cost Detail Report

    Is there a report that shows all of the posting detail for a specific job?  I am looking for a job cost detail report that shows the detailed cost for each cost code.

  • AP Pending Invoice Register with Detail

    We have started using the enter pending invoices function. 

    How do you print a pending AP register with detail that shows the distributions so I can proof the invoices?

    Thanks.

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

  • Union Paygroup Report

    Hello All,

    We use the Union Paygroup Report (5-1-7-31) in Sage 100 Contractor to pull information for our monthly union remittance. This report can only be run by period end or check date. I'm looking for a way to run it for the entire month (i.e. 1st…

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

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

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

  • Sage Intelligent Reporting vs Liberty Reports

    I am a long time user of Sage 100 Contractor (formerly Master Builder).  I need more flexibility in data reporting from the system.  I have read that Sage Intelligence Reporting and Liberty Reports are two add-in options.  If you have experience with either…

  • Job Cost reports that show overage on Budget line items as opposed to only cost codes

    Hi there, looking for solutions on how to get the following reports to run in the jobs. What is required on entry? 

    I would like to have something in the following format, i have put in an example below

    Cost code XXXXX

    Budget line item base.         Upgrades…

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

  • Run multiple reports at once?

    Is there a way to create a report group? When I make financial statements, I can combine multiple financial statement reports into a financial statement group and by choosing that group to print, it will print all my financial statements for the selected…

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

  • can in-list be used with {variable[N]}?

    In Report Writer, Sage 100 Contractor, is there a way to use the selection criteria "in list" with a variable like {variable[N]}?

    In this case, I am using {Job Number[N]} to select Job Number in SQL statement where job number is not in the Primary…

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

  • When will the Year End be posted?

    When will the year end be posted?

  • Total cost of PR by date

    Hello, 

    What report do I run that will give me PR totals by a specific date range? Thank you in advance.

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

  • Unbalanced Balance Sheet

    How can I fix $1 off on balance sheet? TB is balanced but total assets is rounded down while equity/liabilities rounded up. Thanks. 

  • upgraded from 18.12 to 20.1 all report layouts show under layouts but they are all wrong

    We upgraded Estimating last night and now any report layout you choose the previous settings are gone

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

  • Aging Report on an invoice vs Inquiry on the same invoice

    I have an Invoice that is showing in my aging as open however when you do an inquiry on that invoice it shows paid in full.  How do I get this invoice off my aging report?

  • Fairly new to Sage 300 Construction.

    I'm looking to run a Customer Statement Detail by Accounting Date that includes retainage invoiced and paid.  When I run the report, even though I have the "include retainage" box checked off, neither show up.