Sage Construction & Real Estate

I need to pull a report that shows all of the following information for our past fiscal year: Vendor name, address (CSZ) number of checks, total amount paid to vendor, Type of payment (Check, cc, ACH).

I'm looking for a report that shows me the current contract dollar amount and how much we have been paid for that particular contract.

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 m looking for a report that shows employee's name and wages for a particular job and a certain time frame.

I need a report that shows all employees that worked on a certain job on a certain day. Can someone help me?

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…

We are having issues with getting subcontractors who have billed retainage to show up on a report since Sage 300 refuses to create a "bill retainage" button in AP. When I submit reports to management they have no idea a retainage bill from a subcontractor…

1. I m looking to see if there is a report that would show me if i have billed retaiange. 2. I m looking for a report or something that i can run that would show if I billed for my jobs that month.

Can anyone help me wth how to have Sage PR mod compile the EEO-1 report?

Can we create a SOC 1 Type II report in which service auditors test the internal controls over Sage reporting?

We have recently upgraded our Sage 300 CRE to version 22. Now when we try to run our aging report in accounts receivable we always get this error. Faulting application name: AR.EXE, version: 22.2.1.113, time stamp: 0x6336a3bd Faulting module name…

Hi, I am new to Sage, How do I run a report that will give all the open invoices for a specific project ?

I am new to this program and cannot seem to find the right reports that I need that would include everything for the auditors. Any suggestions?

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

Hello, I recently ran my JC summary reconciliation report and have a difference of $900 in my GL that is not showing up in my JC on the subcontractor line of the report. What reports do i run to narrow down where the mistake is at? Looks like it was…

How can I get A report like the Check Activity Detail report with only YTD Totals for all employees in a specified date range Using Sage 300? The Check Activity detail report is just what I need with just a bit of modifications. The report only need…

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…

Is there a report that shows all of the posting detail for a specific job? I am looking for a job cost detail report that shows the detailed cost for each cost code.

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

We have started using the enter pending invoices function. How do you print a pending AP register with detail that shows the distributions so I can proof the invoices? Thanks.

I need to be able to show number of hours for the year by various cost codes but can't seem to find a report that will do that. So for example, 1/1/2021-06/30/21 I need to see how many hours were entered with drywall cost codes, electrical, etc. Any help…

Does anyone have a report that meets the NYS requirements for the EO 162 Workforce Utilization Gross Wages Reporting? https://www.thruway.ny.gov/business/dmwbe/purchasing-eo-162-instructions.pdf

Hi, Within a datafolder we have numerous companies - all with jobs associated to them. Is there a report or easy way to show what company each job is associated to or show a list of jobs associated to a certain company within a datafolder? Further…

If I add a condtion to a report, it lists a bunch of items in the Field Section. How do I add an additional field to that? Right now 'Owner' is an item in the Field for Job Lists. But when I view the same report in our Archived database, 'Owner' is not…