Project

General

Custom queries

Profile

Edit Copy Actions
Copy link

Feature #153

open

Profit & Loss Report

Added by Anil KV over 2 years ago. Updated 13 days ago.

Status:
Reopen Bugs Coding Done
Priority:
Normal
Assignee:
Augustin Jose
Target version:
22.12
Start date:
02/21/2023
Due date:
% Done:

70%

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

Description

Coding Profit & Loss Report

Files

clipboard-202505091725-ajnm0.png (143 KB) clipboard-202505091725-ajnm0.png Arathy PS, 05/09/2025 05:25 PM
Add

Subtasks

Add

Related issues

Actions
Copy link
 #1

Updated by Anil KV over 2 years ago

  • Assignee set to Junaid M
QuoteActions
Copy link
 #2

Updated by Anil KV almost 2 years ago

  • Status changed from New to Open
  • % Done changed from 0 to 10

Use Trial Balance Query - Some Changes in last part

    .......

        ON ca.pk_chart_of_ac_id = tr.fk_main_ledger_id
    LEFT JOIN accounts.tbl_account ac
        ON tr.fk_ledger_id = ac.pk_account_id
     WHERE ca.sin_chart_of_ac_category IN (3, 4);

Note:
-> Add Net Profit record also - Discus with junaid

Actions
Copy link
 #3

Updated by Junaid M almost 2 years ago

  • Assignee changed from Junaid M to Athul P
Actions
Copy link
 #4

Updated by Athul P almost 2 years ago

  • Status changed from Open to Coding Started
  • % Done changed from 10 to 40
Actions
Copy link
 #5

Updated by Athul P almost 2 years ago

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

Updated by Seema Mathew almost 2 years ago

  • Status changed from Coding Done to Reopen Bugs
  • % Done changed from 60 to 50
  • Tested By set to Seema Mathew

ISSUE FOUNDED-

1.THERE IS NO HEADER FILTER,EXPORT PDF,EXPORT ALL DATA IN THE PROFIT AND LOSS A/C - GRID

Actions
Copy link
 #7

Updated by Athul P almost 2 years ago

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

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 Seema Mathew to unnikannan S

ISSUE FOUNDED

1.NOT SHOWING DECIMAL VALUE

Actions
Copy link
 #9

Updated by Athul P over 1 year ago

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

Updated by unnikannan S over 1 year ago

TESTING DONE

QuoteActions
Copy link
 #11

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.ERROR WHILE CHOOSING PRINT WITHOUT DATA

Actions
Copy link
 #12

Updated by Athul P over 1 year ago

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

Updated by unnikannan S over 1 year ago

TESTING DONE

QuoteActions
Copy link
 #14

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.ERROR SHOWING WHILE SEARCH (42601: syntax error at or near "AND")

Actions
Copy link
 #15

Updated by Athul P over 1 year ago

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

Updated by unnikannan S over 1 year ago

TESTING DONE

Actions
Copy link
 #17

Updated by unnikannan S 8 months ago

  • Status changed from Reopen Bugs Coding Done to Testing Done
  • % Done changed from 70 to 90
Actions
Copy link
 #18

Updated by Anonymous 8 months ago

  • Assignee changed from Athul P to Augustin Jose
QuoteActions
Copy link
 #19

Updated by Arathy PS 24 days ago

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

ISSUE FOUND
-------------------------
The order of ledgers and main ledgers should be same as the one in chart of account.

Actions
Copy link
 #20

Updated by Augustin Jose 23 days ago

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

Updated by Arathy PS 23 days ago

ISSUE FIXED
-----------------------------
1. Document created on end of a financial year is not showing in the profit & loss on that date, instead it is showing in the next financial year profit & loss.

Actions
Copy link
 #22

Updated by Augustin Jose 13 days ago

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

Also available in: Atom PDF