Title only revenue

Discussions related to Crystal Reports development.

Moderator: Lisa Ennis

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

Title only revenue

Post by smadderla »

Hi,
I am trying to get "STX" fee for Title only orders from "Title charges(1100)" screen.
This is in Softpro v2.6 can you please guide me with this.


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

Re: Title only revenue

Post by Lisa Ennis »

Do you want to pull this information from the HUD Charges, or do you want to pull it from the Policy Register section of the program; or do you want to retrieve this from orders that have disbursed?
Lisa Ennis
Senior Report Developer
SoftPro
smadderla
Posts: 16
Joined: Fri Nov 02, 2012 5:31 pm

Re: Title only revenue

Post by smadderla »

from any of these two:
Policy register or hud charges
smadderla
Posts: 16
Joined: Fri Nov 02, 2012 5:31 pm

Re: Title only revenue

Post by smadderla »

Hi Lisa,
I would like to get Tax amount from Policy Register.


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

Re: Title only revenue

Post by Lisa Ennis »

There is a view that has all the data related to all charges named TransactionHUDLineAndAmountFull. Data writes to the tables this view uses when the fees are disbursed. If the disbursement is voided, then this view subtracts the amounts.

If you don't need this based on your disbursements in the order, then you can use the dbo.HUDLineAdditionalCharge table to get the bill codes and amounts.

To pull the data from the Policy Register tables, there are several views that you could use. Those are PolicyRegisterLoan, PolicyRegisterOwners, or PolicyRegisterView. Another good reference is the PolicyRegister stored procedure.

Hope this helps.
Lisa
Lisa Ennis
Senior Report Developer
SoftPro
Post Reply