Sage 100 Contractor & Master Builder Custom Reports

I’ve Been Thinking

I’ve been thinking.

Jim SchuettNo, really!

…wondering about how all the things we do each day, how we do them, and the things we don’t get to.

I’ve been thinking about how much of our brain we actually use, or more to the point, how much we don’t use!

I truly know that I’m not the sharpest nail in the pound box, but definitely do use some of the old grey matter upstairs.  In fact a decade or so ago, I realized that I had been diminishing in my mental capacities, and realized I needed to do something about it.

I’m going to go in two directions from here:

  1. Where its led me
  2. How we view ourselves and our role in the complexities of the universe.

First, where its led me…

In 2001 I went to work for a friend, a subcontractor, and found some satisfaction in helping him and his company, but found the limitations of someone else’s pace, goals, and directions. While there I chose a new software for his company, Master Builder (MB) Software. I became a certified consultant for MB, staying with this friend and his business for 4 years.

When I moved to another company, another MB user, and found they were going bankrupt, and only wanted me as a last ditch effort to save their company. Again, someone else’s pace, goals, etc. and something I could not do, as they were too deep in the hole.

I came upon a moment of decision, unemployed, still a MB consultant. The one thing I loved the best about MB was writing reports inside the software. and so decided to concentrate on using my talents, and passion, to write reports for clients where ever I could find them. This is when my mental capacities started to sharpen, and brought me back to where I hoped I’d be … growing, excited, and a little scared.

Long story, short, is since 2002, I’ve been writing reports for MB, now Sage 100 Contractor (S100) Software (former Master Builder). I truly believe it saved my life.

And you, my Clients, are treasures to me.

Part Two of this discussion, Us and the Universe.

The thought came to me this morning, “Do we really only use 10% of our brains?” And if so, what can we expect to do with the other 90%?

Looking at all the creations in the heavens, and here on earth, and with my understanding of Heavenly Father’s plan for us, I know that “beyond the veil” of this world, we will be able to use all 100% of our capacities there.

sacred-grove-402378-print

So what of now?

Our role today, and everyday, is to learn and grow as much as possible in this life, serving others, sharing our talents, living as honest and productive life as we can, so that when we walk through the “veil” we are more like Heavenly Father, and are more ready to serve Him there. We will continue to grow throughout eternity.

Back to our brain usage:    I “googled” this question:

Do People Only Use 10 Percent of Their Brains?

…and found that we do use all our brains. It’s really quite amazing … no, truly amazing.

If you get a chance, read the article I found:

http://www.scientificamerican.com/article/do-people-only-use-10-percent-of-their-brains/

This has been an unexpected post this morning, just something that came to me to share. Thanks for listening, Jim Schuett

Learn to Write a Custom Report

Learn “How to Write a Custom Report”

in Sage 100 Contractor (formerly Master Builder)

How To Book-Cover

SEE TABLE OF CONTENTS BELOW

Price: $275, plus $4.00 shipping

TO ORDER:

  • Call or Email Directly

  • ( 480-277-7550,  jim@B-LDS.com )

  • Order on Amazon

One FREE CLASS (Up to 1-Hour):  With your book purchase, receive One FREE  (Up to 1-Hour) “One-on-One” Report Writing Class.  Read through the book, make a list of all your questions, then schedule time for our class…just you and me, and I will help you with your questions.

REVIEWS:

Amazon:  Most Helpful Customer Reviews

5 Stars  Great resource tool   By BRITT STEINHARDT on November 22, 2014

“This is a MUST for any Sage 100 Contractor user, consultant or business partner trying to write/modify reports in the Sage 100 Contractor software. Jim’s online training sessions are also an invaluable tool. You can tell immediately when you open the binder that Jim has spent many hours compiling this document, and to me that shows that Jim cares about his clients and his work. Good job Jim.”

5 Stars  Highly recommend! 5 stars

By Stephanie C. on April 7, 2015

“This book is a tremendous help for anyone who uses Sage 100 for their reporting needs. It covers all the basics and includes sample calculations and SQL queries. The included consultation with the purchase of the book is extremely helpful and having the author available for assistance is invaluable in itself. I highly recommend this book for custom report writing in Sage 100.”

 

