Project

General

Profile

Edit Copy Actions

Feature #163

open

Supplier Reconciliation

Added by Anil KV about 2 years ago. Updated about 1 month ago.

Status:
Reopen Bugs Coding Done
Priority:
Normal
Assignee:
Target version:
Start date:
05/25/2023
Due date:
% Done:

70%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Supplier Reconciliation
Tested By:
unnikannan S
Code Reviewed By:

Description

Coding Supplier Reconciliation


Files

SQL-SupReco-OtherTab-Query.sql (980 Bytes) SQL-SupReco-OtherTab-Query.sql Junaid M, 05/27/2023 10:15 AM
clipboard-202410231905-2mwvj.png (143 KB) clipboard-202410231905-2mwvj.png Theja Ponon, 10/23/2024 07:05 PM
clipboard-202411211137-cryzn.png (65.7 KB) clipboard-202411211137-cryzn.png Theja Ponon, 11/21/2024 11:37 AM
clipboard-202411211138-dj7wc.png (99.8 KB) clipboard-202411211138-dj7wc.png Theja Ponon, 11/21/2024 11:38 AM
clipboard-202411211802-qx5mg.png (140 KB) clipboard-202411211802-qx5mg.png Arathy PS, 11/21/2024 06:02 PM
clipboard-202411271910-tbpyr.png (126 KB) clipboard-202411271910-tbpyr.png unnikannan S, 11/27/2024 07:10 PM
clipboard-202501281609-izuxt.png (111 KB) clipboard-202501281609-izuxt.png Arathy PS, 01/28/2025 04:09 PM

Add

Subtasks


Add

Related issues

Actions #1

Updated by Junaid M almost 2 years ago

  • Status changed from New to Open
  • % Done changed from 0 to 10
Actions #2

Updated by Junaid M almost 2 years ago

  • Status changed from Open to New
  • Assignee changed from Junaid M to Aparna Mathew
  • % Done changed from 10 to 0
Actions #3

Updated by Junaid M almost 2 years ago

  • Status changed from New to Open
  • % Done changed from 0 to 10
Actions #4

Updated by Aparna Mathew almost 2 years ago

  • Status changed from Open to Coding Started
  • Start date changed from 02/25/2023 to 05/25/2023
  • % Done changed from 10 to 40
Actions #6

Updated by Aparna Mathew over 1 year ago

  • Status changed from Coding Started to Particialy Coding Done

Updated by Junaid M over 1 year ago

Gui Changes ****
1-Add View Posting Button and Pop-up

*Need Posting (Dr, Cr Ticket Amounts)
*Insert In Transaction Reference Table

Updated by Junaid M over 1 year ago

1)Search Query

SELECT
    CASE WHEN tr.dat_transaction < CAST('2023-12-01' AS DATE) THEN 1 ELSE 0 END AS sin_is_previous, -- FROM DATE
    tr.vhr_sys_module_name,
    tr.fk_documents_id,
    CASE WHEN tr.dbl_base_cur_debit > 0 THEN tr.dbl_base_cur_outstanding ELSE 0.00 END AS dbl_outstanding_debit,--dynamic column    
    CASE WHEN tr.dbl_base_cur_credit > 0 THEN tr.dbl_base_cur_outstanding ELSE 0.00 END AS dbl_outstanding_credit,--dynamic column
    CAST(tr.jsn_related_data->>'binAirlineMasterId' AS VARCHAR) AS bin_airline_master_id,
    CAST(tr.jsn_related_data->>'strAirlineNumCode' AS VARCHAR) AS vhr_airline_num_code,
    CAST(tr.jsn_related_data->>'strAirlineCharCode' AS VARCHAR) AS vhr_airline_char_code,
    CAST(tr.jsn_related_data->>'strAirlineName' AS VARCHAR) AS vhr_airlinename,
    CAST(tr.jsn_related_data->>'strSuppDocNo' AS VARCHAR) AS vhr_supp_doc_no,
    CAST(tr.jsn_related_data->>'datIssueOrCancel' AS VARCHAR) AS dat_issue_or_cancel,
    CAST(tr.jsn_related_data->>'strSector' AS VARCHAR) AS vhr_sector,
    CAST(tr.jsn_related_data->>'strSuppDocType' AS VARCHAR) AS vhr_supp_doc_type,
     tr.txt_narration
FROM transaction.tbl_transaction AS tr
LEFT JOIN document.tbl_documents AS doc
    ON tr.fk_documents_id = doc.pk_documents_id
WHERE tr.sin_transaction_status = 1 AND tr. sin_posting_status = 1 AND tr. sin_document_status = 1
    AND tr.dbl_base_cur_outstanding > 0
    AND tr.fk_supp_doc_no_id IS NOT NULL
    AND tr.fk_ledger_id = 59
    --...Remining ui filter where conditions

2) Load Doc

3) Posting - Total Amount
Supplier * Dr
Supplier *
Cr

4) Internal Matching the Doc Dr and Selected docs and Inter Matching Selected Docs Dr and Cr
-Pending

Actions #9

Updated by Aparna Mathew over 1 year ago

  • Status changed from Particialy Coding Done to Coding Started
Actions #10

