Sage Construction & Real Estate

What is the difference between running a payroll report by period end date and running it by check date?

In the users guide there are these functions for AR but it does not tell us exactly what they are doing and how it is determining it. In the AR Statement (CR) uses these functions, but i am getting some strange answers. I believe it has to do with the…

I updated the date in AP for the current year, but the misc 1099 report is still pulling amounts from 2023. How do I get it to populate from 2024?

Looking for a report or inquiry that provides the detail data below. Any suggestions? Job # CO # Cost Code Category Units Price Total Price Cost Total Cost

When building a macro, if I select "new" file and "current" file, all the costs double when the report prints. This happens when there is nothing in the "new" file (everything is posted in all applications. All conditions are equal.) I've changed the…

I already own Crystal Reports. Is there a way to edit the Crystal Reports from Sage with my existing license and not purchasing the Sage version of Crystal Reports?

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…

Doing payroll and for one employee, I'm only paying them for an expense due. The $250 expense shows up on my time journal, Payroll Post Checks Report and the actual direct deposit check printed out. But when I look at my Check Recap by Employee, which…

I'm looking for a report in Job Cost that shows what we've invoiced to a particular job, when it was paid, invoice number, etc. The Job Cost/ Receivables Aging by Job report only shows open invoices. Once the invoice is paid, it is removed off of the…

I m looking for a report that shows employee's name and wages for a particular job and a certain time frame.

If I have a Cost Code that we no longer use and I want to delete it from the list, what are the ramifications of doing this? If I ran a report where costs were associated to the Cost Code, would they disappear? Would to Description of this Cost Code…

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

On the Job Cost Report for one of my jobs, the Subcontract total for a specific cost code is missing the amount of one invoice. The invoice was correctly put to the corresponding Commitment. The correct amount shows up on all other JC reports. But for…

I need a report that shows all employees that worked on a certain job on a certain day. Can someone help me?

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 have just run my Quarterly Payroll Reports. My Quarterly Employee Count Report is missing 4 employees. But these 4 missing employees have wages on the rest of the reports (Subject to Employer & Subject to Employee). The one thing in common with these…

Does anyone use the Sales Lead feature in Service Management? I have set up Lead Types under Setup- Sales Lead. Now when I go to a work order, on the general tab, and use the drop down meanu for 'Sales Lead', nothing is listed. It says NONE. How can I…

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…

Can anyone line up the office connector reporting to the following report within AP AP --> Reports --> Invoice Regesiter --> Invoices Selected for Payment I would like to generate this report within Office Connector to have the information within…

We are currently integrated with Procore, so all our subcontractor invoices are created in and synced from Procore to Sage, so we do not enter invoices manually. When our subcontractors bill their retainage, it creates a $0.00 invoice in Sage. Does anyone…

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!

We need to run a Job Cost report in Sage 300 CRE for a specific job and period that includes the invoice images for the invoices included on the JC report. We import invoices from Timberscan but the TS Job Cost Inquiry report file is too large to email…

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

EFT payments fail to print on check registers. And I called support & was told the direct deposit (Nacha) file automatically generates-it does not. The report only shows employee names with total of all deposits to multiple accounts, no routing, no account…