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…

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

We have been setting up phases in Sage 100 Contractor for each small job for a customer instead of setting up several small jobs. We then have been billing each phase. It is my understanding that we can not close the phases in sage 100 contractor. …

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.

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!

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…

Is there a billing report that can be run when I've completed billing for the month which shows the customer, the project and the amount billed for the month and the total billed to date?

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…

Report 6-1-12-51 Committed Cost-Developer. How does this report for Developer differ from regular reports? There are asterisks after some items, but no description of what the * means.

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…

I am a long time user of Sage 100 Contractor (formerly Master Builder). I need more flexibility in data reporting from the system. I have read that Sage Intelligence Reporting and Liberty Reports are two add-in options. If you have experience with either…

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…

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…

I'm trying to build a report that will allow me to select job costs for a list of jobs that have no work order assigned. How do I set the criteria to select null values?

We sometimes have multi page AR invoices. Prior to my joining the company, reports for specific number of pages were created so our terms and total print on the last page.I'm making some changes that will result in having different invoices for different…

Hi, I'd like to run a Detailed Submittal Log report. Something that shows the submittal number & title, the date it was submitted for review, the returned date and the current status of the submittal. Can this be done in Sage 100? If so, does it require…