Page 1 of 1
Title only revenue
Posted: Tue Apr 01, 2014 4:08 pm
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.
Re: Title only revenue
Posted: Tue Apr 01, 2014 4:20 pm
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?
Re: Title only revenue
Posted: Tue Apr 01, 2014 5:31 pm
by smadderla
from any of these two:
Policy register or hud charges
Re: Title only revenue
Posted: Thu Apr 03, 2014 2:21 pm
by smadderla
Hi Lisa,
I would like to get Tax amount from Policy Register.
Thanks,
Sangeetha.
Re: Title only revenue
Posted: Tue Apr 15, 2014 9:18 am
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