Project

General

Profile

Edit Copy Actions

Feature #239

open

Customer Ageing Report

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

Status:
Reopen Bugs Coding Done
Priority:
Normal
Target version:
Start date:
07/09/2023
Due date:
% Done:

70%

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

Description

Coding Customer Ageing Report


Files

clipboard-202501201020-bn4z9.png (22.3 KB) clipboard-202501201020-bn4z9.png Theja Ponon, 01/20/2025 10:20 AM

Add

Subtasks


Add

Related issues

Updated by Anil KV over 1 year ago

Solutions
-Check Customer Document Wise SOA Ageing tab
1) GUI Changes
-Add Status filter like ledger stmt
2) SQL

Actions #2

Updated by Anil KV over 1 year ago

  • Status changed from New to Open
  • Assignee changed from travvise Admin to Athul P
  • % Done changed from 0 to 10
Actions #3

Updated by Athul P over 1 year ago

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

Updated by Athul P 12 months ago

  • Status changed from Coding Started to Coding Done
  • % Done changed from 30 to 60

Updated by unnikannan S 12 months ago

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

ISSUE FOUNDED

1.ADD VALIDATION FOR BRANCH,STATUS
2.ERROR WHILE CLEARING CUSTOM FIELD DATA

Actions #6

Updated by Athul P 12 months ago

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

Updated by unnikannan S 11 months ago

ISSUE FOUNDED

1.Show Data As Per Selected Items In Consider Filter Field
2.Fix Bugs On Print
3.Show Data As Per Selected Filter Fields In UI

Actions #8

Updated by unnikannan S 11 months ago

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

Updated by Athul P 11 months ago

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

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

1.Show Data As Per Consider Selected Items

Actions #11

Updated by Athul P 9 months ago

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

Updated by unnikannan S 6 months ago

  • Status changed from Reopen Bugs Coding Done to Testing Done
  • % Done changed from 70 to 90
Actions #13

Updated by Anonymous 6 months ago

  • Assignee changed from Athul P to Nithin PM
Actions #14

Updated by Theja Ponon 2 months ago

  • Status changed from Testing Done to New Changes
  • % Done changed from 90 to 50
Actions #15

Updated by Anil KV 2 months ago

  • Assignee changed from Nithin PM to Augustin Jose

Updated by Theja Ponon about 2 months ago

New Change
--------------
1) Add Fields on Screenshot given by NBK

Updated by Arathy PS about 2 months ago

New Changes
-------------------------
*Ref: Customer Overdue Report
-> Custom(Ageing Periods)*B -> Tittle - like Admin settings
-> In the drop down add another field after monthly, weekly, quarterly.
->Add Filter System Type - Multiselect - Customer Master System Type--apart from general accounts.
-> Grouping Selectbox No Grouping, Category, Group, Type, Family, System Type -> In List header
-> Name Column Split  to  Code | Customer Name
-> Add Column After 'Total A/R'  -> Hide Print
- Due Amount 
- Not Due(Total A/R - Due Amount)  -> Hide Print
-> Set 9 Custom Fields
-  Last Custom Column (10 th Custom Fields) > {{before Column Value - Second Part }}
* Blue * with Period each column title/hint
-> Add/Replace Columns - last
- Bill Submission -> Hide Print
- Credit Limit  -> Hide Print
- Payment Terms  -> Hide Print
- Grace Period to Grace Days  -> Hide Print
- Last Bill Period   -> Hide Print
- Last Payment Date  -> Hide Print
- Last Due Date  -> Hide Print
- Last Over Due Days  -> Hide Print
- Last Bill Due  -> Hide Print
Actions #18

Updated by Augustin Jose about 1 month ago

  • Status changed from New Changes to New Changes Coding Done
  • % Done changed from 50 to 70

Updated by Arathy PS 21 days ago

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

ISSUE FOUND
--------------------------
1. Total amount, overdue balance, credit days, average due days and source columns are missing in grid.
2. Category is missing in the grouping.
3. Grouping is not working.
4. In the main ledger all the items that are showing should be of type main ledger.
5. Group, family, category, Type filter not working.
6. Data showing the A/R is not correct if settlement is done. (based on as on date)
7. Cr entries are showing as Dr entries in print.

Actions #20

Updated by Augustin Jose 8 days ago

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

Also available in: Atom PDF