Sage Construction & Real Estate

Hi, I am working on the closeout package for 2023, I know a it late, however I am having issues matching the trial balance apparently some transactions were voided after everything was sent to the CPA. I need a way to a report with voided transactions…

I need to build a Client Average Days to Pay Report. Has anyone built one? Any suggestions? Thanks,

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…

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

When running 5-1-1-22, the raise history field is not showing correctly, yet when going into the employee file and using the Raise History button, it shows as it is supposed to.

Hey All, We are still new to Sage 100. I can run a report to see what we invoiced for each month. (3-1-2 Report # 21). However, I was wanting to run a report to show everything thus far this year. January till November. Is there a way to do that? To…

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.

Can anyone advise on what the "*" means next to the date on the Check Register Report 2-6-0-21 ? Thanks for your help in advance!

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???

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…

When modifying a report, there is an option to enable 'or' logic in the selection criteria. I'm having a hard time setting this up and wanted to see if anyone has had success with this.

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…

I just voided several checks for a vendor. How do I run a voided check report?

Hi there, I am looking for a report that can confirm purchase orders and contracts that are open but do not apply to any specific jobs and are strictly overhead expense booked to the GL accounts.

I was looking for a solid report for our service department efficiency and could not find anything I liked. I created a report which captures the number of days from call to schedule, schedule to invoice, and the total days from call to invoice. Enjoy…

Hello, i am trying to figure out how to add the task name to the purchase order. We have our system set up to export P.Os. by task but without the task name on the PO it makes it a bit difficult to determine what it is for. Any suggestions on what to…

Is there a report in sage that can show jobs closed during any given year or specified time period? I know that when you pull an old over/under extended report it will show the job for what ever the current status is so it is sometimes hard to track…

Hello All, We use the Union Paygroup Report (5-1-7-31) in Sage 100 Contractor to pull information for our monthly union remittance. This report can only be run by period end or check date. I'm looking for a way to run it for the entire month (i.e. 1st…

Hi there, looking for solutions on how to get the following reports to run in the jobs. What is required on entry? I would like to have something in the following format, i have put in an example below Cost code XXXXX Budget line item base…

Error: Knowledgebase article says: "Error: Exception of type System.OutOfMemoryException was thrown running the 6-1-2 report (version 19 and earlier) Enhance export to MS Excel engine Exception of type System.OutofMemoryException was thrown Job…

In Report Writer, Sage 100 Contractor, is there a way to use the selection criteria "in list" with a variable like {variable[N]}? In this case, I am using {Job Number[N]} to select Job Number in SQL statement where job number is not in the Primary Table…