Project

General

Profile

Edit Copy Actions

Feature #259

open

Ledger Comparison Report

Added by Anil KV over 1 year ago. Updated 6 months ago.

Status:
Testing Done
Priority:
Normal
Assignee:
Target version:
Start date:
07/09/2023
Due date:
% Done:

90%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Ledger Comparison Report
Tested By:
unnikannan S
Code Reviewed By:

Description

Module Widget Data Source Pending...


Files


Add

Subtasks


Add

Related issues

Updated by Anil KV over 1 year ago

GUI Change
-Check the attachment image

Updated by Anil KV over 1 year ago

SQL

SELECT fk_main_ledger_id,
        fk_ledger_id,
        TO_CHAR(dat_transaction, 'Month') AS str_month,
        TO_CHAR(dat_transaction, 'YYYY') AS str_year,
        SUM(dbl_ledg_cur_debit) AS dbl_debit,
        SUM(dbl_ledg_cur_credit) AS dbl_credit
    FROM transaction.tbl_transaction
    WHERE sin_posting_status = 1
        AND sin_transaction_status = 1
        AND sin_document_status = 1
        AND vhr_ledg_currency = 'QAR'
        ...
    GROUP BY fk_main_ledger_id, fk_ledger_id, str_month, str_year;

* Base1 Currency case
SUM(dbl_base_cur_debit) AS dbl_debit,
        SUM(dbl_base_cur_credit) AS dbl_credit
-No filter Currency wise

Actions #3

Updated by Baseem Shan over 1 year ago

  • Status changed from Open to Coding Started
  • % Done changed from 10 to 40
Actions #4

Updated by Baseem Shan over 1 year ago

  • Description updated (diff)
  • Status changed from Coding Started to Coding Done
  • % Done changed from 40 to 60
Actions #5

Updated by unnikannan S over 1 year ago

  • Status changed from Coding Done to Reopen Bugs
  • % Done changed from 60 to 50
  • Tested By set to unnikannan S
Actions #6

Updated by Baseem Shan over 1 year ago

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

Updated by unnikannan S over 1 year ago

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

ISSUE FOUNDED

FIXED - 1.SHOWING CREDIT AMOUNT AS DEBIT
FIXED - 2.SHOWING INCORRECT MONTHLY QUARTER AMOUNT
FIXED - 3.CLEAR ACCOUNT FILTER DATA WHILE SELECTING DROP DOWN
FIXED - 4.SHOWING FALSE AMOUNT WHILE SEARCH WITH BASE 1 CURRENCY
5.DONT FREEZE SEARCH BUTTON (Already Freezing Drop Downs After Getting Data So Dont Need To Disable The Button)

Actions #8

Updated by Baseem Shan 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

Actions #10

Updated by unnikannan S 6 months ago

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

Also available in: Atom PDF