Custom Escrow Fee Report

Discussions related to Crystal Reports development.

Moderator: Lisa Ennis

Post Reply
smadderla
Posts: 16
Joined: Fri Nov 02, 2012 5:31 pm

Custom Escrow Fee Report

Post by smadderla »

We created a custom Escrow Fee report, which uses softpro stored procedure "RevenueFeeDetails" in SelectDB database

We have noticed that this procedure is not returning fees for some Escrow orders and our investigation revelead that the report only returns fee where Ledger.Revenue is set to True
AND (
(@FeesDeterminedBy = 'Any Disbursement' AND TT.IsDebit=1)
OR (@FeesDeterminedBy = 'Ledger Transfer(-)' AND TT.[ID]='1F1F206E-E15F-475C-B044-C7FF2925D8A5')
OR (@FeesDeterminedBy = 'Ledger Transfer(-) to Revenue Ledger' AND TT.[ID]='1F1F206E-E15F-475C-B044-C7FF2925D8A5')AND TTF.TransferToIsRevenueLedger=1
)
Now I am not sure how or where Ledger.Revenue is being set on the order

PS: some orders in our system has this value set to true and few this is set to False
Let me know if you need more details about this


Thanks
Sangeetha
Lisa Ennis
Posts: 84
Joined: Thu Sep 11, 2008 1:57 pm

Re: Custom Escrow Fee Report

Post by Lisa Ennis »

The "TransferToIsRevenueLedger" flag is set on the ledger you are transferring funds to, it is not set in the order. Open the Revenue Ledger in ProTrust, and you will see the Revenue flag on the right side of the ledger header.

Hope this helps, please let us know if you have additional questions.
Lisa Ennis
Senior Report Developer
SoftPro
smadderla
Posts: 16
Joined: Fri Nov 02, 2012 5:31 pm

Re: Custom Escrow Fee Report

Post by smadderla »

Thanks Lisa.
Post Reply