Sample Cash Transfer

This document can be create under 

Finance → Cashbook → Cash Transfer 

Giving example , the Cash Transfer number is CT10001

select * from acc_cash_transfer_item where pkid = 10001;

Record in Query Cashbook Transaction / Cash Level / Bank Recon

select * from acc_cash_transactions where foreign_table = 'acc_cash_transfer_item' and foreign_key = 10001;

Record in Financial Report (Balance Sheet / Trial Balance / P&L / GL Listing

select * from acc_journal_transaction where doc_ref = 'acc_cash_transfer_item' and doc_key = 10001;

select * from acc_journal_entry where journaltxnid in (select pkid from acc_journal_transaction where doc_ref = 'acc_cash_transfer_item' and doc_key = 10001);