Welcome to the Sage Construction and Real Estate products Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
I am having my books certified by a CPA and she is aksing for a report that shows contract totals and change orders by year. Does anyone know if there is a report that does this? If so what it is, or can it be designed?
One of our local counties is requesting a list of subcontractor's, Tax ID and amount paid for 2023 for their jurisdiction. Can I run a report for this?
We are new to Sage 100. We are trying to run a report that shows what we invoiced, and any payments/debits made. We ran report 2-3-21. However, that report is showing every invoice we received for the month even though it wasn't paid. Some of our credit…
Reposrt 05-02-08-61 report I would like summarized by employee and grand totals. I have done it before, but saved as a shared report. We got a new server mid last year and I lost the report. I need it for an audit due on Feb 1, 2024. I know it is simple…
Our monthly union benefit payment is split and 9 of the benefit calculations get paid to one place and 3 get paid to another. As far as I can see the Union Reports (for ex. 5-1-7-31) total the benefits by paygroup and unfortunately the report is not modifiable…
Report 3-4-21 (at least in the Canadian edition) is cutting off the dates when you print the payments. This has been happening for a while, but we were hoping it would get fixed in a subsequent release
I'm finding contradicting information for when to process and print W-2s while reading all of Sage 100 Contractor's year-end checklists, guides, timelines, etc.
I know that you need to install the year-end tax and software update before doing either…
The purchase order audit report does not include the sales tax in the received columns, even though it has been inputted during accounts payable data entry against the PO. Can this be corrected?
I am trying to write a report, i have a if then and select syntax.
Does anybody know the correct code for the tmcdln.crtfid table/column
I want the report to be able to select sum from the tmcdln.hrswrk based on a y in the tmcdln.crtfid column.
…
How can I change the calculation for Yr-to-date Gross Wages on a pay stub to include Calculation Add ons? I've tried a few different calculations & modifications but can't seem to find the correct one, so on our pay stubs it's not reflecting the additional…
We have purchased Sage 100 Contractor - Canada about a year ago. it was an upgrade from Sage 50.
we had great support setting up Sage 100 and transferring our account information from Sage 50.
the person used for this has since retired and we are…
I am running a report and get report error "invalid object name mscfld. I have changed the report form to the system report, no change, and searched the code for the word invalid, none was there.
Custom reports and report forms in Sage 100 Contractor have been "infected" with this "field" rptclc^clc001, 002, etc.
I have seen this before but not to this extent. It is massive.
Has anyone else seen this before?
Or know what causes this…
I'm preparing for a general liability audit. I need to report employee wages (ytd total) by position and worker's comp code. Does a report like this exist???
Updated software to version 24.3. Closed 2022 Payroll Year. Did not archive 2022 payroll records. Printed first checks for 2023 and the YTD Gross Wages on check stub includes wages from 2022. YTD Amounts for Taxes are correct for 2023. Using the standard…
Good morning,
I was working in my test company trying to add our new company logo to my progress billing and somehow it affected my real company and everyone's reports had the new logo and made them all look different.
Has anyone ever encountered…
Hello - I am struggling with the report writer and need some clarification (a long shot, since there is almost 0 documentation on the subject). I am proficient in T-SQL, so am confident in my ability to write queries, but can't get something very simple…
I am in menu 3-7, and am unable to see the complete description of the Line item when the continuation sheet is printed. We have a very particular client that needs everything spelled out and nothing abbreviated and therefore need the entire description…
Good day, I have a job cost report for several projects that was set up to auto email every week to my email. We have long since completed these jobs and moved on to new jobs. I have two questions:
1. How do I remove the old job automated report emails…
I'd like to be able to pull a Gantt chart that shows everything going on in a month/quarter, ideally for the whole business and by supervisor. I've dug through all the report options and can't seem to find anything, but the Gantt charts are kind of useless…