Sage 100 (Master Builder) Report Writing and More

Jim Schuett Designs Blog


June 16th, 2015 · No Comments



(Master Builder)

NOW AVAILABLE from Jim Schuett

  • As this is new, effective 6/12/2015,I am beginning to create Sage Intelligence Reports now and will add to this list as each is created.
  • Let me know what you need, and I will do it for you.


Payroll Records by Employee

  • For more info & to view report, Click Here.  
  • ( To visit )
  • Also see up to 20 reports that come with Sage Intelligence Reporting.

→ No CommentsTags: New Reports

10 New Sage 100 Contractor Reports

June 7th, 2015 · No Comments

10 New Sage 100 Contractor Reports

From Jim Schuett

Over the last year, I have written 100s of new Sage 100 Contractor reports.

  • Most are specific to Client’s needs.
  • Many I’ve created on my own to fill a perceived need.

PDF’s of the 10 Best Reports (full report) available upon request.

  1. 02-02-00-05  Balance Sheet – 12 Periods
  2. 02-03-00-20  Ledger Subaccounts – 12 Periods
  3. 03-01-01-00  Client Credit Application
  4. 03-01-01-07  Job Progress Status Report
  5. 03-01-03-05  Department Current Aging
  6. 05-01-02-17  Payroll Detail – By Employee (Select Date Range)
  7. 06-01-06-01  Job Status Detail – with Cost Type: Budget, Costs, PO & Subc Totals
  8. 06-01-08-00  Bonding Report with Period Select, By Status / Dept / Job
  9. 06-01-08-09  Bonding Report with Hours, Job Costs by Cost Type
  10. 09-05-00-19  Takeoff Detail with GM% Variables


Discounts on multiple report purchases are as follows:

  • $495 each on 1 report
  • $450 each on 2 reports (save $  90)
  • $425 each on 3 reports (save $210)
  • $400 each on 4 reports (save $380)
  • $375 each on 5 reports (save $600)
  • Call if need pricing on additional reports.
  • Discount pricing expires June 30, 2015.



See 250 additional reports at:

All reports are ready to go.

  • (Pricing is for reports without changes)
  • Changes will be made at standard hourly rates.
  • For purchases, CONTACT JIM SCHUETT.
  • Discount pricing expires June 30, 2015.

Always at Your Service,  
Jim Schuett
Sage 100 Report Writer & Advisor
Bottom-Line Design Services LLC 
 BC-Jim Schuett 2015

→ No CommentsTags: New Reports

Liberty Reports by Jim Schuett for Sage 100 (Master Builder)

February 24th, 2015 · No Comments


Something NEW is happening!

I have added “Liberty Reports” to my report writing options for Sage 100 Contractor, and am continuing to write in Sage 100’s Report Writer for the reports that work well inside the software.  (See below the report for more info on Liberty Reports details.)

With Liberty Reports, I can write reports that can’t be done inside Sage 100 (Master Builder) Software.

I will be adding a lot of new Liberty Reports for sale in the very near future. Custom report requests always accepted.

This report, Job Status Report-Summary, is my version of report 6-1-1-21 in Sage 100, but much better.

  • The report is created in Excel, and the data is pulled from your Sage 100 company database.
  • You can change the job number, refresh the screen, and the new job’s data appears.
  • The report expands and contracts to accommodate the needed space for the various lists.
  • PDF copy attached.
Report LR-6-1-1-21
Report LR-6-1-1-21

This report is offered at a special “Introductory” price of $250 (regularly $395) for the month of February 2015.

(Hopefully it will help with the one-time purchase cost of the Liberty Reports software.)

Liberty Reports is the latest generation of Event 1 Software’s Excel-based reporting technology.

→ No CommentsTags: Sage Master Builder

Jim Schuett, Sage 100 Report Writer

January 16th, 2015 · No Comments

Jim Schuett, Custom Report Writer for Sage 100 Contractor (Master Builder) Software

As the premier report writer for Sage 100 Contractor (formerly Master Builder) software, I have Clients all over the USA and some in Canada, who contact me for help in writing custom reports to help them get the data out of Sage 100 the way they want to see it.

Most popular request:

Can you create a report to look like

  • My Spreadsheet
  • My Crystal Report

As you can imagine, some of these requests are extremely complex, and sometimes I can’t do them, but most of the time I can.  I have been able to help hundreds of Clients with report writing over the last 12 plus years.

If you have a request:

  • My first consultation is free.
  • If I can’t do your report, even if I try, you owe nothing.
  • 100% satisfaction guaranteed.

Who are My Clients?

  • Construction companies
  • Sage Business Partners
  • Sage Software Company

Contact me to discuss your requests.

  • 480-277-7550

→ No CommentsTags: Sage Master Builder

Sage 100 Report Writing Class Schedules

October 22nd, 2014 · No Comments

November Report Writing Class Schedule

Five new classes are scheduled in November 2014 for training in custom report writing for Sage 100 Contractor (Master Builder) software users.

How To Write Custom ReportsJim Schuett will be instructing all of the classes, which follow his new book “How to Write Custom Reports” which will be the class materials for the courses.

