How to find out the Invoice with direct debit on Oracle
We have a situation whereby we take direct debits payments from our customer bank accounts. As a rule we only do this for maintenance type invoices so it is quite possible for a customer to have, say 2 invoices on the ledger, one of which is a Direct Debit, one is payable say, by the customer sending us a cheque.
When we generate the direct debit file for the bank, we obviously only want to pick up the invoice which should be paid by direct debit. Is there a way in Oracle to mark the invoice for direct debit payments include/exclude?