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.
Search found 16 matches
- Tue Jan 12, 2016 7:35 pm
- Forum: Crystal Report Development
- Topic: Requested tasks
- Replies: 1
- Views: 2510
- Wed Dec 23, 2015 12:21 am
- Forum: Crystal Report Development
- Topic: register screen - Revenue by billcode
- Replies: 1
- Views: 2427
register screen - Revenue by billcode
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...
- Thu Oct 30, 2014 1:53 pm
- Forum: Crystal Report Development
- Topic: Disbursed and Transfer Funds
- Replies: 2
- Views: 728
Re: Disbursed and Transfer Funds
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.
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.
- Thu Oct 16, 2014 5:41 pm
- Forum: Crystal Report Development
- Topic: Disbursed and Transfer Funds
- Replies: 2
- Views: 728
Disbursed and Transfer Funds
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...
- Fri Apr 25, 2014 5:36 pm
- Forum: Crystal Report Development
- Topic: Title premiums
- Replies: 1
- Views: 745
Title premiums
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.
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.
- Fri Apr 18, 2014 4:24 pm
- Forum: Crystal Report Development
- Topic: Pending Transactions Billcode in softpro 3.0/selecdb
- Replies: 2
- Views: 776
Re: Pending Transactions Billcode in softpro 3.0/selecdb
Thanks for your help Lisa.
- Fri Apr 18, 2014 3:36 pm
- Forum: Crystal Report Development
- Topic: Pending Transactions Billcode in softpro 3.0/selecdb
- Replies: 2
- Views: 776
Pending Transactions Billcode in softpro 3.0/selecdb
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...
- Thu Apr 03, 2014 2:21 pm
- Forum: Crystal Report Development
- Topic: Title only revenue
- Replies: 4
- Views: 1218
Re: Title only revenue
Hi Lisa,
I would like to get Tax amount from Policy Register.
Thanks,
Sangeetha.
I would like to get Tax amount from Policy Register.
Thanks,
Sangeetha.
- Tue Apr 01, 2014 5:31 pm
- Forum: Crystal Report Development
- Topic: Title only revenue
- Replies: 4
- Views: 1218
Re: Title only revenue
from any of these two:
Policy register or hud charges
Policy register or hud charges
- Tue Apr 01, 2014 4:08 pm
- Forum: Crystal Report Development
- Topic: Title only revenue
- Replies: 4
- Views: 1218
Title only revenue
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.
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.