TAAS

ADM/ACM Adjustment GUI Changes
-------------------------

-> Date Mandatory
-> Department Mandatory
-> Type Mandatory
-> Add Document Status like Posting status - before posting status
-> Add - File No, Enquiry No - like Receipt
-> Add attachment and Print buttons
-> Party Section
- Account Mandatory
- Amount Mandatory
-> In List
- Width reset - based on data
- Add Profit:0.00 in Grid Title
- Remove Account column
- Adjustment Amount Column Editable
- Last Colun - Delete and View Details Icon
-> Search Popup
-  Remove Adjustment Party, Settlement, Batch No
- Add ~ in last - Doc No, Ticket No
- ADM, ACM Check box Disable - Tick based on Master Type
- increase height - List
- Add Search button top Right
- ADM Unadjusted, ACM Unadjusted Account(Based on check box) outstanding > 0 records only

Select SQL

SELECT tr.pk_transaction_id,
       tr.fk_branch_id,
       tr.fk_department_id,
       tr.fk_ledger_id,
       tr.dat_transaction,
       tr.vhr_ledg_currency,
       tr.dbl_ledg_cur_roe,
       tr.dbl_ledg_cur_debit,
       tr.dbl_ledg_cur_credit,
       tr.dbl_ledg_cur_outstanding,
       tr.vhr_base_currency,
       tr.dbl_base_cur_debit,
       tr.dbl_base_cur_credit,
       tr.dbl_base_cur_outstanding,
       tr.vhr_cons_currency,
       tr.dbl_cons_cur_roe,
       tr.dbl_cons_cur_debit,
       tr.dbl_cons_cur_credit,
       tr.dbl_cons_cur_outstanding,
       tr.vhr_reference,
       tr.txt_narration,
       doc.pk_documents_id,
       doc.vhr_document_no
FROM transaction.tbl_transaction tr
     LEFT JOIN document.tbl_documents AS doc
        ON doc.pk_documents_id= tr.fk_documents_id
WHERE tr.sin_posting_status = 1
    AND tr.sin_document_status = 1
    AND tr.sin_transaction_status = 1
    AND dbl_ledg_cur_outstanding > 0
ORDER BY tr.dat_transaction

tr.sin_record_type = 42 -- ADM 
tr.sin_record_type = 43 -- ACM 
42 = ADM Unadjusted
43 = ACM Unadjusted

ISSUE FOUNDED

1.ADD ACT US CLIENT ACCOUNTS WHILE CHOOSING CUSTOMER

TESTING DONE

Seema Mathew wrote in #note-14:

ISSUE FOUNDED****

1.WHILE ADDING REMARK DEFAULT ITS COME TO REFERENCE NUMBER
2.ERROR WHILE ADDING ADM/ACM ADJUSTMENT

TESTING DONE

TESTING DONE

TESTING DONE