Project

General

Profile

Edit Copy Actions

Feature #233

open

BSP Statement

Added by Anil KV over 1 year ago. Updated about 2 months ago.

Status:
Reopen Bugs Coding Done
Priority:
Normal
Target version:
Start date:
07/09/2023
Due date:
% Done:

70%

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

Description

Coding BSP Statement


Files


Add

Subtasks


Add

Related issues

Updated by Anil KV over 1 year ago

Solution

1) GUI Changes
->Issue Date*(Default) and Supplier Bill Date* toggle
-Consider Items -> Like Customer Sale & Refund Report - Tick All Items
-Only BSP Suppliers
2) Summary
- Issued, Cancelled, ADM, ACM, Credit Note, Debit Note, Other
*Issue, ADM, Credit Note, Other(Cr) -> Cr=Supplier Amount
*Cancelled, ACM, Debit Note, Other(Dr) -> Dr=Supplier Amount, amounts are -ve
3) Issue
SELECT spd.vhr_supp_doc_no,
        spd.dat_issue,
        spd.dat_sup_billing_issue,
        spd.dat_sale,
        spd.vhr_invoice_doc_no,
        (spd.jsn_related_data->'AIR_NUM_CODE'::VARCHAR) AS vhr_airline_num_code,
        sfr.vhr_currency,
        (sfr.dbl_fare - sfr.dbl_fare_paid_agency_cc - sfr.dbl_fare_paid_cust_cc - sfr.dbl_fare_paid_pax_cc - sfr.dbl_fare_shared_supplier - sfr.dbl_fare_shared_account) AS dbl_mf_credit,
        (sfr.dbl_fare_paid_agency_cc + sfr.dbl_fare_paid_cust_cc + sfr.dbl_fare_paid_pax_cc) AS dbl_mf_cash,
        (sfr.dbl_tax - sfr.dbl_tax_paid_agency_cc - sfr.dbl_tax_paid_cust_cc - sfr.dbl_tax_paid_pax_cc - sfr.dbl_tax_shared_supplier - sfr.dbl_tax_shared_account) AS dbl_tax_credit,
        (sfr.dbl_tax_paid_agency_cc - sfr.dbl_tax_paid_cust_cc - sfr.dbl_tax_paid_pax_cc) AS dbl_tax_cash,
        sfr.dbl_comm_percentage,
        (sfr.dbl_commission - sfr.dbl_commission_shared_supplier - sfr.dbl_commission_shared_account) AS dbl_commission,
        sfr.dbl_paid_commission_tax,
        (sfr.dbl_supplier_amount - sfr.dbl_supplier_payable_shared_supplier - sfr.dbl_supplier_payable_shared_account) AS dbl_supplier_amount,
        (sfr.dbl_supplier_amount - sfr.dbl_supplier_paid_agency_cc - sfr.dbl_supplier_paid_cust_cc - sfr.dbl_supplier_paid_pax_cc - sfr.dbl_supplier_payable_shared_supplier - sfr.dbl_supplier_payable_shared_account) AS dbl_supplier_payable
    FROM service.tbl_supp_doc_ap_sup_sharing sups
        INNER JOIN service.tbl_supp_doc_no spd
            ON sups.fk_supp_doc_no_id = spd.pk_supp_doc_no_id
                   AND sups.sin_supp_doc_category = 1
                AND sups.sin_record_type = 1 
                AND spd.sin_last_action != 0
        LEFT JOIN service.tbl_supp_doc_fare sfr
            ON sups.fk_supp_doc_sup_ledg_fare_id = sfr.pk_supp_doc_fare_id --Input currency base
    --WHERE 
        --AND (spd.sin_sys_sale_side_status = IN (1,2),
        --AND spd.dat_issue BETWEEN '2023-08-08' AND '2023-08-08' //Bill Date Case -> AND ((spd.dat_sup_billing_issue IS NOT NULL AND spd.dat_sup_billing_issue BETWEEN '2023-08-08' AND '2023-08-08') OR spd.dat_sup_billing_issue IS NULL AND spd.dat_issue BETWEEN '2023-08-08' AND '2023-08-08')

4) Cancel
SELECT spd.vhr_supp_doc_no,
        spd.dat_cancel,
        spd.dat_sup_billing_cancel,
        spd.dat_refund,
        spd.vhr_refund_doc_no,
        (spd.jsn_related_data->'AIR_NUM_CODE'::VARCHAR) AS vhr_airline_num_code,
        sfr.vhr_currency,
        (sfr.dbl_fare - sfr.dbl_fare_paid_agency_cc - sfr.dbl_fare_paid_cust_cc - sfr.dbl_fare_paid_pax_cc - sfr.dbl_fare_shared_supplier - sfr.dbl_fare_shared_account) AS dbl_mf_credit,
        (sfr.dbl_fare_paid_agency_cc + sfr.dbl_fare_paid_cust_cc + sfr.dbl_fare_paid_pax_cc) AS dbl_mf_cash,
        (sfr.dbl_tax - sfr.dbl_tax_paid_agency_cc - sfr.dbl_tax_paid_cust_cc - sfr.dbl_tax_paid_pax_cc - sfr.dbl_tax_shared_supplier - sfr.dbl_tax_shared_account) AS dbl_tax_credit,
        (sfr.dbl_tax_paid_agency_cc - sfr.dbl_tax_paid_cust_cc - sfr.dbl_tax_paid_pax_cc) AS dbl_tax_cash,
        sfr.dbl_comm_percentage,
        (sfr.dbl_commission - sfr.dbl_commission_shared_supplier - sfr.dbl_commission_shared_account) AS dbl_commission,
        sfr.dbl_paid_commission_tax,
        (sfr.dbl_sup_rfd_charge - sfr.dbl_sup_rfd_charge_paid_agency_cc - sfr.dbl_sup_rfd_charge_paid_cust_cc - sfr.dbl_sup_rfd_charge_paid_pax_cc - sfr.dbl_sup_rfd_charge_shared_supplier - sfr.dbl_sup_rfd_charge_shared_account) AS dbl_sup_rfd_charge_cash,
        (sfr.dbl_sup_rfd_charge_paid_agency_cc + sfr.dbl_sup_rfd_charge_paid_cust_cc + sfr.dbl_sup_rfd_charge_paid_pax_cc) AS dbl_sup_rfd_charge_cash,
        (sfr.dbl_supplier_amount - sfr.dbl_supplier_payable_shared_supplier - sfr.dbl_supplier_payable_shared_account) AS dbl_supplier_amount,
        (sfr.dbl_supplier_amount - sfr.dbl_supplier_paid_agency_cc - sfr.dbl_supplier_paid_cust_cc - sfr.dbl_supplier_paid_pax_cc - sfr.dbl_supplier_payable_shared_supplier - sfr.dbl_supplier_payable_shared_account) AS dbl_supplier_receivable
    FROM service.tbl_supp_doc_ap_sup_sharing sups
        INNER JOIN service.tbl_supp_doc_no spd
            ON sups.fk_supp_doc_no_id = spd.pk_supp_doc_no_id
                   AND sups.sin_supp_doc_category = 1
                AND sups.sin_record_type = 2 
                AND spd.sin_last_action != 0
        LEFT JOIN service.tbl_supp_doc_fare sfr
            ON sups.fk_supp_doc_sup_ledg_fare_id = sfr.pk_supp_doc_fare_id --Input currency base
    --WHERE 
        --AND (spd.sin_sys_sale_side_status = IN (1,2),
        --AND spd.dat_cancel BETWEEN '2023-08-08' AND '2023-08-08' //Bill Date Case -> AND ((spd.dat_sup_billing_cancel IS NOT NULL AND spd.dat_sup_billing_cancel BETWEEN '2023-08-08' AND '2023-08-08') OR spd.dat_sup_billing_cancel IS NULL AND spd.dat_cancel BETWEEN '2023-08-08' AND '2023-08-08')
5) ADM/ACM, CN/DN, Other -> vhr_sys_module_name base grouping in .cs
SELECT tr.vhr_sys_module_name,
    doc.vhr_document_no,
    tr.dat_transaction,
    tr.dbl_ledg_cur_debit,
    tr.dbl_ledg_cur_credit,
    tr.vhr_reference,
    tr.txt_narration
    --jsn_related_data