9-27-2014 12-38-22 PM

9-27-2014 12-39-07 PM

9-27-2014 12-39-31 PM

 

 

 

Need Help Writing Custom Reports?

Need Help Writing Custom Reports?

In Sage 100 Contractor (Master Builder)

How To Book-Cover

Book Purchase includes 1-Hour Free “One-on-One” Training Class.

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 try to make it as easy and readable as possible, with lots of diagrams, and simple step by step instructions.
  • Feel free to go straight to the area you need for information, as you may already know some of the basics.
  • When you get to the Resources Section (and throughout the book), you will find many of the tools I created over twelve years of writing reports in Master Builder, most of which I learned 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.

REVIEWS:

Amazon:  Most Helpful Customer Reviews

5 Stars  Great resource tool   By BRITT STEINHARDT on November 22, 2014

“This is a MUST for any Sage 100 Contractor user, consultant or business partner trying to write/modify reports in the Sage 100 Contractor software. Jim’s online training sessions are also an invaluable tool. You can tell immediately when you open the binder that Jim has spent many hours compiling this document, and to me that shows that Jim cares about his clients and his work. Good job Jim.”

5 Stars  Highly recommend! 5 stars

By Stephanie C. on April 7, 2015

“This book is a tremendous help for anyone who uses Sage 100 for their reporting needs. It covers all the basics and includes sample calculations and SQL queries. The included consultation with the purchase of the book is extremely helpful and having the author available for assistance is invaluable in itself. I highly recommend this book for custom report writing in Sage 100.”

For “Page Views” & more info:  View 
Price: $275, plus $3.99 shipping

Available Now on:   Amazon

Small Business Guide to Social Media

“Small Business Guide to Social Media”

Available from SAGE for download. Go to: Sage Social Media Guide

With the explosion of Social Media usage, THIS IS A MUST READ!

 

Social Media-008

Spreading the word with social media.

Social Media Guide

Sage logoThe rise of social media has been so rapid that it’s easy to feel left behind. And it’s not just a personal scene anymore – many businesses are using sites such as LinkedIn, Twitter and Facebook to attract followers and fans.

Social Media-007

If you run your own business, social media offers you the chance to spread the word about what you do. It enables you to build a reputation, forge new relationships and bring in new business.

 

But if you haven’t taken the plunge yet, you’re not alone. According to research by specialist SME insurer Hiscox (2012), only 57% of small businesses currently use social media to support their marketing efforts.

Social Media-001

 

 

 

 

 

Just listen at first and then gradually start responding and striking up conversations. Spreading the word with social media And research by The Neilsen Company has found that 53% of adults who engage in social networks are active followers of a brand.

Social Media-002

“It’s never too late to start. You definitely haven’t missed the boat,” says Alex Truby, consultant at social media consultancy Fresh Networks. “There are exciting opportunities for most businesses on social media.”

  • Provided by Sage Software.
  • Presented by Jim Schuett, Sage 100 Contractor Custom Report Writer

 

New “Answer Man” Newsletter

New “Answer Man” Newsletter & Services

For Sage 100 Contractor (Master Builder)

 

  • ANSWERS TO YOUR 4 QUESTIONS MONTHLY ON SAGE 100 TOPICS
  • 1 FREE EXISTING CUSTOM REPORT PER YEAR
  • MONTHLY NEWSLETTER WITH TIPS & TRICKS, TRENDS, AND MORE
  • MONTHLY SUBSCRIPTION: $45
  • Not a substitute for Sage Support or your Sage Advisor

AM Newsletter-HEADER-900w1

 

 

Did you know?

See all of this and more inside the Answer Man Newsletter (12 Pages)!

  • Your company can “update” it’s image with a new website very easily.
  • Dozens of new Sage 100 custom reports are created every month.
  • Sage has a booklet “Top Ten Time Wasters for Constructions Companies.”
  • Even if you missed Sage Summit, you can still view a lot of it online, now.
  • There is a “wildcard” search feature in Sage 100 Contractor.
  • You can also VOTE on existing Sage 100 Enhancement requests.
  • You can submit Sage 100 Enhancement requests to improve the software.

