Sage Construction & Real Estate

Good morning, I'm trying to edit a report in report designer that's already in Sage 300, Job Cost module (Committed Cost Status report). I'm wanting to add a totals line per job when running the report for multiple jobs. Does anyone have the knowledge…

looking for away for when it comes time to bill. How do you have PM's mark up billing so you know what to bill, instead of just printing drafts.

I am wondering if anyone has had luck getting a 80 byte format for direct deposit from Sage 300 CRE. Is there a report that has been created that Canadian business can use?

Can total committed cost and yet to commit costs be added to the cost spreadsheet for all open jobs

Has anyone set up sub accounts in the GL using suffixes? We want to breakdown some of our expense accounts and are trying to figure out the best way to do this. Any suggestions would be super appreciated. Susan

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…

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'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…

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

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

Management has asked our HR person to track employee absences. These would be both excused and unexcused. At any given time, they want to request a print out of how many abscenses an employee has in a certain time period. Is anyone doing this?

I'm trying to create a formula within Sage to pull in the rehire date if there is a value but otherwise it pulls in the Hire Date so that I am pulling in the most recent hire date. I can't figure out what I need to use in order to have the IF formula…

Is there a way to show the labor hours worked and cost by employee on this report? It currently shows the totals for each pay period with "PR Summary" as the description. We are looking for it to show the employee name in the description with the hours…

Using Sage 300 CRE 18.1 I need a formula for pulling the Salaried rate of pay and the Regular rate of pay. We have holiday, Sick, and Vacation also set up. I just need to pull the pay rates for salaried and hourly employees. Can you help?

How do you deal with multiple cities that have their own sick leave requirements in addition to what the state requires? The state has provisions to put in a lump sum and not accrue or roll over but we are starting to do business in certain municipalities…

I need to design a report that combines a payroll deduction and a payroll fringe. I have two reports designed by previous employee that give me deduction and fringe on separate report, but would like them combined into one. Is this possible?

We have several operating divisions and we would like to be able to run AR Aging Reports by division so that each office could run their own aging report that only contains their outstanding AR and retainage items. We have the added problem of receiving…

I use a crystal report for our quick bill invoices. I need to add subtotals to the invoice. There will usually be 4-5 subtotals throughout the invoice. In quick bill, I have inserted the subtotals. However, in crystal reports, I can't get the total invoice…

Does anyone have a quick formula to calculate employees total hours worked by date (sum of regular, overtime and double-time)? Any help is appreciated!

We are going to track COI's for our subcontractors in Sage...they will be project/commitment specific. Where can I find the best articles for training? I was hoping for a step by step walk through. I've found several articles, but they mention different…

I am currently running a "Craft Summary Billing Report" using an access database that is pulling data from Timberline. That report is no longer accurate on some jobs because of revised billing labor rates. What reports do you use to show the project managers…

I am looking to create an addon for the backpage for Builders Risk Insurance (BRI). Currently BRI is being calculated as a Cost Basis "Total", based on the "Current Total." So the overall calculation is $0.14 x (Project Value / $100) . That is good…

I am trying to be more efficient with entering credit card transactions and expense reports into Sage. I know there is an import invoices function within the Tools tab of AP. I also know you need a .txt file to import. Was wondering if anybody has a template…

We are a subcontractor and have several Prime contractors that require us to submit our invoice by the 25th of the month. If not in their office by the 25th, then it will have to wait until the 25th of the next month. Since I am in AR, I don't always…

I wrote a macro to run cost reports so I can have 1 report per job. The macro runs fine the day I make it. When I run it the next day it does not work. I don't understand why it doesn't work. Please help. Using Sage 300 CRE.