Sage Construction & Real Estate

We have not closed the year and have entries awaiting to be posted once we roll our fiscal year-end date to 2021. We can view new entries in GL and our posting journals from other modules such as AP, JC, PR, etc. all have messages stating Posting to…

Dear team, When ever we review the amounts in GL , check amounts from PR is showing as PR Post checks summary irrespective of the original PR summary contains breakage pay roll to Salary, other allowances ,deductions , fringes and so on. Could you please…

Is there a way to create a report group? When I make financial statements, I can combine multiple financial statement reports into a financial statement group and by choosing that group to print, it will print all my financial statements for the selected…

When I run this report the costs up at the top is different at the bottom. it is $54,900.00 to be exact. Does anyone know why? Job cost is in the month of March I have posted and closed February. All modules are in the month of March. Please let me know…

Hello, Recently we have moved from a publicly listed company to a limited liability one and looking to change the name on sage reports .

I noticed that on the JC//Reports/Billing/WIP with cut-off date that the one of the commas is missing in the value e.g. $11,179,128 is showing as 11179,128.00 which is missing a comma between the million and thousand groupings. How do I fix it because…

Hello, I’m new to Sage and looking to access estimates through Power BI. I’ve connected through ODBC, but I do not see how to get estimate information, only Database information. any ideas?

When will the year end be posted?

Hello, What report do I run that will give me PR totals by a specific date range? Thank you in advance.

We have changed the AP invoice aging w/cut off to show the job number. It worked great except that it has a huge number of lines that have no dollar amount. These lines just show the vendor number and name as well as the job number and name. Can someone…

This is a standard report in the system we currently use and is called P/R Edit List by Job. We are in the middle of programming the Sage system and have run a mock payroll but it is not yet posted. However the above mentioned edit report is provided…

When we setup Invoice Approval in AP, one of the things we did was setup Approval IDs, so we could tell who approved an invoice. However, now that we've used this for a while, I can't find a report which displays this data. Is there a way to create a…

I'm looking to run a Customer Statement Detail by Accounting Date that includes retainage invoiced and paid. When I run the report, even though I have the "include retainage" box checked off, neither show up.

We use a custom crystal report for our AIA type billing. Previously the items in the ITEM NO. column printed in the order that they appear in the Contract (which is correct). Recently certain items are printing seemingly randomly out of order. We did…

We are a subcontractor for many different General Contractors. Many of our projects are OCIP's. I need to track the expiration dates of these OCIP certs. Do you know where / how I would enter them? Thanks, Bonnie

Hi everyone. I'm trying to compare revenue from two different systems. I'm not familiar enough with Sage 300 CRE. How do I print a list of all invoices created last year? I'd appreciate any help that could be provided. Thank you! Eric

When I enter an American Express bill or a bill from Paychex i also choose the add the additional column named description. As I enter each line item I place in a detailed description of the item Example would be 18-04 (Job) 01-002 (Code) 5002 (COGS…

I added a couple new accounts and they are not showing up on my financials. First one is not showing up on my Income Statement. I comparted the set up to others that are pulling to the financial and it is the same.Second-I made sure that it is included…

I usually use the year to date ledger to print the GL for 2 or 3 months. I'd like to print it for Nov-Jan but it won't allow me to cross into the new year. Any solutions or another report that I could use?

Good Day!!! I wanted to understand why the OCIP report and Time Entry Reports would come up with different worked hours and dollar amounts. After further review, I found that the OCIP report is calculating all OT hours at a regular rate. Is this normal…

Is there a way or method I can run a Profit and Loss for a specific time period - for example, 7/1/2018 through 6/30/2019?

When I run the "JC Receivables Aging by Draw as of Accounting Date" report, I can see all of the outstanding draws by job. However, some job numbers/descriptions show up and some don't. It's a standard report, but I've tried to customize it many times…

Estimate Entry was done mid December 2018, can even pull up the completed Printout. If pull a D3, there is nothing. How do I proceed?

On some reports at the end I'm seeing *!! at the end and was wondering why or what it meant

I am new to Sage 300, coming from quickbooks and I have not been able to get a certified payroll report out of sage that has all the information needed. Does anyone have a report they can send me that meet NJ requirements or suggest a website or consultant…