FROM transaction.tbl_transaction tr
    LEFT JOIN document.tbl_documents doc
        ON tr.fk_documents_id = doc.pk_documents_id
WHERE tr.sin_posting_status = 1
    AND tr.sin_transaction_status = 1
    AND tr.sin_document_status = 1
    --AND tr.fk_ledger_id = 1
    --AND tr.fk_branch_id = 1
    --AND tr.fk_department_id = 1
ORDER BY tr.dat_transaction

Actions #2

Updated by Anil KV over 1 year ago

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

Updated by Junaid M over 1 year ago

  • Assignee changed from travvise Admin to Athul P
Actions #4

Updated by Anil KV about 1 year ago

  • Status changed from Open to Ready for Coding
  • % Done changed from 10 to 20
Actions #5

Updated by Anonymous 8 months ago

  • Assignee changed from Athul P to Augustin Jose
Actions #6

Updated by Augustin Jose 7 months ago

  • Status changed from Ready for Coding to Coding Started
  • % Done changed from 20 to 30
Actions #7

Updated by Augustin Jose 7 months ago

  • Status changed from Coding Started to Coding Done
  • % Done changed from 30 to 60
Actions #8

Updated by unnikannan S 7 months ago

  • Status changed from Coding Done to Testing Started

Updated by unnikannan S 7 months ago

  • Status changed from Testing Started to Reopen Bugs
  • % Done changed from 60 to 50
  • Tested By set to unnikannan S

