Sample Jobsheet / Quotation


This document can be create under

Trading → Jobsheet → Create Jobsheet

Trading → Jobsheet → Workshop → Jobsheet → Create


Giving example , the Jobsheet number is JS1001

select * from cust_jobsheet_index where pkid = 1001;

select * from cust_jobsheet_index where index_id = 1001;


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

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

select * from acc_doclink where src_docref = 'cust_jobsheet_index' and src_docid = 1001;

Private & Confidential