• 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).
  • How to remove automated email reports

    Good day, I have a job cost report for several projects that was set up to auto email every week to my email. We have long since completed these jobs and moved on to new jobs. I have two questions: 1. How do I remove the old job automated report emails…
  • JC summary showing a difference in GL vs JC- how do I find out where the mistake is?

    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…
  • can in-list be used with {variable[N]}?

    In Report Writer, Sage 100 Contractor, is there a way to use the selection criteria "in list" with a variable like {variable[N]}? In this case, I am using {Job Number[N]} to select Job Number in SQL statement where job number is not in the Primary Table…
  • 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…
  • Selecting null values with report criteria

    I'm trying to build a report that will allow me to select job costs for a list of jobs that have no work order assigned. How do I set the criteria to select null values?