Purchasing ($275) the new book includes 3 FREE class sessions. The book is now available on Amazon. Allow 1 week for delivery before scheduling a class time.


Purchase book on Amazon:  Click Here


For dates and times: Click Here


Solid Foundation: Basics for Beginners (Covers book sections 4,5,6,7,8)

  • 4       BASICS: Report Printing Screen. 9
  • 5       Where do you start?. 15
  • 6       Report Forms and System Reports. 16
  • 7       Report Wizard. 36
  • 8       Questions to Ask when Starting a Report. 42

TablesChoose right the first time (Covers book sections 9,10,11,12)

  • 9       Primary Table. 44
  • 10    Database Tables List. 47
  • 11    Expanded Primary Tables. 50
  • 12    Global Calculated Fields. 64

System ReportCreate a System Report (Covers book section 13)

  • 13     EXERCISE: Create a new report from an existing report. 66

Report FormBuilding a Report Form (Covers book section 14)

  • 14     EXERCISE: Creating a New Report Form. 89

Calculated FieldsSQL, Variables, and other Craziness (Covers book section 15)

  • 15          Calculated Fields. 108


→ No CommentsTags: Sage Master Builder

September 27th, 2014 · No Comments

How To Book-0001

“How To Write Custom Reports”

Available Now

TO ORDER:     Email request to Jim Schuett at

Report writing in Sage 100 Contractor (former Master Builder) can be difficult, but with some basic instruction, you will find it easier, and logical.In this instruction manual, I will try to make it as easy and readable, as possible, with lots of diagrams, and simple instructions. Feel free to go straight to the area you need for information, as you may already know some of the basics.When we get to the Resources Section, you will find many of the tools I created over ten years of writing reports in Master Builder. Most of what I learned came by trial and error (lots of error) as there was no documentation or manual beyond beginner’s instructions.My goal is to provide the opportunity for you and others to enjoy report writing as much as I have over the years. It’s a very creative and challenging outlet: creating organized reports that are easy to read, and provide the data you need.


Price: $275, plus shipping, (& sales tax, where applicable)

→ No CommentsTags: Sage Master Builder

Sage 100 Custom Reports

December 18th, 2013 · No Comments

Sage 100 Custom Reports

Master Builder is now Sage 100 Contractor

Jim Schuett, Custom Report Writing Specialist

Jim Schuett

Jim Schuett

My newest website is
 Please take a minute and see what our new look is.
Contacting me is easiest through


Writing Custom Reports for Master Builder, Sage 100 Contractor, is my specialty and focus.  For over 10 years I have been creating reports for Clients around the country to help them get the information out of Sage 100 in the way they want to see it.

I really enjoy working with you and finding solutions, although I’m not always able to create every report request, I can 85% of the time.

See some reports I have already created at:

Sage 100 Contractor is a full-service software specifically for contractors, but some of my non-contractor Clients find Sage 100 Contractor to work well for them.  Definitely contractors, subcontractor should be using Sage 100 Contractor (formerly Master Builder).

→ No CommentsTags: Bottom Line Design Services · Sage Master Builder

Sage 100 Version 19.2

October 30th, 2013 · No Comments

Sage 100 (Master Builder) has released version 19.2.

Please be sure to copy and save the following folders
BEFORE upgrading to 19.2:
1) Your SERVER’s MB7 / System Reports folder
2) Your SERVER’s MB7 / Reports Forms folder
3) Your SERVER’s MB7 / Custom Reports folder
SAVE these folders to a different place outside the MB7 folder.

→ No CommentsTags: Sage Master Builder

Sage 100 (Master Builder) Custom Reports for Clients

August 17th, 2013 · No Comments

Sage 100 (Master Builder)

Custom Reports for Clients


JOIN LinkedIn GROUP today, and receive

  • help and training with report writing,
  • tips & tricks using Master Builder software
  • group poll data, and add your vote,
  • get Sage 100 Custom Reports,
  • add to discussion of issues using Sage 100 (Master Builder) Report Writer
  • new reports available each week

LinkedIn Master Builder Reports Group 
LinkedIn Group sponsored by Jim Schuett & Bottom-Line Design Services LLC

→ No CommentsTags: Sage Master Builder

NEW California 2012 Lien Release Forms

February 20th, 2013 · No Comments

Sage 100 Contractor (Master Builder)
Lien Waiver Releases for California 2012
Available NOW:
Conditional Progress Lien Release
Unconditional Progress Lien Release
Conditional Final Lien Release
Unconditional Final Lien Release
Set of all 4 reports  .  .  .  $600
(ready to use in Sage 100 Contractor)

SACRAMENTO —The Contractors State License Board (CSLB) is alerting consumers who are hiring contractors for home improvement projects that legislation concerning liens against their property takes effect on July 1, 2012. While the new laws don’t substantially change protections for property owners, the wording and formatting of the release and notification forms have been altered. Property owners should use the new release forms after July 1, and contractors should use the new preliminary and mechanics lien notice forms to protect property from liens and uphold lien rights.

→ No CommentsTags: Bottom Line Design Services · New Reports · Sage Master Builder