TAAS

Old Work Flow - NOT USE

1) Search Popup load master data in filter options
2) Petty cash account should not change master and search
3) Load only Petty cash Accounts (Cash Type = Petty cash)
4) Payable = Credit - Debit
5) Balance = Payable - Paid Amount    
6) table - cashmanagement.tbl_petty_reimbursement -> Document and Transaction table also
7) No Transaction/Posting
8) Search 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_debit,
       tr.dbl_ledg_cur_credit,
       tr.dbl_ledg_cur_outstanding,
       tr.dbl_ledg_cur_reserved_amount,
       tr.vhr_base_currency,
           tr.dbl_base_cur_debit,
           tr.dbl_base_cur_credit,
       tr.dbl_base_cur_outstanding,
       tr.dbl_base_cur_reserved_amount,
           tr.vhr_cons_currency,
           tr.dbl_cons_cur_debit,
       tr.dbl_cons_cur_credit,
           tr.dbl_cons_cur_outstanding,
       tr.dbl_cons_cur_reserved_amount,
       tr.int_record_ref_no,
       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_reserved_amount == 0
        AND ....
ORDER BY tr.dat_transaction

9) Save Case
-> Check Any update the transaction record - if deleted the transaction record(Remove another user), Amount invalid- Outstanding Amount != each amount (Update another user) etc..
-> Update transaction table vhr_record_ref_doc_no, int_record_ref_no(Sequence No), _reserved_amount(3-Outstanding Amount) and *sin_re_store_record = 1*
-> 

10) Update Case
-> insert log table
-> Update Document table
-> Delete a Item then 
   - Check the amount have in outstanding field
   - Restore all values in transaction table vhr_record_ref_doc_no, int_record_ref_no(Sequence No), _reserved_amount(3)- Outstanding Amount and *sin_re_store_record = 0*
-> Check Any update the transaction record - if deleted the transaction record(Remove another user), Amount invalid- Outstanding Amount != each amount (Update another user) etc..
-> Update transaction table vhr_record_ref_doc_no, int_record_ref_no(Sequence No), _reserved_amount(3) - Outstanding Amount and *sin_re_store_record = 1*
-> Delete previous Petty Reimbursement Data  and Insert in cashmanagement.tbl_petty_reimbursement

11) Delete Case
-> Check Payment is Done then not allwed to delete
-> insert data to log table
->Each Item wise checking in transaction table
 - Check the amount have in outstanding field
 - Restore all values in transaction table vhr_record_ref_doc_no, int_record_ref_no(Sequence No), _reserved_amount(3) - Outstanding Amount and *sin_re_store_record = 0*
-> Remove cashmanagement.tbl_petty_reimbursement and Document table
-> Set delete status in document table

12) Get Saved Data

SELECT pcr.pk_petty_reimbursement_id,
       pcr.fk_documents_id,
       pcr.int_record_ref_no,
       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_debit,
       tr.dbl_ledg_cur_credit,
       pcr.dbl_ledg_cur_amount AS dbl_ledg_cur_outstanding,
       tr.dbl_ledg_cur_reserved_amount,
       tr.vhr_base_currency,
       tr.dbl_base_cur_debit,
       tr.dbl_base_cur_credit,
       pcr.dbl_base_cur_amount AS dbl_base_cur_outstanding,
       tr.dbl_base_cur_reserved_amount,
       tr.vhr_cons_currency,
       tr.dbl_cons_cur_debit,
       tr.dbl_cons_cur_credit,
       tr.dbl_cons_cur_outstanding,
       tr.dbl_cons_cur_reserved_amount,
       tr.int_record_ref_no,
       tr.vhr_reference,
       tr.txt_narration,
       doc.pk_documents_id,
       doc.vhr_document_no
FROM cashmanagement.tbl_petty_reimbursement pcr
    INNER JOIN transaction.tbl_transaction tr
        ON tr.int_record_ref_no = pcr.int_record_ref_no 
            AND tr.vhr_record_ref_doc_no = 'PTC/001'
    LEFT JOIN document.tbl_documents AS doc
        ON doc.pk_documents_id= tr.fk_documents_id
WHERE pcr.fk_documents_id = 1
ORDER BY tr.dat_transaction

New Work Folow

1) Tables -> document.tbl_documents(Master Table), transaction.tbl_transaction_references(Details Table) and transaction.tbl_transaction
2) Model -> MdlTransactionReferences in TransactionModels.cs and Document Models
3) Search 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.dbl_ledg_cur_reserved_amount,
       tr.vhr_base_currency,
           tr.dbl_base_cur_debit,
           tr.dbl_base_cur_credit,
       tr.dbl_base_cur_outstanding,
       tr.dbl_base_cur_reserved_amount,
           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.dbl_cons_cur_reserved_amount,
       tr.int_record_ref_no,
       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
        AND ....
ORDER BY tr.dat_transaction

- dblRefDocLedgCurAmount = dbl_ledg_cur_outstanding 
- dbl_ledg_cur_reserved_amount = dblRefDocLedgCurAmount

4) Edited Amount <= Outstanding Amount
5) Load Doc 
SELECT tf.pk_transaction_references_id,
       tf.fk_record_ref_doc_id,
       tf.vhr_record_ref_doc_no,
       tf.int_record_ref_doc_sequence_no,
       tf.str_record_ref_doc_type,
       tf.sin_re_store_record,
       tf.dbl_ref_doc_ledg_cur_debit + tf.dbl_ref_doc_ledg_cur_credit AS dbl_ref_doc_ledg_cur_amount,
       tf.dbl_ledg_cur_reserved_amount,
       tf.dbl_base_cur_reserved_amount,
       tf.vhr_ref_doc_cons_currency,
       tf.dbl_cons_cur_reserved_amount,
       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_references tf
    INNER JOIN transaction.tbl_transaction tr
        ON tf.fk_transaction_id = tr.pk_transaction_id 
    LEFT JOIN document.tbl_documents AS doc
        ON tr.fk_documents_id = doc.pk_documents_id
WHERE tf.fk_record_ref_doc_id = 1
ORDER BY tr.dat_transaction

6) Posting - Total Amount
Petty Cash *** Dr 
Petty Cash *** Cr

7) Internal Matching the Doc Dr and Selected docs and Inter Matching Selected Docs Dr and Cr
-Pending
8) Get Matched Document and Amount -> Document Cr Side matched Against Doc and Amount
-Pending

3. CALCULATION ERROR IN OUTSTANDING AMT, BALANCE AMOUNT

4.NOT CLEARING DOCUMENT NO WHILE CLICKING NEW TAB, MISSING DATAS WHILE CHOOSING EDIT MODE FROM DOCUMENT SEARCH

Seema Mathew wrote in #note-9:

3. CALCULATION ERROR IN OUTSTANDING AMT, BALANCE AMOUNT

4.NOT CLEARING DOCUMENT NO WHILE CLICKING NEW TAB, MISSING DATAS WHILE CHOOSING EDIT MODE FROM DOCUMENT SEARCH
5.ERROR WHILE CLEARING DATE AND SAVE
6.SHOWING AMOUNT IN QAR,AND USD WHILE SWITCHING INTO NEW TAB

testing done

TESTING DONE

TESTING DONE

TESTING DONE

TESTING DONE