TAAS

GUI Change:-

-> Remove General Tab, Move General Tab Table to Document Tab 1st widget 
-> Cheque No - mandatory - need red star
-> Paid Cheque Search GUI popup like Paid Cheque Return - All status need
-> Remove drop down widget after cheque no

Work Flow:-

-> Select a Cheque from Search popup then ID based get
- Cheque no direct enter in inputbox then data get based on Cheque no(Some cheque no more than one then get last cheque based on cheque date)

General Tab:-

Cheque Number               Current Status
Cheque Date                 Issued Bank
Cheque Book Number          Cheque On Name
Currency                    Cleared Date
Amount                      Reconciliation Number
FOP Account                 Direct Deposit[Yes or No]
Expected Cleared Date

Root Document               Root Document Date
Party                       Branch
Sub Customer                Cash Counter
Root Cheque Status         Created By [with Created  Date & Time]
Remark           

- Document Tab Result -> sin_cheque_action_level == 0 record only

Document Tab
Table Columns

#
Document No
Date
Action
Cheque Status
Amount([Base Currency Code])
Party
Reference
Narration
Created By
Modified By
[Edit Icon]

SELECT
...
paidcheque.tbl_paid_cheque_details 
LEFT JOIN paidcheque.tbl_paid_cheque
LEFT JOIN paidcheque.tbl_cheque_leaf
LEFT JOIN document.tbl_documents
...
WHERE int_sys_action_id > 0
AND [pk_paid_cheque_id == ? or vhr_cheque_no == ?]
...
ORDER BY pk_paid_cheque_details_id

Log
GUI

#
Document No
Date
Cheque No
Cheque Date
Issued Bank
Currency
Amount
ROE
Amount In ([Base1 Currency code])
Cheque Status
Cheque Name
Action [Create, Modified, Deleted]
Action User           

ISSUE FOUNDED

1.FIXED - Show Print Pop Up Data List Wise
(Reffer Other Querys)