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…

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.

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

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…

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…

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?

Does anyone have an AP historical aging report they would be willing to share? Either in report designer or office connector. Thanks in advance, Amanda

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?

I am really stuck, have spent too much time spinning my wheels on this. I have created a new report with values coming from Job cost, Contracts, Billings etc all coming from transactions using Accounting Dates. I am using a Prompt so I have a "Cut-off…

Greetings, I am following the instructions of KB186526 to create a Date Prompt on a JC report. I am able to create the prompt fields. I can make the design formula (using Accounting Date [JC Transaction] instead of Accounting Date [GL Transaction…

I am trying to customize a standard job cost report in Report Designer. It currently details the costs by cost codes and categories. It is totaled at the bottom, where then a % is added on to account for overhead. We are now allocating some of the overhead…

I am trying to create a P & L report by job. I set up the report the way I need it in Report Designer. The column headings are as follows: Contract Item, Description, Job #, Cost Code, Description, Contract Amt, Total Estimate, JTD Cost, Total Billed…

I have a report working in Report Designer that I would like to be able to send the Project Managers only their jobs - but when I use My Assistant it sends all jobs. I use My Assistant for notifications and it works great, but this is the first time I…

Is there a formula to determine the day of the week in Report Designer? (as in Sunday) I'm working on a LCR report to send weekly - my problem is the report isn't always run/sent on the same day each week. I need to determine the system date and subtract…

I would like to be able to send (thru MA) a labor cost report (JC) to PM's for only jobs that had payroll the previous week. I have the report built, but all jobs with Labor cost run - is there anyway to condition/filter by only jobs with PR for a certain…