Sample Payment Voucher

This document can be create under

Finance → Payment Voucher → Create

Finance → Payment Voucher → Open (will also create a Payment Voucher but the state is open , the behaviour is same like Deposit)

Giving example , the Payment Voucher number is PV100001 ,

select * from acc_payment_voucher_index where pkid = 100001;

select * from acc_payment_voucher_item where index_id = 100001;

Record in Query Cashbook Transaction / Cash Level / Bank Recon

select * from acc_cash_transactions where foreign_table = 'acc_payment_voucher_index' and foreign_key = 100001;

Record in AR / AP Transaction / Billing Statement / Historical AR / AP Balance

Will only have record for Open Payment Voucher / Payment Voucher use for Settlement

select * from acc_nominal_account_txn where foreign_table = 'acc_payment_voucher_item' and foreign_key in (select pkid from acc_payment_voucher_item where index_id = 100001);

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

select * from acc_journal_transaction where doc_ref = 'acc_payment_voucher_index' and doc_key = 100001;

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

Record in Settlement / CC-07 / Supplier Historical Transaction Aging Analysis

If the Payment Voucher has been settled with any document , it will have record on below table

select * from acc_doclink where src_docref = 'acc_payment_voucher_item' and src_docid in (select pkid from acc_payment_voucher_item where index_id = 100001);

GST Report / Filing

If they Payment Voucher has been filed for GST , it will have record on below table

select * from acc_tax_transaction where doc_index_ref = 'acc_payment_voucher_index' and doc_index_key = 100001;