TAAS

??? It is required to Atleast one GDS should be selected in System settings->GDS->Active GDS for the working of this module.
[Remove the message]
Working Ref
-Set Next Doc No
-Set Document Code Format
-Set Document Code

-Add Column after Next No - Highest Value
-Add Column(Last) - Missing Numbers, Deleted Documents
*Active Document Count, Missing Document Count, Deleted Document Count

SQL Discus with anil
Ref:-https://www.db-fiddle.com/f/2VWyUD9YnFcFCMbJkfz6YS/0

Select      m.remarks, 
            Count(d.status) filter (where d.status = 1) as status1_cnt,
            Count(d.status) filter (where d.status = 2) as status2_cnt,
            Count(d.status) filter (where d.status = 3) as status3_cnt
From        master m
Inner Join details d ON( d.m_id = m.m_id )
Group By    m.remarks
--------------------------------------------------------------------
SELECT fk_doc_no_generator_id,
    MIN(vhr_document_code) AS vhr_document_code,
    MIN(bin_number_part) AS bin_start_number,
    MAX(bin_number_part) AS bin_end_number,
    STRING_AGG(DISTINCT vhr_sys_module_name, ',') AS vhr_sys_module_names,
    MAX(bin_last_number) AS bin_last_number,
    MAX(bin_highest_number) AS bin_highest_number,
    COUNT(int_sys_action_id) FILTER  (WHERE int_sys_action_id != -1) AS bin_active_document_count,
    COUNT(int_sys_action_id) FILTER  (WHERE int_sys_action_id = -1) AS bin_deleted_document_count,
    ARRAY_AGG(bin_number_part) AS arb_generated_doc_numbers
FROM (SELECT doc.fk_doc_no_generator_id,
          doc.vhr_doc_no_code_part AS vhr_document_code,
        doc.vhr_sys_module_name,
          dog.pk_doc_no_generator_id,
        dog.bin_last_number,
        dog.bin_highest_number,
        doc.bin_number_part,
        doc.int_sys_action_id
    FROM document.tbl_documents doc
        INNER JOIN document.tbl_doc_no_generator dog
            ON dog.pk_doc_no_generator_id = doc.fk_doc_no_generator_id
     WHERE ...) AS tmp
GROUP BY fk_doc_no_generator_id

if missing count > 0
show
else
not show