Sage Construction & Real Estate

We are relatively new to reports in Sage 300. What is the "go to" report to get the amount committed/paid vs. the estimate. Basically remaining liabilities I believe. Any hints to help us make sure this is accurate? We use SCPC as our Project Management…

When creating a list of Parts, SAGE includes all parts ever utilized. Is there a way to only list ACTIVE Parts? For example, in other screens there are options to filter a report by only Active Jobs or Current Employees. I do not see such an option…

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?

Hello, we recently migrated one of our customers to a new server and now they are reporting very slow printing. I Googled and found a reference to a KB 100949 that may be the information we are looking for. However it can't be located. I found this…

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

When trying to close my Accounting month, for the last 4-5 months, I get an error advising "GL Master File in Use" and the Accounting cannot be closed. No one is using the Master File when trying to complete this task and the only way we've been able…

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

I need to pull a report that shows all of the following information for our past fiscal year: Vendor name, address (CSZ) number of checks, total amount paid to vendor, Type of payment (Check, cc, ACH).

Is there a job cost report that will print only what has been paid? We are needing to know what has been paid by cost code on a specific job.

How can I add a custom crystal report into a Sage 100 Contractor menu screen?

What is the difference between Married and Married M2 in Sage? Which one would I choose for Married Filing Separately?

I used to be able to save a report as a plain text (.txt) file and then open in Excel. Now even though I specify to save as .txt it automatically saves as .pdf. I can convert to .xls but I do not retain the forrmat (columns, etc.) This is a sudden change…

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…

My company is currently considering switching to direct deposit from paper checks. I think I've more or less figured out how setting up direct deposit works, but what I haven't been able to find is if emailing pay stubs is possible with Sage 300 CRE?…

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?

Is there a way to run an inquiry simply on Payroll by Job Number and export to Excel (not a report) I find the Sage Reports very clunky and hard to manage. Similar question can you run an inquiry with Job # and Amount Invoiced Thank you

I am new to Sage and looking for a report that shows the pay details for the entire company. The Employee Totals by Period has the look I want, which shows a breakdown of pay items, deduction items, etc, for each employee: I tried adding totals at…

I have a cost showing on JTD cost in job report, but amount was not paid. We send POs to a vendor, but only pay off of invoices. In POs by job, it shows a PO amount and amount invoiced, but Amount Paid is 0. What do I need to do to eliminate this from…

I'm looking for a report that shows me the current contract dollar amount and how much we have been paid for that particular contract.

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?

What report can I run to tie into the W-3 form?

Does anyone have a way of pulling specified text from within an alpha field, from right to left? Example: Job Description field contains: Hudson - Model I want to report to be able look through all job descriptions and identify which ones have 'Model…

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…

How do I get the Gross wages and hours report for the prior year and is there one that also includes 401k, Roth and loans on it?