Sage Construction & Real Estate

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…

I would like to create a report that shows me vendors without an invoice during the past 15 months. I know I can create a condition each time for "last invoice date <= (date 15 months prior). Or create a condition based on input. Is there a way to create…

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…

Does anyone know if there is a AR Tax Group set up report that exists so I can see what tax rates are part the group? Looked in standard reports and KnowledgeBase but have not been able to find anything.

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?

AMAX does not work with Dates - I tested it. I don't use RD much anymore - do mostly crystal. any help would be great. or an example

What table in the DB has all the Job Setup Change Management information - looking for the table that has the markup grid

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

I am looking for a Weekly Labor Report that includes ALL PR costs (Burden, Reimbursements, etc) that can be run by Period End Date NOT Accounting Date. (I know I can condition it with the PED after the accounting date is selected but that's not what I…

I need to create a formula that adds employee DOB to today's date. I've tried using system date but I receive an error that the field types are different. Has anyone used system date in a date calculation formula? Thanks

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…

Dear team, We are recently change the printer for cheques to a latest printer . We were using HP Laserjet P1102 and we purchased a new Laerjet 107 W . But when we print the cheque , each time i have to edit the report according to values in the…

Is there a report that can help me cross reference deductions and fringes by pay check or pay period?

I have a report in Report Designer that pulls data from JC - Transaction. I'd like a totaling line to return the cost code description if the group cost code is true. However, JC - Transaction does not contain the group cost code. I've played around with…

Hey, guys I heard the sage 300 cre has report designer which can show Available Fields for a list of reports. However, I cannot find the report designer and the Print Available Fields in my sage 300 cre desktop. Is the report designer need to be purchased…

Being from one of the 2 states that collect sales tax on commercial real estate. (PM) I have a report in designer that gives me current activity on total taxable income for the month. Since the state of Florida has chosen to reduce the % rate held…

I just purchased Report Designer and when creating reports the view is distorted (fields and text) with text overwriting itself. I have to deselect and reselect the view (Body, Header) after each change for it to display the changes correctly. Has anyone…

JC Cost Code Custom Fields file doesn't show all the fields in Report designer. I opened a report that uses the JC Cost Code Custom Fields file. It gave this error Message: "WARNING: Invalid Data found in Conditions. The invalid parts of conditions have…

Hi Everyone!! We just launched a new logo and I am trying to put it into our reports in Timberline. In order to do it, I go into the report designer > options> letterhead and change the link. HOWEVER, all of the logos that we tried either have a black…

I'm trying to create a formula for a date stamp time condition but cannot seem to figure out the format used for a time constant. For example: Time Stamp > 14:30:00 doesn't work. What is the proper format for a time constant?

I am trying to find out if there is a PSQL query or a report that I can run that will show me where formulas are being used - or if they are. So, if a formula is being used, is it used in another formula, report, etc. I have 100's of formulas & reports…

I have a Job Cost Report that I run task and it will send out to each PM but includes one report with all of their jobs. How do I change the report conditions so it will send a separate PDF report for each job that only contains information for that one…

I am looking for a job cost/payroll report that will show the the peak weeks worked on any project by trade or department that can be run by period end dates/specific timeframe. Anyone know of a report that will accommodate this?

Looking for a formulaa to simply look into the PR-Check table and return to me an employees maximum date within the Pay Period End Date field . As the help file suggests, the MAX function is only used for numbers and Sage doesnt like it when I try to…

Hello! I have a report design that utilizes the following recordsets: CN Contract CN Contract Item JC Job PJ Job PJ Job Custom Fields I have a custom field in PJ Job Custom Fields that specifies the price structure (stipulated sum, GMP…