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…

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…

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…

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…

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…

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 just voided several checks for a vendor. How do I run a voided check report?

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…

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…

Hello All, We are new to Sage and are wondering if anyone here has tried to and successfully implemented converting your Internal Cost codes to the cost codes a client wants for invoicing. I think that it's possible via coding a report to translate…

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…

Does anyone know where I could find information for the syntax that Sage 100 Contractor report writer requires with respect to SQL. I am trying to write a report for Committed Costs that is different from the report included with Sage, so I need to write…

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…

Hi, We are working with Sage 100 Contractor. We are using Subaccounts in our General Ledger. We want an Income Summary with Subaccount Detail Actual/ Budget report. Currently S100 has an Income Summary with Subaccount detail Actual/ Income, but no option…