Project

General

Profile

Edit Copy Actions

Feature #148

open

Supplier Overdue Report

Added by Anil KV about 2 years ago. Updated 10 days ago.

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

70%

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

Description

Coding Supplier Overdue Report


Files

SQL-SUP-OVERDUE.SQL (3.29 KB) SQL-SUP-OVERDUE.SQL Junaid M, 02/28/2023 10:39 AM
clipboard-202501281630-0an53.png (78 KB) clipboard-202501281630-0an53.png Theja Ponon, 01/28/2025 04:30 PM

Add

Subtasks


Add

Related issues

Actions #1

Updated by Junaid M about 2 years ago

  • Status changed from New to Open
  • % Done changed from 0 to 10
Actions #2

Updated by Junaid M about 2 years ago

  • Assignee changed from Junaid M to Akash B
Actions #3

Updated by Akash B about 2 years ago

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

Updated by Akash B about 2 years ago

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

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.Search results must be sort based on,

Payment Terms                        (Selection Box)                        
Consider Matching Done After To Date (check box)
Consider (Selection box)
Debit & Credit (Check Box)

2.Show proper information on grid (Due Date -> Wrong Details)

Actions #7

Updated by Akash B about 2 years ago

  • Status changed from Reopen Bugs to Particialy Coding Done
  • % Done changed from 50 to 40

Updated by unnikannan S over 1 year ago

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

ISSUE FOUNDED

1.UI CRASHING WHILE SELECTING MODULE AND SEARCH
2.DROP OPTION MISSING FROM
CURRENCY,STATUS,MODULE
3.CHANGE REPORT LIST INTO LIST IN GRID
4.CHANGE TOOL TIP OF AS ON DATE INTO AS ON TRANSACTION DATE

Actions #9

Updated by Junaid M over 1 year ago

  • Assignee changed from Akash B to Amal Siby

Updated by Amal Siby over 1 year ago

Bug Fixed.

Pending To Do
-----------------
=> Search to Do based on( Credit Limit, Credit Limit based On) According to New Changed In Supplier.
=> Module Sorting.

Updated by Amal Siby over 1 year ago

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

Completed.

Updated by Seema Mathew over 1 year ago

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

ISSUE FOUNDED****

1. MISSING ERASER FILTER TAB.
2. PAYMENT TERMS DATA MUST BE IN PRINT.

Actions #13

Updated by Amal Siby over 1 year ago

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

Updated by unnikannan S over 1 year ago

ISSUE FOUNDED

1.SHOW ACT US CLIENT A/C'S DATA (BASED ON CONSIDER FILTER)
2.SHOW DATA BASED ON SELECTING PAYMENT TERMS ITEMS WITJOUT CHECK BOX

Updated by unnikannan S about 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.SHOW DATA AS PER CHOOSEN PAYMENT TERMS BY SUPPLIERS ONLY
2.EFFECTIVE DATE IS MANDATORY
3.OUTSTANDING=UP TO AS ON DATE:NET OUTSTANDING
4.ADD A BLANK OPTION FOR PAYMENT TERMS FIELD
5.REDUCE CURRENCY COLUMN WIDTH IN LIST

Actions #16

Updated by Anil KV 12 months ago

  • Assignee changed from Amal Siby to Athul P
Actions #17

Updated by Junaid M 10 months ago

  • Status changed from Reopen Bugs to New Changes
Actions #18

Updated by Athul P 7 months ago

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

Updated by unnikannan S 6 months ago

  • Status changed from New Changes Coding Done to Testing Done
  • % Done changed from 70 to 90
Actions #20

Updated by Anonymous 6 months ago

  • Assignee changed from Athul P to Junaid M

Updated by Junaid M 6 months ago

Workflow Changes [03/10/2024]
---------------------------------------------------------------------
Customer,Supplier Master:
1. In System Tab -> Credit Limit Based On -> Add validation, If "Credit Limit Amount" is given then "Credit Limit Based On" is mandatory.

Extra Credit Limit/Payment Days
---------------------------------------------------------------------
1. Split Extra Limit widget. Add Currency as label on right side

Customer Overdue/Supplier/Staff Overdue Report
---------------------------------------------------------------------
1. Add title if there is a start mark on widgets.
2. Add blank option in currency selectbox In Search filter area
3. Workflow change:- -> If Chooses Currency = "Ledger Currency" then only show overdue of accounts in which credit limit is set based on "Account Currency" 
                     -> If Chooses Currency = "Base1 Currency" then only show overdue of accounts in which credit limit is set based on "Base Currency" 
             -> If Chooses Currency = "Individual Currency" then only show overdue of accounts in which transaction currency is selected Currency.
             -> If Chooses Currency = "Blank Currency" option then only show overdue of accounts in all currency
Actions #22

Updated by Junaid M 6 months ago

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

Updated by Arathy PS 4 months ago

  • Assignee changed from Junaid M to Vivekp V

Updated by Arathy PS 4 months ago

  • Status changed from New Changes to Reopen Bugs

NEW CHANGES DONE
---------------------------------------
1. Add an additional column 'Total Due Amount' with title: total due upto the end of bill period, also add title for due amount.
2. Add an option on the constrain: 'Overdue based on total due amount'(default tick) add title.

ISSUE FIXED
--------------------------------------------------
1. Data showing when calculation based on: 'debit & credit outstanding net' or 'debit & credit net' is selected and only debit entry is present for the selected as on and effective date then data is showing.

Actions #25

Updated by Vivekp V 4 months ago

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

Updated by Arathy PS 2 months ago

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

NEW CHANGES
-------------------------------------
1. The data in 'calculation based on' field should appear based on the admin settings.

Actions #27

Updated by Arathy PS 2 months ago

  • Assignee changed from Vivekp V to Augustin Jose
Actions #28

Updated by Augustin Jose 2 months ago

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

Updated by Arathy PS 2 months ago

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

New Changes
--------------------------------
1. Three new fields are added in the payment terms--Submission Date, Corporate Approved (Submission), Corporate Approved (Invoice).
-- Make corresponding changes here also
-- Discuss with vivek and anil

Updated by Theja Ponon about 2 months ago

1)Issue found
-----------

Actions #31

Updated by Augustin Jose about 2 months ago

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

Updated by Augustin Jose about 2 months ago

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

Updated by Augustin Jose 24 days ago

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

Updated by Theja Ponon 15 days ago

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

ISSUE FOUND
----------
1)overdue is not showing when payment term is set based on submission date

Actions #35

Updated by Augustin Jose 10 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