Posts in category Reports

New Sage 100 Contractor Report-PO List

New Sage 100 Contractor Report-PO List

Another New “Sage100Reports.com” Report

For Sage 100 Contractor (Master Builder) Clients

06-06-02-06 PO List by Job/Cost Code/Vendor

See Full PDF:  [download-attachment id=”1726″ title=”6-6-2-6-PO List by Job-Vendor-CC with Variance”]

__________________________________________

TO ORDER, CLICK “ADD TO CART”:

__________________________________________

thumbnail of 6-6-2-6-PO List by Job-Vendor-CC with Variance

__________________________________________

I’ve Been Thinking

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

Need Help Writing Custom Reports?

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

SAGE INTELLIGENCE REPORTS AVAILABLE

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

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: https://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

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:     [email protected]

Website: Sage100Reports.com

Custom Reports: Sage 100 Contractor

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.

 

 

Sage 100: New Report

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 [email protected]

Logo

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

 

 

Sage 100 Master Builder Class Schedule

Sage 100 Master Builder Class Schedule

November Report Writing Class Schedule

5 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 AmazonClick Here

 

For dates and times: Click Here

CLASSES AND CONTENT

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

Tables: Choose 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 Report: Create a System Report (Covers book section 13)

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

Report Form: Building a Report Form (Covers book section 14)

  • 14     EXERCISE: Creating a New Report Form. 89

Calculated Fields: SQL, Variables, and other Craziness (Covers book section 15)

  • 15          Calculated Fields. 108

 

Sage 100 Report Writing Book

Sage 100 Report Writing Book

Sage 100 Report Writing Book (270 Pages)

BOOK: “How To Write Custom Reports” in Sage 100 Contractor (Master Builder)

Click Here:  Now Available  for More Info

How To Write Custom Reports

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

Verified by MonsterInsights