ISSUE FOUNDED

1.Show Amounts In List As Right Allign
2.Not Working Base 2 Currency Wise Search
3.Correct The Icon Of New,Print Buttons
4.Clear Invoice Date Showing In List In Case Of No Sale
5.Fix The Working Of Tool Bars In Grid
6.Fix The Working Of Supplier Date
7.Allow A Gap Between Columns While Choosing Supplier On Supplier Auto Complete Field
8.Dn/Cn Name Show As Capital On List And Column
9.Show Issue Date In Print

Actions #10

Updated by Augustin Jose 7 months ago

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

Updated by unnikannan S 6 months ago

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

ISSUE FOUNDED

1.Not Loading Data That Directly Saved In Cancel Modules

Updated by Arathy PS 6 months ago

ISSUE FOUND
-----------------------
1) Showing invoice date for ticket that is only issued.
2) Data not showing in DN/CN tab.

Actions #13

Updated by Augustin Jose 5 months ago

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

Updated by unnikannan S 5 months ago

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

ISSUE FOUNDED

1.Show ROE Wise Amount Change In Issued/Cancel Tabs
2.Missing Precision Cancelled Tab STD%

Actions #15

Updated by Augustin Jose 5 months ago

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

Updated by Arathy PS 4 months ago

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

ISSUE FOUND
-------------------------------------------
1.1. Document not reloading to payment+ and receipt+ modules

Actions #17

Updated by Augustin Jose 4 months ago

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

Updated by Arathy PS 4 months ago

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

ISSUE FOUND
--------------------------------
1. Data not showing in other tab.

Actions #19

Updated by Augustin Jose 4 months ago

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

Updated by Theja Ponon 4 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
  • % Done changed from 70 to 90

Updated by Arathy PS 4 months ago

  • Status changed from Reopen Bugs Testing Done to Reopen Bugs
  • % Done changed from 90 to 50

ISSUE FOUND
-------------------------------------------
1. Not showing voucher from package, other issue, hotel issue, visa issue.
2. Not showing 'No data found' message on selecting currencies that are not used in transaction.

Actions #22

Updated by Augustin Jose 4 months ago

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

Updated by Arathy PS 3 months ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs Testing Done
  • % Done changed from 70 to 90

Updated by Arathy PS 2 months ago

ISSUE FOUND
-------------------------
1. In summary tab total of other tabs are also showing

2. When we do AP sharing that ticket appears two times in the issue tab.

3. In the other column should show net payable and supplier amount if it is a credit entry.
4. In the print wrong amount in tax credit and tax cash.

5. Not redirecting to sale if the ticket is sold.
6. Give redirection to the ticket no: and invoice no:

Actions #25

Updated by Augustin Jose about 2 months ago

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

Updated by Arathy PS about 2 months ago

ISSUE FOUND
-------------------------
1. Give redirection to the ticket no: and invoice no:
2.

Actions #27

Updated by Arathy PS about 2 months ago

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

Updated by Augustin Jose about 2 months 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