We have a situation where i need to update Cheque number/payment reference details after posting the journal.
We are paying to vendor by Electronic Cheque Payment System. After posting the journal, we send the payment details to bank. Bank will revert back with the cheque number, cheque remarks and other details.
I can update cheque details in LedgerJournalLines table, but i am not able to update to BankAccountTrans table.
If i dont update,it will be a problem at the time of bank reconciliation.
I am not finding relation between LedgerJournalTrans table and BankAccountTrans table.
Is there any solution for my issue? or is there any other way by which i can update cheque details which will effect all posted journal transactions??