Pending Fee Ledger Disbursement

Discussions related to Crystal Reports development.

Moderator: Lisa Ennis

Post Reply
MJA-99
Posts: 33
Joined: Fri Apr 08, 2011 2:41 pm

Pending Fee Ledger Disbursement

Post by MJA-99 »

We have created a custom report for both Fee Ledger Disbursements and Fee Ledger Pending (Have not been Disbursed). The Fee Ledger Disbursements seems to be working. Therefore, I attempted to get what was Pending by removing all of the Fee Ledger Disbursements using Reference Number as it was indicated to me that Reference Number should be the same for both a Disbursement and a Pending. The problem is that items are showing on the Fee Ledger Pending Report that have already been disbursed. It seems that even though items have the same amount, the Reference Number is different for Disbursement than for the item that is still showing on Fee Ledger Pending that shouldn't.

Is there an existing View/Procedure/TVF that we could leverage to do this? Is there a Key that is going to remain the same even after the Fee Ledger is disbursed?
What is the optimal methodology for distinguishing between a Fee Ledger Disbursement and a Fee Ledger Pending?

Thank you for your help.
Lisa Ennis
Posts: 84
Joined: Thu Sep 11, 2008 1:57 pm

Re: Pending Fee Ledger Disbursement

Post by Lisa Ennis »

To get pending fee ledger disbursements, you would search for transactions assigned to the fee ledger type and that the dbo.Transaction.ParentTransactionID is NULL.
Lisa Ennis
Senior Report Developer
SoftPro
Post Reply