Browse By Tags

  • Is there a PO Return of Goods History Report

    Is there a PO Return of Goods History Report? I see Inventory Sales History, Inventory Receipts History, and Inventory Issue History Reports under IM module, but I don't see an Inventory Return of Goods History Report. Nor do I find one under the PO…
  • How do I get a report showing Vendor Statistics for a fiscal year in Sage 300 CRE

    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).
  • Receivables

    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.
  • Full Inventory Inventory List w/filters

    Hello fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…
  • General Ledger Detail Reports

    Hello. Is it possible to run multiple general ledger detail reports at the same time, but have each account print on a separate page? I have to run up to 14 reports each month for 60 clients and if I could run 60 reports each month instead of 840 that…
  • AP Retainage Billed Report

    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…
  • What is the proper report to use to view orders invoiced but not shipped?

    What is the proper report to use to view orders invoiced but not shipped? We have tried to use Order Action Report and set the type to orders never shipped but it is not generating accurate data. Any insight will help! Thanks in advance.
  • EEO-1 Reporting

    Can anyone help me wth how to have Sage PR mod compile the EEO-1 report?
  • Sage 300 CRE Upgrade - Can no longer run AR reports

    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…
  • Voided A/P Checks

    I just voided several checks for a vendor. How do I run a voided check report?
  • Past time to update Report & Forms Designer?

    Form and Report Designer are still stuck in the1980's as text based editors. Isn't it time to upgrade them to a graphical UI? I'd like to be able to import an image of a preprinted form on a non-printing layer. This would make text and field alignment…
  • 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?

    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…
  • Labor Hours by Cost Codes

    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…
  • NYS EO 162 Workforce Utilization Gross Wages Reporting

    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
  • Report showing jobs associated to companies?

    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…
  • Field Section of 'Add Condition'

    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…
  • W2 Reports

    Is there a report or a small set of reports that I can give to our accountant to produce our W2's? A summary of the W2 information?
  • Embedding images in shared estimate reports for Sage Estimating 20.1

    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…
  • Change Company name on reports Sage 300 CRE Accounting 20.0.1

    Hello, Recently we have moved from a publicly listed company to a limited liability one and looking to change the name on sage reports .
  • Estimating reports into Power BI

    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?
  • Is there any type of payroll report that will show me the distribution to an entity by employee by cost code and show the employee's hours worked?

    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…
  • No currency format in Maintain O/E forms

    Under the Order Entry Module I was redesigning a sales order to use for a commercial invoice. After creating a db calculation it would only display the number with no decimal places unless there happened to be cents in the calculated answer. I wanted…
  • Custom Crystal Report printing differently

    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…
  • Track OCIP Certificate at the Contracts level

    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
  • List of all invoices for 2019

    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