PSFS IQ -Offering: How to query batches closed in a certain date range

How to query batches closed in a certain date range

If you are looking for a list of your batches that were closed within a certain time frame this query will give you an overview of the batches.

Result Columns: 

 
 

 

Query Conditions:

Batches Date Closed is between ENTER DATE RANGE

and Batches Owner Organization ID is equal to (Your Parish's ORG ID)

and Batches Status is equal to 2 (equivalent to closed)

 

 

The results of this query should allow you to verify the date your batch was closed. This can be used as an audit method for comparison with deposits made in the PS Accounting software. 

Updated

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request