SoftPro Developer Forum

Hi ,
I am trying to get task for an order when it is created or updated and I am looking for a field like when task is created or modified.
I have looked into pfm.task, pfm.requested task ,pf.changeevent tables and didn't find any field.Please let me know how to proceed with this.

Thanks,
Sangeetha.

Hi, Please see attached script where I am getting posted revenue by billcode and adding TP+UW and END+UW using "Chargesource". Query is pulling expected results except in one scenario where billcode,chargesource and offsetdescription are same. review the query and let me know if your sugge...

Thanks for your reply Lisa,
when I try to join #Transfertransaction.id = PT.revenuedetail.TransactionID
procedure is not returning any data.

I am trying to display each posted line item with billcode. Please help me with this.

Hi , I am working on creating custom revenue report which is similar to select\Protrust report "Disbursed and transfer funds". when I try to join Pt.RevenueDetail table to "Disbursed and transfer funds report" data to get bill code and other contact information, this is not retur...

Hi,
I am trying to pull title premiums and endorsements and wondering if we already have a view in Softpro 3.0 which replicates dbo.policyregisterview in softpro 2.6.

if we have one please let me know the name of it.

Thanks,
Sangeetha.

Thanks for your help Lisa.

Hi , I am working on Migrating our SoftPro 2.6 custom reports to SoftPro 3.0 I am trying to pull Fees by Bill code for Pending Transactions It appears fees are in pt. Transaction table but I don't see Bill Code in this table Please suggest how I can get bill codes for pending amounts in pt. Transact...

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


Thanks,
Sangeetha.

from any of these two:
Policy register or hud charges

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.