Transfer Ledger

Discussions related to Crystal Reports development.

Moderator: Lisa Ennis

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

Transfer Ledger

Post by MJA-99 »

In writing custom Escrow Fee related reports, is there an existing built-in Stored Procedure, View, or Table Valued Function that would include any Seller Credits (Hud Line 410's) or similar types of issues that would affect 1102 or ESC records? Here is a description from TG as to what is happening:
Currently our logic for the Escrow Fee – Actual Fee is to look at HUD line 1102 for Bill Code = ESC. The reports that use this logic have worked so far, but now have factors that are not working. For an order, there was a Seller Credit (Hud Line 410) that reduced the Escrow Fee. Because the Escrow Officer Report calculates the Actual Fee from the 1102 HUD Line, it is reporting the Escrow Fee and excluding the reduced amount due to the credit. Do you think we could derive the Actual Fee from the actual amount of the Transfer Ledger instead of deriving it from adding up the details for Bill Code = ESC?


Is there something analogous to the actual amount of the Transfer Ledger in the SoftPro (dbo) Stored Procedures, Views or Table Valued Functions that already does this?

Thank you,

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

Re: Transfer Ledger

Post by MJA-99 »

From what I can see, it appears this is the table where this information resides although there are some WHERE requirements that need to be added in addition to GROUP requirements used in conjunction with ClearedDate and TransactionDate (ClearedDate is used as TransactionDate if Amount < 0) in order to get what we need. It appears to be working over the span of many months.

dbo.TransactionHudLineAndAmountFull
Post Reply