Sage Construction & Real Estate

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!

We prepay a material vendor. The initial invoice to establish the credit on account is charged to a prepaid GL Account. The Vendor then sends tickets for the materials ordered/used. We need to job cost these ticket amounts and reduce the prepaid account…

Is there a best methodology for handling equipment ownership in a separate entity other than the main company? I would like to utilize the "Equipment" tab to track all items related to equipment utilized by the company. However, the actual ownership of…

Is it possible to add a field to a report that is not included in the tables offered in "Insert a Field" from the primary table of the report? I would like create a report that details GL transactions from all sources, including AP with vendor name…

Hi, I am looking at the credit card reconciliation and I have the grid open. I can't seem to figure out the logic to the order the transactions are sorted in, they don't seem to be by record, which would make the most sense to start off with. What I also…

Does anyone know of a bridge between Sage 100 Contractor and NovaTime for payroll?

When we post labor to GL do we have to break it out by every job and time and money? Posting to direct labor to jobs

Is there a known glitch with the drill-down capability on departmental income statements in the Sage100 Contractor 2017 V20.5? It just sits and spins when trying to drill down to see the detail within a general ledger account.

Sales Tax is included in our contract total... then when I issue invoice.. the sales tax is not included on the contract summary and it looks like what I've invoiced compared to the contract summary is short... how have you made these two totals match…

I need to pay a regular hourly employee a flat amount as he performed a task that was a flat rate. How do I put this amount on his pay without using the hourly amount?

Has anyone out there gone ahead and installed Sage 100 Contractor 20.4 on a domain controller even though it is suggested that we don't? If so, have you seen any problems with performance? We have a Server 2012R2 server that acts as our domain controller…

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…

I'm new to Sage 100. I created a takeoff and converted to a proposal to present to client but since the costs can only transfer by cost codes or bid items, the proposal does not show a description for each line item. For example, 1 cost code can be made…

Has anyone else had any problems with Sage 100 Contractor version 20.4 where permissions on the Company folder inside SAGE100CON are being overwritten by the MSSQL$SAGE100CON account that causes users to get an "Access Denied" error? This started happening…

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?

i stopped by the Sage booth at Dreamforce last week and was told there are Sage partners that have done integrations between Sage 100 contractor and Salesforce. Can someone please recommend a few of these partners to me? Thanks.

What menu item is used to change user permissions?

Does anyone know or use a service software that service tech's can use out in the field that is integrated with Sage 100 for 11-2 work orders?

any instructions would be great.

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…

Does anyone know of an app that will send data to 6-11-6?

Hopefully someone here will be able to answer my questions. I just bought the basic estimating module because of its ability to tie in to the accounting. However, I have some questions that I cannot seem to get an answer on. - 1. Can the input grid…

Does anyone know how to change the default save-as / export to folder? I'm specifically trying to export takeoff back up files and it always defaults to a MB7 subfolder

Equipment Maintenance looks to the hours so the employees can handle the oil changes on machinery.. I enter equipment allocation which changes the hours on the equipment. The allocation is a rough estimate of time machinery is used on the job for job…