Bug 19420 - [Transactions - Customer payments] -Incorrect date sequence when using “Sort by Due Date” or “Sort by Name”
Summary: [Transactions - Customer payments] -Incorrect date sequence when using “Sort ...
Status: CLOSED
Alias: None
Product: ML_DB 64-bit Mac
Classification: Unclassified
Component: Customer Payments (show other bugs)
Version: 2026-14.0.22 + 26.0.1 Ver 03
Hardware: MAC macOS Catalina
: Low Minor
Assignee: Swathi
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2026-05-01 10:21 IST by Swathi
Modified: 2026-05-05 11:31 IST (History)
0 users


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Swathi 2026-05-01 10:21:56 IST 
Steps to reproduce:-
1.Open customer invoice or sales journal screen
2.Create multiple invoices with different dates in single months 
3.Navigate to the customer payments screen
4.Select “Sort by Due Date” and observe the Date/Disc Date order
5.next select “Sort by Name” and observe the Date/Disc Date order

Screenshot1:-
https://drive.google.com/file/d/1VX96QMMvOoEzu_TQsyyouBlVcSyqn74Y/view?usp=sharing
Screenshot2:-
https://drive.google.com/file/d/1D_OARENMLBbfTBm94VkZh3fgFmLBb4NC/view?usp=sharing

DB:-
https://drive.google.com/file/d/1c5YayDpcKMQIJM8M6sIpZC0mwtEBQUiA/view?usp=sharing
Comment 1 Bhavani 2026-05-01 10:52:40 IST 
Fixed, Available in next build
Comment 2 Nayab 2026-05-05 11:31:06 IST 
Issue 1 and 2 working fine as expected

Screen Record:
https://drive.google.com/file/d/1KhRpN2hE9JVcfO4X7NdRKGLmKZjC2Meo/view?usp=sharing