Project

General

Profile

Edit Copy Actions
Copy link

Feature #140

open

Main Ledger Report

Added by Anil KV about 2 years ago. Updated 4 months ago.

Status:
Reopen Bugs Coding Done
Priority:
Normal
Assignee:
Baseem Shan
Target version:
22.12
Start date:
02/17/2023
Due date:
% Done:

70%

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

Description

Coding Main Ledger Report

Files

SQL-MainLedgerReport.sql (3.32 KB) SQL-MainLedgerReport.sql Junaid M, 02/16/2023 02:15 PM
Add

Subtasks

Add

Related issues

Actions
Copy link
 #1

Updated by Junaid M about 2 years ago

  • File SQL-MainLedgerReport.sql added
Actions
Copy link
 #2

Updated by Junaid M about 2 years ago

  • File deleted (SQL-MainLedgerReport.sql)
QuoteActions
Copy link
 #3

Updated by Junaid M about 2 years ago

UI Change
1) Remove Column/Grouping from search area

MainLedger Condition: sin_chart_of_ac_type -> 2 Only

Controller Name: BackOfficeReport Controller

Sql Querry: vhr_currency = 'QAR' where condition only apply in query if search input currency is not base1 or base2

Actions
Copy link
 #4

Updated by Junaid M about 2 years ago

  • Status changed from New to Open
  • % Done changed from 0 to 10
Actions
Copy link
 #5

Updated by Junaid M about 2 years ago

  • Assignee changed from Junaid M to Shanto Shaji
Actions
Copy link
 #6

Updated by Shanto Shaji about 2 years ago

  • Status changed from Open to Coding Started
  • Start date changed from 02/02/2023 to 02/17/2023
  • % Done changed from 10 to 40
Actions
Copy link
 #7

Updated by Shanto Shaji about 2 years ago

  • Status changed from Coding Started to Coding Done
  • % Done changed from 40 to 60
QuoteActions
Copy link
 #8

Updated by Amal Cyriac about 2 years ago

  • Status changed from Coding Done to Reopen Bugs
  • % Done changed from 60 to 50
  • Tested By set to Amal Cyriac

ISSUE FOUND
1.SET VALIDATIONS ON DATE PICKER
(to date not be smaller than from date )
2.FIX BUGS ON MAIN LEDGER SELECTION BOX

Actions
Copy link
 #9

Updated by Shanto Shaji almost 2 years ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60
QuoteActions
Copy link
 #10

Updated by Amal Cyriac almost 2 years ago

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

ISSUE FOUND *****
1.Syntax error on Base 1 currency
(42601: syntax error at or near "FROM")
2.Set alignment on grid- Amount
(Align to Right)

Actions
Copy link
 #11

Updated by Shanto Shaji almost 2 years ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60
QuoteActions
Copy link
 #12

Updated by Amal Cyriac almost 2 years ago

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

ISSUE FOUND *****
1.Ledger currency reports are not showing on grid
2.Add sl. Number on grid

Actions
Copy link
 #13

Updated by Shanto Shaji almost 2 years ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60
QuoteActions
Copy link
 #14

Updated by Amal Cyriac almost 2 years ago

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

ISSUE FOUND *****
1.fix bugs while choose ledger currency
(only Base 2 reports showing )

Actions
Copy link
 #15

Updated by Shanto Shaji almost 2 years ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60
QuoteActions
Copy link
 #16

Updated by Amal Cyriac over 1 year ago

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

ISSUE FOUND *****
1.Set Defaults on GUI
(Branch , Main Ledger , Currency)

Actions
Copy link
 #17

Updated by Shanto Shaji over 1 year ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60
QuoteActions
Copy link
 #18

Updated by Shanto Shaji over 1 year ago

Issue Fixed Now

QuoteActions
Copy link
 #19

Updated by Amal Cyriac over 1 year ago

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

ISSUE FOUND *****
1.Fix bugs on Main Ledger Multi selection box - Drop down Icon missing
2.Fix errors on currency - selected currency change to default while search
3.Defaults not clear on reset

Actions
Copy link
 #20

Updated by Shanto Shaji over 1 year ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60
QuoteActions
Copy link
 #21

Updated by unnikannan S over 1 year ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 60 to 50
  • Tested By changed from Amal Cyriac to unnikannan S

ISSUE FOUNDED

1.FILTER ERASER NOT WORKING
2.SELECTING ALL LIST WHILE CHOOSING ONE

Actions
Copy link
 #22

Updated by Shanto Shaji over 1 year ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60
QuoteActions
Copy link
 #23

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

1.1.ADD DR,CR IN NET BALANCE CLOSING BALANCE AND OPENING BALANCE (-VE AMOUNT-CR,+VE AMOUNT DR)

Actions
Copy link
 #24

Updated by Shanto Shaji over 1 year ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 60
QuoteActions
Copy link
 #25

Updated by unnikannan S over 1 year ago

unnikannan S wrote in #note-23:

ISSUE FOUNDED

1.1.ADD DR,CR IN NET BALANCE CLOSING BALANCE AND OPENING BALANCE (-VE AMOUNT-CR,+VE AMOUNT DR)
1.2.CORRECT THE NET VALUE

Actions
Copy link
 #26

Updated by Shanto Shaji over 1 year ago

  • Status changed from Reopen Bugs Coding Done to Reopen Bugs
  • % Done changed from 60 to 50
Actions
Copy link
 #27

Updated by Junaid M over 1 year ago

  • Assignee changed from Shanto Shaji to Baseem Shan
QuoteActions
Copy link
 #28

Updated by Baseem Shan over 1 year ago

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

Added Print button and New Button. Solved issues with Reset Button and Date Period

QuoteActions
Copy link
 #29

Updated by unnikannan S over 1 year ago

TESTING DONE

QuoteActions
Copy link
 #30

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.DUPLICATION OF MAIN LEDGER CODE IN PRINT

Actions
Copy link
 #31

Updated by Baseem Shan 12 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
QuoteActions
Copy link
 #32

Updated by unnikannan S 9 months ago

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

ISSUE FOUNDED

FIXED - 1.Show Data Of Income/Expense (COA) Main Ledgers

Actions
Copy link
 #33

Updated by Baseem Shan 9 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
QuoteActions
Copy link
 #34

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

FIXED - 1.Validate Transaction Date

Actions
Copy link
 #35

Updated by Baseem Shan 6 months ago

  • Status changed from Reopen Bugs to Reopen Bugs Coding Done
  • % Done changed from 50 to 70
QuoteActions
Copy link
 #36

Updated by Arathy PS 4 months ago

TESTING SCENERIO TO BE CHECKED
-------------------------------------------------
1. After completing the changes in 'year end' module check the functioning of the field 'consider PL&L'.

Edit Copy Actions
Copy link

Also available in: Atom PDF