CLICK HERE HERE SEE SEPTEMBER 2015 ISSUE

CLICK HERE TO SUBSCRIBE

AM Newsletter-2015-09 Sep-Page 1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

CLICK HERE HERE SEE SEPTEMBER 2015 ISSUE

CLICK HERE TO SUBSCRIBE

AM Newsletter-2015-09 Sep-Page 2

 

 

 

 

 

 

 

SAGE INTELLIGENCE REPORTS AVAILABLE

Jim Schuett

 

SAGE INTELLIGENCE REPORTS for SAGE 100 CONTRACTOR (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 here as each is created.

Let me know what you need, and I will do it for you.

AVAILABLE NOW:

Payroll Records by Employee

For more info & to view report, Click Here.

Also see up to 20 reports that come with Sage Intelligence Reporting.

New Reports

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.

BELOW:    Pictures of these 10 Reports (one page picture for easy review)

  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

ALL REPORTS WORK INSIDE SAGE 100 CONTRACTOR – NO EXTERNAL SOFTWARE NEEDED.

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: http://www.sage100reports.com/?page_id=40

10 NEW REPORTS:

_____________________________________________ 02-02-00-05 Bal Sht-12 Periods 02-02-00-05  Balance Sheet – 12 Periods _____________________________________________

02-03-00-20 Ledger Subaccounts-12 Periods 02-03-00-20  Ledger Subaccounts – 12 Periods _____________________________________________

03-01-01-00 Client Credit Application 03-01-01-00  Client Credit Application _____________________________________________

03-01-01-07 Job Progress Status Report   03-01-01-07  Job Progress Status Report  _____________________________________________

03-01-03-05 Dept Current Aging 03-01-03-05  Department Current Aging  _____________________________________________  

05-01-02-17 Payroll Detail~by Employee (Select Date Range) 05-01-02-17  Payroll Detail – By Employee (Select Date Range)  _____________________________________________  

06-01-06-01 Job Status Detail~w-Cost Type Budget-Costs-PO-Subc Totals 06-01-06-01  Job Status Detail – with Cost Type: Budget, Costs, PO & Subc Totals  

_____________________________________________  

06-01-08-00 Bonding Report w-Period Select-By Status-Dept-Job 06-01-08-00  Bonding Report with Period Select, By Status / Dept / Job  _____________________________________________  

06-01-08-09 Bonding Report ~w-Hours-Costs by Type 06-01-08-09  Bonding Report with Hours, Job Costs by Cost Type _____________________________________________

(picture coming soon)

09-05-00-19    Takeoff Detail with GM% Variables

  • 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    

Liberty Reports for Sage 100 by Jim Schuett

FROM JIM SCHUETT, SAGE 100 CONTRACTOR (Master Builder) – REPORT WRITER

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.

Always at Your Service,

Jim Schuett
Sage 100 Report Writer & Advisor
Bottom-Line Design Services LLC
9525 E Doubletree Ranch Rd., Suite 101
Scottsdale, AZ 85258
Mobile:   480-277-7550
Email:     Jim@B-LDS.com

Website: Sage100Reports.com

Custom Reports: Sage 100 Contractor

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

Call or email me to discuss your requests.

  • 480-277-7550
  • Jim@B-LDS.com

 

 

Sage 100: New Report

Sage 100 Contractor (Master Builder)

New Report Available: 

6-1-2-06 Job Cost Journal with Budgets, Actual, Hours

See a sample below:

  • Shows Actual and Budget by Cost Type for each Cost Code
  • Shows each Job Cost entry by Cost Code
  • Easily compare Budget Cost Type & what Cost Type Actual Costs were entered
  • Quickly assess job progress including totals to date at end of report

6-1-2-06 Job Cost Journal w-Budget, Actual, Hours

Important Note: Budget numbers will not show from budget cost codes unless the jobcost cost code has a job cost.

Easy solution: Enter a one cent job cost in missing budget cost codes. (Demo available on how easy this is to do.)

 

Report is $495.  For more info, or to order, email Jim Schuett at jim@B-LDS.com

Logo

 
 
 
 
Bottom-Line Design Services, LLC
(480) 277-7550