Sample Cashsale / Invoice

This document can be create under

Trading → Sales → Full Screen Cash Sale (Cashsale)

Trading → Sales → Create Invoice (Invoice) 

Giving example , the cashsale / Invoice number is INV1234

select * from cust_invoice_index where pkid = 1234;

select * from cust_invoice_item where invoice_id = 1234;

To trace movement in / out of the item (Stock Movement)

select * from inv_stock_delta where doc_table = 'cust_invoice_item' and doc_key in (select pkid from cust_invoice_item where invoice_id = 1234);

To trace movement in / out of the serial number or batch and expiry (Trace Stock)

select * from inv_serial_number_delta where doc_table = 'cust_invoice_item' and doc_key in (select pkid from cust_invoice_item where invoice_id = 1234);

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

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

select * from acc_journal_entry where journaltxnid in (select pkid from acc_journal_transaction where doc_ref = 'cust_invoice_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 = 'cust_invoice_index' and foreign_key = 1234;

Settlement / CC-07

select * from acc_doclink where tgt_docref = 'cust_invoice_index' and tgt_docid = 1234;

GST Report / Filing

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