PSFS IQ -Offering: 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: 

Batches Batch ID

Batches Name

Batches Date Closed

Batches Final Amount

Batches Status

 

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