We have noticed that this procedure is not returning fees for some Escrow orders and our investigation revelead that the report only returns fee where Ledger.Revenue is set to True
Now I am not sure how or where Ledger.Revenue is being set on the orderAND (
(@FeesDeterminedBy = 'Any Disbursement' AND TT.IsDebit=1)
OR (@FeesDeterminedBy = 'Ledger Transfer(-)' AND TT.[ID]='1F1F206E-E15F-475C-B044-C7FF2925D8A5')
OR (@FeesDeterminedBy = 'Ledger Transfer(-) to Revenue Ledger' AND TT.[ID]='1F1F206E-E15F-475C-B044-C7FF2925D8A5')AND TTF.TransferToIsRevenueLedger=1
)
PS: some orders in our system has this value set to true and few this is set to False
Let me know if you need more details about this
Thanks
Sangeetha