Sample Receipt

This document can be create under

Trading → Sales → Full Screen Cash Sale (Auto Create)

Customer → Tasks → Settle Document / Create Deposit

Finance → Receipt Voucher → Create

Giving example , the Receipt number is RCT1234

select * from acc_receipt_index where pkid = 1234;

If the Receipt is a Receipt Voucher , then it will have item

select * from acc_receipt_item where index_id = 1234;

Record in Query Cashbook Transaction / Cash Level / Bank Recon

select * from acc_cash_transactions where foreign_table = 'acc_receipt_index' and foreign_key = 1234;

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

select * from acc_journal_transaction where doc_ref = 'acc_receipt_index' and doc_key = 1234;

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

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

select * from acc_nominal_account_txn where foreign_table = 'acc_receipt_index' and foreign_key = 1234;

Settlement / CC-07

If the Receipt has been settle ,

select * from acc_doclink where src_docref = 'acc_receipt_index' and src_docid = 1234;

select * from acc_doclink where tgt_docref = 'acc_receipt_index' and tgt_docid = 1234; (refund)

GST Report / Filing

If the Receipt has been filed ,

select * from acc_tax_transaction where doc_index_ref = 'acc_receipt_index' and doc_index_key = 1234;