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).
Hi,
I have just set the Sage 300 2024 up and using SAMINC we are testing new features for suitability for a client upgrade.
When testing I am getting errors when running via the FR Web, the FR on the desktop however is working fine.
Sage 300 2024…
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…
We just put the Tax updates for January on our system December 31. We are on version 2021, UP73 product update 30. When we enter all of the parameters on the screen for the Payroll Employee Information Report and hit print, it crashes. By crashes I mean…
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?
We need to retrieve Purchase Order details to include the PO # and "Ship to" name. Can this be done with canned reports in Sage 300? My searches have come up empty. We have intelligence but not Connector. The Purchases Master report doesn't appear to…
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…
Created a custom crystal report for client with Date from and Date to and customer number as parameters in order for sending all invoices to a particular customer for a specific month or range of dates.
The custom crystal report on the sage server…
I am trying to print the aged payables report in functional currency as at March 31. The problem is, that its showing some documents with dates after March 31, just because those documents were applied against prepayments with dates before March 31. This…
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
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?