Updated by Aparna Mathew about 1 year ago

  • Status changed from Coding Started to Particialy Coding Done

Updated by unnikannan S about 1 year ago

  • Status changed from Particialy Coding Done to Reopen Bugs
  • % Done changed from 40 to 50
  • Tested By set to unnikannan S

ISSUE FOUNDED

1.REMOVE EDIT PEN FROM TOTAL
2.SHOW PREVIOUS DATA OF DOCUMENTS
3.NAN IN FARE FIELD WHILE ADDING ALPHABETS
4.DONT SHOW EDIT BUTTON IN THOSE FARE FIELDS HAVE NO VALUE
5.MISSING DECIMAL VALUE ADDED IN STATMENT FARE FIELD ON POSTING

Actions #12

Updated by Aparna Mathew about 1 year ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60

Updated by unnikannan S about 1 year ago

TESTING DONE

Updated by unnikannan S about 1 year ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 60 to 50

ISSUE FOUNDED

1.MISSING REFUND DOC FROM LIST

Actions #15

Updated by Aparna Mathew about 1 year ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60

Updated by unnikannan S about 1 year ago

TESTING DONE

Updated by unnikannan S about 1 year ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 60 to 50

ISSUE FOUNDED

1.CLEAR ALL DATA RELATED TO THE DOCUMENT WHILE DELETING

Actions #18

Updated by Aparna Mathew about 1 year ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70

Updated by unnikannan S about 1 year ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 70 to 50

ISSUE FOUNDED

1.ADD NO DATA FOUND MESSAGE
2.NAN IN FARE FIELD
3.CLEAR RED STAR FROM DOC,DEPARTMENT FIELDS

Updated by Aparna Mathew about 1 year ago

-- 53 = BSP/NON BSP Supplier Reco - Dr - Internal matched Debit or Credit Record
-- 54 = BSP/NON BSP Supplier Reco - Cr - Internal matched Oposit Debit or Credit

Use Record Type

Actions #21

Updated by Aparna Mathew 12 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70

Updated by unnikannan S 12 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 70 to 50

ISSUE FOUNDED

1.CANT CHANGE BRANCH ON A SAVED RECO DOC

Actions #23

Updated by Aparna Mathew 11 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70

Updated by Arathy PS 5 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 70 to 50

ISSUE FOUND
--------------------
1. Internal matching not done.
2. Add print button and connect print.

Updated by Theja Ponon 5 months ago

ISSUE FOUND
------------------------------------
1. Up on saving reconciliation with only other debit other credit, then when reloading the reconciled document all the fields are zero.
2. Add print button and connect print.
3.issued tickets are not showing in the issue tab but shows in the master tab

4.on reloading the saved document other debit/credit field amount and count get doubled

Actions #26

Updated by Aparna Mathew 5 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70

Updated by Theja Ponon 4 months ago

Updated by Theja Ponon 4 months ago

  • File clipboard-202411211153-rgug1.png added
  • File clipboard-202411211153-bugtn.png added
  • File clipboard-202411211153-xpum5.png added
  • File clipboard-202411211153-ztcve.png added

ISSUE FOUND
----------------
1)TOTAL PAID IS EMPTY

2)ISSUE DATE IN ISSUED TAB IS NOT CORRECT

Actions #29

Updated by Theja Ponon 4 months ago

  • File deleted (clipboard-202411211153-bugtn.png)
Actions #30

Updated by Theja Ponon 4 months ago

  • File deleted (clipboard-202411211153-xpum5.png)
Actions #31

Updated by Theja Ponon 4 months ago

  • File deleted (clipboard-202411211153-rgug1.png)
Actions #32

Updated by Theja Ponon 4 months ago

  • File deleted (clipboard-202411211153-ztcve.png)

Updated by Arathy PS 4 months ago

ISSUE FOUND
-----------------

1)TOTAL PAID IS EMPTY

DONE -2)ISSUE DATE IN ISSUED TAB IS NOT CORRECT

DONE -3) On updating after changing the Roe of the supplier.

Actions #34

Updated by Aparna Mathew 4 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
Actions #35

Updated by unnikannan S 4 months ago

Actions #36

Updated by Aparna Mathew 4 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
Actions #37

Updated by unnikannan S 4 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 70 to 50

Updated by Aparna Mathew 4 months ago

Delete Pending (matching restoration is pending) DONE

NEW CHANGES DONE
---------------------------------------------
1. Add a new column 'Current' and show the selected documents from other tabs there while the system column should show all datas on the ledger.
2)ADD FIELD FOR HOTEL FILTERING
3)IF HOTEL FILTERING APPLIED ONLY SHOW HOTEL AND PREVIOUS TABS OTHER SHOULD BE HIDDEN
4)ADD PACKAGE

Actions #39

Updated by Theja Ponon 3 months ago

  • Status changed from Reopen Bugs to New Changes
Actions #40

Updated by Arathy PS 3 months ago

  • Assignee changed from Aparna Mathew to Vivekp V

Updated by Arathy PS about 2 months ago

Issue FIXED
--------------------
1.Missing procedure.

Actions #42

Updated by Vivekp V about 1 month ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
Edit Copy Actions

Also available in: Atom PDF