Sample Stock Adjustment

This document can be create under

Inventory → Stock Adjustment → Stock Adjustment

Inventory → Stock Take → Stock Take Maintenance

Inventory → Stock Take → Stock Take as Closing Inventory

Inventory → Stock Take → Stock Take as Closing Inventory (Multi Location)

Giving example , the Stock Adjustment number is SA100000

select * from inv_stock_adjustment where pkid = 100000;

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

select * from inv_stock_delta where doc_table = 'inv_stock_adjustment' and doc_key = 100000;

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

select * from inv_serial_number_delta where doc_table = 'inv_stock_adjustment' and doc_key = 100000;

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

select * from acc_journal_transaction where doc_ref = 'inv_stock_adjustment' and doc_key = 100000;

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

or

select * from acc_journal_transaction where pkid in (select src_refkey from inv_stock_adjustment where pkid = 100000);

select * from acc_journal_entry where journaltxnid in (select pkid from acc_journal_transaction where pkid in (select src_refkey from inv_stock_adjustment where  pkid=100000));