Project

General

Custom queries

Add

Watchers (4)

Profile

Edit Copy Actions
Copy link

Feature #153

open

Profit & Loss Report

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

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

90%

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

Add

Subtasks

Add

Related issues

Actions
Copy link
 #1

Updated by Anil KV about 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 over 1 year ago

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

Updated by Athul P over 1 year ago

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

Updated by Athul P over 1 year ago

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

Updated by Seema Mathew over 1 year 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 over 1 year 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 6 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 6 months ago

  • Assignee changed from Athul P to Augustin Jose
Edit Copy Actions
Copy link

Also available in: Atom PDF