Sample Manual Supplier Invoice

This document can be create under

Supplier → Supplier Invoice → Supplier Invoice create

Giving example , the Supplier Invoice number is SINV1001,

select * from supp_invoice_index where pkid = 1001;

select * from supp_invoice_item where index_id = 1001;

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

select * from acc_nominal_account_txn where foreign_table = 'supp_invoice_index' and foreign_key = 1001;

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

select * from acc_journal_transaction where doc_ref = 'supp_invoice_index' and doc_key = 1001;

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

Settlement /  Supplier Historical Transaction Aging Analysis

select * from acc_doclink where tgt_docref = 'supp_invoice_index' and tgt_docid = 1001 ;