Sage Construction & Real Estate

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…

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…

We have changed the AP invoice aging w/cut off to show the job number. It worked great except that it has a huge number of lines that have no dollar amount. These lines just show the vendor number and name as well as the job number and name. Can someone…

When we setup Invoice Approval in AP, one of the things we did was setup Approval IDs, so we could tell who approved an invoice. However, now that we've used this for a while, I can't find a report which displays this data. Is there a way to create a…

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?

Does anyone have an AP historical aging report they would be willing to share? Either in report designer or office connector. Thanks in advance, Amanda

Does anyone know of a way to modify the AP Invoice Aging with Cut-off Report so that it summarizes by vendor (does not show the individual invoice detail)? I tried a few different ways and failed.