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


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

  • Workers Comp Wages

    In 5-1-5-21 Worker's Comp Report, the Workers Comp Wages column is deducting the employee paid health insurance and 401K amounts. I'm sure its due to how those two payroll calculations are set up. I need to change something in the calculations, but, I…

  • Report Design: Report detail area (gray box) ghosting (duplicating itself) in report

    What caused, or how can I prevent, the gray box (report detail area) in the report form from duplicating itself (ghosting), usually in the bottom right side of the report when the report is run. First thought is there is another gray box, even just a…

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


  • Report showing jobs associated to companies?


    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…

  • Change Company name on reports Sage 300 CRE Accounting 20.0.1


    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…

  • Adding % to reports

    Does anyone know if I am able to add % to a report? For example Job Cost Summary (6-1-4-31).


  • Estimating reports into Power BI


    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


    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…

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

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

  • Custom Crystal Report printing differently

    We use a custom crystal report for our AIA type billing. Previously the items in the ITEM NO. column printed in the order that they appear in the Contract (which is correct). Recently certain items are printing seemingly randomly out of order. We did…