Sage Construction & Real Estate

I can't figure out the formula for committed cost - anything that has already been invoiced. We want a report that includes all committed cost - whether it has been invoiced or not and I can't figure out a formula to use to get that information in the…

Wondering if anyone can help me. Since the last upgrade I have been having this error anytime I open a Sage/Timberline CR Report "The saved data will be discarded since one of more formulas failed to compile I can create new reports without issue…

Has anyone revised the canned Purchasing Report "Order Details by Job" to subtotal by job or at least a bottom line total if you range it 1 job at a time?

I would like to be able to take a P&L financial statement and add an additional account "below the line" By which I mean that I'd have the normal P&L for the operations of the business and after that have an additional line which I want to use to reflect…

I'm new to Sage 300 CRE. We are working on setting up the job cost - cost code list and reports. We are moving from QB. Does anyone that works for a underground utility (wets/drys) subcontractor want to share with me their cost code structure and a sample…

Hello, The invoice format shows up as a .crs file, but when I use Crytal Reports to open it to edit the format I get the following two error messages. The report design will then open but it is in a format which I am unable to edit. Any help would…

I understand that I can save a report to excel and get a count that way, but is there any way to add a formula that would count employees within some of the reports (report designer) we run most often?

I use Sage 300CRE. I'm looking for a way to make notes on AR Invoices for payment schedule. Essential after I send statements Clients email me telling me the expected date of payment but I have no way to make a note in the system saying I spoke with them…

Does anyone have a contact for DIR xml template and LCP Tracker xls file to be produced from Sage 300 payroll data? I realize it probably needs some customization, but wanted to know if someone could recommend who to contact.

Does anyone use a custom-built Office Connector WIP report?

There was a report created before my time called "Check Activity with Detail." When you drill down from Tasks, enter checks, then F4 for Private view and we manually delete lines from an employee, they show up on the above referenced report as blanks…

The 2022 CA SPSL law requires that we list the number of hours taken on a paystub (or on a memo) even if those hours are 0. The hours can also be reported on a separate insert, but with weekly payroll, that becomes quite burdensome. According to KB…

We are an Ohio company that is looking to streamline some of the payroll processes. Not necessarily to outsource payroll, since we are in the process of developing our own program to enter daily job cost/payroll into the system via Office Connector. However…

I am working on cleaning up our purchasing module for Sage 300CRE. Prior to some time ago, all material was not being received into the system. More recently, we have been adament about receving everything into the system that comes in so that our recording…

I've tried different formulas. The calculations are working fine. However, if an employee has never taken the SPSL sick, CA requires the stub to show the zero amount for the pay ID related to SPSL. Sage 300 CRE PR automatically removes any zero amounts…

Can I report a profit and loss from 02/01/2021 through 01/31/2022, if so how?

Does anyone have a report that runs AP invoices by job AND includes the check number and check date? I found the A/P Payment Register by Job but it doesn't include the Invoice Number(s) and I'm not savvy enough to adjust the report to include the invoice…

Using this for our customized Paystub Template: Is there a formula I can pull or what is the formula for YTD Net please? TIA!

Is it possible for an individual PO for a contract item to print on the invoice? (from the contract item reference)

I'm new to Project Management. Where under File, Company Settings, Custom Descriptions would I add another "Document Type" for a transmittal. I can't seem to locate where I would add it. I've customized other lists before but can't seem to locate this…

We are located in Okotoks Alberta and are looking to hire someone on a contract basis to create custom reports in Report Designer. Can anyone help us out with this? Sonia

Can you change the footer/tagline in the My Assistant emails so it is customized for our company? I found the KB article to remove it altogether, but would rather be able to customize it.

We are a drywall contractor. Wondering if anyone has developed a report to use as a basis for entering their weekly time into payroll. Something that could be used to verify the information in Sage Payroll prior to printing checks.

When I paste the 4 columns (O through R) into cell A1 of the report Template provided by Sage 300 CRE, I get the error message "#NAME?" and the final report is never produced. Does anyone know what is going on that the formula is not working in the Template…

I have two companies in one database seperated by gl prefix. I need to run a report showing total paid to my sub contractors for an entire year. I don't want to run this report in AP using the Sub Contractor indicator I want to use the gl line that it…