cancel
Showing results for 
Search instead for 
Did you mean: 

APM Capability: Adding Hold information to statements

Jim_Heckman
Explorer
0 Kudos

Where / how we find the capability to add hold information to our statements

View Entire Topic
PhillipButts
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Jim,

You will need to add a subreport to your existing Jasper statement to capture the Held Transactions since the main statement driver query looks only for vouchered payments (Held Transactions are not vouchered).

The main components of the Held Section driver query will need to reference:

1. RunListNoHold: This value is stamped on the BrokerHistory records that were evaluated in the payout were the statement was generated.

2. RunListNoRoot: This value is the RunListNo of the Payout. This value is passed in a token from the Main Report of the statement to the new Hold section in Jasper.

runlistnoroot.png

3. VendorNo: VendorNo links the Held transactions to the Vouchered payments in the statement.

4. HoldStatus: The Held Section should only return Payments that are Held (HoldStatus=2)

The query will look something like below:

statement.png