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 already own Crystal Reports. Is there a way to edit the Crystal Reports from Sage with my existing license and not purchasing the Sage version of Crystal Reports?
We have set up an outside App that calls the Generic Print Report (GWSGPRTRPT). You pass the report name, language, destination, and an array of parameter names and values separated by "~". We have gotten this process to work, but only if the specific…
Hi all,
We do most of our customer reports based off the GL_DetailPostings table.
I have a few reports filtered to only show "SO" module transactions and I pull in some additional data from the InvoiceHistoryHeader table but now am being asked to…
Have a client that upgraded from Sage 100 2019 to Sage 100c Advanced 2023 PU1. They run several reports outside of Sage using Crystal Reports Writer version 2020. They can run these reports with no issues some of the time, but then later in the afternoon…
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…
I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name. I added the Sales Report…
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…
Hi Citiers,
I have searched around and and followed all the tips found here there there with no uck.
I decided to knock on your door to check if you have any solution, hint, tips and a clue on how to debug this error.
We got an Windows Server…
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…
Hello Everyone,
Looking for a little help on how to print the sales order line number on Packing Slips & Invoices.
We are finding every time a partial order is shipped the line numbers are renumbered starting at one based on the remaining lines…