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).
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…
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…
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 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…
Hi all,
I have been tasked with cleaning up some of the unknowns within Sage Estimating for our company. We are currently using the latest Sage Estimating 20.1 within Sage 300 CRE and since the update we have had some issues with our reports. The saved…
Hello,
I’m new to Sage and looking to access estimates through Power BI. I’ve connected through ODBC, but I do not see how to get estimate information, only Database information.
any ideas?
This is a standard report in the system we currently use and is called P/R Edit List by Job. We are in the middle of programming the Sage system and have run a mock payroll but it is not yet posted. However the above mentioned edit report is provided…
We use a custom crystal report for our AIA type billing. Previously the items in the ITEM NO. column printed in the order that they appear in the Contract (which is correct). Recently certain items are printing seemingly randomly out of order. We did…
We are a subcontractor for many different General Contractors. Many of our projects are OCIP's. I need to track the expiration dates of these OCIP certs. Do you know where / how I would enter them?
Thanks,
Bonnie
We have a Sage 300 2020 PU2 installation that works on most workstations, but one virtual machine running windows 10 Pro 64bit does not work.
The issue is that when we print a report - any report, it runs the database record select and then stops…
Is there a canned report (or a canned report that would require minimal manipulation) to determine the total count of commitments that were issued in any/all jobs over a given period of time?
We're trying to determine:
1) How many commitments were…
Hi everyone. I'm trying to compare revenue from two different systems. I'm not familiar enough with Sage 300 CRE. How do I print a list of all invoices created last year? I'd appreciate any help that could be provided.
Thank you!
Eric
I usually use the year to date ledger to print the GL for 2 or 3 months. I'd like to print it for Nov-Jan but it won't allow me to cross into the new year. Any solutions or another report that I could use?
Good Day!!!
I wanted to understand why the OCIP report and Time Entry Reports would come up with different worked hours and dollar amounts. After further review, I found that the OCIP report is calculating all OT hours at a regular rate. Is this normal…
Hi All,
Problems found when we had started doing new forms/reports for Sage 300 2019.
Recently we found out that when using View Table as Data Source, the reports are unable to generate any results in Sage 300 2019, while Sage 300 2018 or earlier…
We have Sage 300c installed and the Web Screens are accessible.
However, none of the standard reports display on the web screen if accessing them from a workstation that doesn't have Sage workstation installed on it already. Is there a fix for this…