Sage Construction & Real Estate

I am having a difficult time trying to figure out how the labor cost is being calculated on the 6-1-2, labor cost reports. they are varying highly for my designer. the same job had one days work at 31.80$ and another days at 75.20$, regular hours, not…

Reports starting giving the following error: "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name:index". This just started happening on the latest update. I've been using these same reports for years…

Is there a report that allows me to see the gross sales by customer? Sage 100 2017 Contractor

Isn't there a basic bank rec report that will spell out the bank reconciliation? I have run 1-5-0-21, but the "account current balance" at the bottom of the report is very misleading, as it reflects today's GL balance instead of the GL balance at the…

Anyone have any luck modifying reports to be more Excel friendly? I'm used to pulling G/L details and Job Cost details into Excel to put them into PivotTables or Filter by specific jobs and/or codes, but the System reports have too many page breaks. It…

I am looking for a cash flow statement that can be ran based off budget numbers entered into Sage 100C. I realize that this would be a custom report and would need criteria entered, ie AR & AP turnover, etc. Looking for ideas, a report writer, or utility…

I need a cumulative gross wages report based on custom dates, not quarters. Can anyone point me in the right direction?

This is our first year in sage, so as we are looking towards tax season we are curious how all of you pay your taxes. We have traditionally used Cash basis so now feel a little lost not seeing a cash income statement. So if you pay your taxes in Cash…

How to write SQL statement for percentage in subtotal and total rows? Getting % on detail rows is no problem, but when trying to get a % on the subtotal or total rows eludes me. Any help on this would be greatly appreciated. Thanks so much!

I need to print a payroll summary, by employee, that shows gross payroll and overtime paid over a specific time period. For instance, For the period 1/1/13 - 4/30/13 Employee Gross Wages OT Wages John Doe 10000 425 Jane Doe 6500 0 Johnny Doe…

I am a Commercial General Contractor. I am new to Sage and am quite surprised to see Sage 100 doesn't have a stock Subcontractor Payment Application form. Typically, I have used these Forms to recap a Subs Progress in order to issue payment. We issue…

Hi there, I am looking to find out about specifically Certified Payroll reporting. We use the standard DOL report, but it does not fill in the Work Classification. I would like to know if I can add that and how, and where the information pulls from…

I am looking for a Check run report that also includes the 4-2 line detail, specifically the GL account and dept. Is this possible through a report or query?

Contractors in California received the following notice from the Department of Industrial Relations today (5/26/16): News Release No.: 2016-54 Date: May 19, 2016 Enforcement of the Requirement to Submit Electronic Certified Payroll Reports…

Is there a report in 3-7 that shows progress bills that were created the month before?

Brandi Lube The CA Dept of Industrial Relations has stopped accepting pdf files for reporting certified payroll reporting that has to be uploaded to their site. I am fielding multiple inquiries from customers on how to create these files from within…

In Sage 100 Contractor, is there a restriction on the maximum size the file can be? I have a client who set up a 20 page report form, and only 13 pages will show? Most of the pages have a bmp image of the text documents, so the document can get relatively…