Sample Manual Credit Memo

This document can be create under

Customer → Credit Memo → Create

Supplier → Credit Memo → Create

Giving example , the Credit Memo number is CM1003

select * from acc_credit_memo_index where pkid = 1003;

select * from acc_credit_memo_item where index_id = 1003;

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

select * from acc_journal_transaction where doc_ref = 'acc_credit_memo_index' and doc_key = 1003;

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

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

select * from acc_nominal_account_txn where foreign_table  = 'acc_credit_memo_index' and foreign_key = 1003;

Settlement / CC-07 / Supplier Historical Transaction Aging Analysis

select * from acc_doclink where src_docref = 'acc_credit_memo_index' and src_docid = 1003;

select * from acc_doclink where tgt_docref = 'acc_credit_memo_index' and tgt_docid = 1003;

GST Report / Filing

select * from acc_tax_transaction where doc_index_ref = 'acc_credit_memo_index' and doc_index_key = 1003;