Filtering Transaction on Disbursement Ledger

Discussions related to custom development with Select.
Post Reply
dutil
Posts: 33
Joined: Thu Dec 19, 2019 12:10 pm

Filtering Transaction on Disbursement Ledger

Post by dutil »

We are trying to recreate some of the functionality that exists on the ProTrust Ledger screen (for non-order related ledgers).
The issue we are running into is we want to ONLY display transactions that have been posted but NOT disbursed yet.

How do we filter out transactions that have already been disbursed?
BobRichards
Posts: 1376
Joined: Wed Jan 15, 2014 3:50 pm
Location: Raleigh, NC
Contact:

Re: Filtering Transaction on Disbursement Ledger

Post by BobRichards »

The functionality of ProTrust ledgers in Select cannot be modified. You can use the ITransactionSearchCriteria, ITransactionsManager and other related interfaces to filter the list of transactions. This is what ProTrust does under the covers.
Bob Richards, Senior Software Developer, SoftPro
dutil
Posts: 33
Joined: Thu Dec 19, 2019 12:10 pm

Re: Filtering Transaction on Disbursement Ledger

Post by dutil »

There may be a misunderstanding, we are not trying to change the way the ProTrust work in Select, they are working they way we want.
We want to recreate the same filter that it does but in a custom application.

Currently we are looping through the transactions and filtering on the following:

transaction.Deleted = false
transaction.Current = true
transaction.DepositNumber > 0
transaction.Status == Posted
transaction.DisbursedAsTransactionID is not null
transaction.IsFundsTransferDisbursement = false

This seems to work correctly for about 1/2 the ledgers (primarily ledgers that are transferred to from orders), but for the other half (ledgers that are transferred to from other non-order ledgers) it does filter completely and will still show hundreds of transactions while the Select UI shows less than 4.

What criteria is Select filtering on in the Protrust ledgers UI?
BobRichards
Posts: 1376
Joined: Wed Jan 15, 2014 3:50 pm
Location: Raleigh, NC
Contact:

Re: Filtering Transaction on Disbursement Ledger

Post by BobRichards »

I have sent your request to R&D for them to look at since it seems to address the inner logic of ProTrust.
Bob Richards, Senior Software Developer, SoftPro
BobRichards
Posts: 1376
Joined: Wed Jan 15, 2014 3:50 pm
Location: Raleigh, NC
Contact:

Re: Filtering Transaction on Disbursement Ledger

Post by BobRichards »

From R&D...

For a Ledger Transfer In to populate the screen below from the “Disburse Transferred Funds” action, the grid uses a pretty complicated SQL query but it basically uses [pt].[TransactionInfoView] and looks at kind = LedgerTransferIn (12), deleted = false (0), status = Posted (2) and in the code DisbursedAsTransactionID is null. Let me know if that information is good or if we need to dig more.
2021-12-17_15-44-28.jpg
2021-12-17_15-44-28.jpg (50.36 KiB) Viewed 1257 times
Bob Richards, Senior Software Developer, SoftPro
Post Reply