Sage Construction & Real Estate

Similar to below but I only want to return invoices where the month and year do not match. The day of the month doesn't matter. I'm sure it's a formula but I don't know how to "join" the month and year together in a formula for comparison.

We are looking to edit the way our format for the schedule of values outputs & prints, is there a way to edit this? Or is this a default that is unable to change? The same goes for our estimate template.

How do I go about generating a list of vendors sorted by their payment type? I want to know which vendors I pay are paid by EFT, Cheque, etc.

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?

Hello, We have a division project that caters to small projects. We are thinking if it's possible on the job cost to have Extras for the cost code. Is anyone knows or did that before? Your suggestions will be highly appreciated! Thanks!

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

How do people track employee's veteran status in Sage?

is there a formula I can use to split an employee name in an Inquiry

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…

When I delete data in a field in Microsoft Access and refresh, the application closes. It only happens with the one specific field "Vendor_Custom_Fields_Nots" from the APM_MASTER_VENDOR_CUSTOM_FIELDS table. I accidentally entered data in a field and now…

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…

Hello, If you wanted to take information that you usually put in a excel spreadsheet and add it to Sage for everyone to use, how would you do it? Example - Tile: Tile in Contract - Tile Color - Tile Approved by - Tile Ordered - - Tile Cost - Tile…

Payroll->Setup->Employees->Misc Info->Reason How do we add more reasons (or delete some we never will use) on the list of terminations reasons in the new version of Sage 300 CRE 20.3? We have our own reasons for terminating employees that have to…

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…

Can anyone tell me what condition index you will find the wage rate amount from the employees setup PAY box? I cant seem to find the correct index. Everything keeps coming up blank.

Is there a way to change one of the "types" of insurance to read Work Comp? The system lists ALL the other types of insurance policies, but doesn't have a Work Comp category showing. We require all our commercial office tenants to carry both General Liability…

Has anyone found a way around the fact that there is only one spot for an address in AP? There should be a spot for the remit to and one for the legal address of the company. We are having issues with lock box addresses and actual addresses for 1099 and…