Sample Sales Order


This document can be create under

Distribution → Order Taking → Create Sales Order


Giving example , the Sales Order number is SO100001

select * from cust_sales_order_index where pkid = 100001;

select * from cust_sales_order_item where index_id = 100001;


If the Sales Order has been converted to invoice / link with deposit / have Credit Memo Settlement

select * from acc_doclink where tgt_docref = 'cust_sales_order_index' and tgt_docid = 100001;

Private & Confidential