Project

General

Profile

Edit Copy Actions
Copy link

Feature #232

open

Merged Ledger Statement

Added by Anil KV over 1 year ago. Updated 4 days ago.

Status:
Reopen Bugs
Priority:
Normal
Assignee:
Augustin Jose
Target version:
22.12
Start date:
07/09/2023
Due date:
% Done:

50%

Estimated time:
Owner(Agency):
Travvise
Time Taken(HH):
Module:
Supplier Merged SOA
Tested By:
unnikannan S
Code Reviewed By:
Quote

Description

Coding Supplier Merged SOA

Add

Subtasks

Add

Related issues

QuoteActions
Copy link
 #1

Updated by Anil KV over 1 year ago

Solution:-
  • Check
    #224(Customer Document Wise SOA -> Remove SUM and grouping part in data sql)
Actions
Copy link
 #2

Updated by Anil KV over 1 year ago

  • Status changed from New to Open
  • % Done changed from 0 to 10
QuoteActions
Copy link
 #3

Updated by Anil KV over 1 year ago

Solutions:-

1) GUI Changes
- Defult Tick Matched and Outstanding Checkbox
-Main Ledger* - Not mandatory - Check ledger stmt
-Checkbox alignment issue - Check - Customer Document Wise SOA
-Add Merge Selectbox in Details list title bar
*Items
Day Wise
Fortnight Wise
Month Wise
Service Wise
Module Wise
Sale, Refund and Other Wise
Sub Customer(Profile) Wise
Sub Ledger Wise
2)Check and Discus with Athul P
-#224(Customer Document Wise SOA -> Remove SUM and grouping part in data sql)
-#225 Customer Item Wise SOA
-#226 Customer Service Wise SOA
Actions
Copy link
 #4

Updated by Anil KV over 1 year ago

  • Assignee changed from travvise Admin to Athul P
Actions
Copy link
 #5

Updated by Anil KV over 1 year ago

  • Subject changed from Supplier Merged SOA to Merged Ledger Statement
QuoteActions
Copy link
 #6

Updated by Anil KV over 1 year ago

Anil KV wrote:

Coding Merged Ledger Statement

QuoteActions
Copy link
 #7

Updated by Anil KV over 1 year ago

Anil KV wrote:

Coding Supplier Merged SOA

Merged Ledger Statement

Actions
Copy link
 #8

Updated by Anil KV about 1 year ago

  • Status changed from Open to Ready for Coding
  • % Done changed from 10 to 20
Actions
Copy link
 #9

Updated by Anonymous 7 months ago

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

Updated by Anonymous 7 months ago

  • Status changed from Ready for Coding to Coding Started
  • % Done changed from 20 to 30
Actions
Copy link
 #11

Updated by Augustin Jose 7 months ago

  • Status changed from Coding Started to Ready for Coding
  • % Done changed from 30 to 20
Actions
Copy link
 #12

Updated by Augustin Jose 7 months ago

  • Status changed from Ready for Coding to Coding Started
  • % Done changed from 20 to 30
Actions
Copy link
 #13

Updated by Augustin Jose 7 months ago

  • Tracker changed from Feature to Change Request
Actions
Copy link
 #14

Updated by Augustin Jose 7 months ago

  • Tracker changed from Change Request to Feature
QuoteActions
Copy link
 #15

Updated by Augustin Jose 6 months ago

  • Status changed from Coding Started to Particialy Coding Done
  • % Done changed from 30 to 40

To Do:
Debit-Credit Wise Grouping
Opening Balance Position While Grouping:- must be in top,

QuoteActions
Copy link
 #16

Updated by unnikannan S 6 months ago

  • Status changed from Particialy Coding Done to Reopen Bugs
  • % Done changed from 40 to 50
  • Tested By set to unnikannan S

ISSUE FOUNDED

1.In Case Of Month Wise Merging Data Show As (January-December)

QuoteActions
Copy link
 #17

Updated by Anil KV 6 months ago

Wrong Display

Change:-

->Merge By
-Add 'Week(Fri-Thu)', 'Week(Sat-Fri)', 'Week(Sun-Sat)', 'Week(Mon-Sun)'
->Group By 2 Select box
- 1 st selection box item :-
- Rename - 'No Merge' to 'No Grouping'
- Add Main ledger

-> Rename Details tab -> No Merge Details
-> Add a tab -> Merge Details
- Columns
Period | Document | Debit | Credit | Balance | Ticket/Voucher | LPO | File No | Enquiry No | Reference | Narration | Build Narration
* Document , Ticket/Voucher, LPO, File No, Enquiry No, Reference, Narration, Build Narration are join unique items
QuoteActions
Copy link
 #18

Updated by Anil KV 6 months ago

Wrong Display

Change:-

->Merge By
-Add 'Week(Fri-Thu)', 'Week(Sat-Fri)', 'Week(Sun-Sat)', 'Week(Mon-Sun)'
->Group By 2 Select box
- 1 st selection box item :-
- Rename - 'No Merge' to 'No Grouping'
- Add Main ledger

-> Rename Details tab -> No Merge Details
-> Add a tab -> Merge Details
- Columns
Period | Document | Debit | Credit | Balance | Ticket/Voucher | LPO | File No | Enquiry No | Reference | Narration | Build Narration
* Document , Ticket/Voucher, LPO, File No, Enquiry No, Reference, Narration, Build Narration are join unique items

-> Summary tab
-Columns
Item | Debit | Credit | Balance
*Item Column Values
Opening Balance
[Adjustment Entry]
Current Debit
Current Credit
Closing Balance/Amount Payable to you/ Amount Receivable to you
Not Approved Debit
Not Approved Credit
Debit After To Date
Credit After To Date
Projected Balance
Actions
Copy link
 #19

Updated by Augustin Jose 5 months ago

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

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.Error While Unticking Matched,Outstanding,Consider Match Together
Column 'fk_main_ledger_id' does not belong to table Table.

Actions
Copy link
 #21

Updated by Augustin Jose 5 months ago

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

Updated by Arathy PS 5 months ago

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

ISSUE FOUND
--------------------------------
1.Data showing in the beginning without any grouping when select merge, grouping and credit/debit

Actions
Copy link
 #23

Updated by Augustin Jose 5 months ago

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

Updated by Arathy PS 3 months ago

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

ISSUE FOUND
---------------------------------------------------
1. Data showing in 'Not Approved Document Amount' field even after approving it through document approve module.
2. Data not showing in the details column while it is showing in the system column of summary tab.

Actions
Copy link
 #25

Updated by Augustin Jose 3 months ago

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

Updated by Theja Ponon 4 days ago

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

Issue Found
-----------
1)Data is not showing in Uncleared paid and Uncleared Received Cheque

Edit Copy Actions
Copy link

Also available in: Atom PDF