Bug 19420

Summary: [Transactions - Customer payments] -Incorrect date sequence when using “Sort by Due Date” or “Sort by Name”
Product: ML_DB 64-bit Mac Reporter: Swathi <kswathi>
Component: Customer PaymentsAssignee: Swathi <kswathi>
Status: CLOSED ---    
Severity: Minor    
Priority: Low    
Version: 2026-14.0.22 + 26.0.1 Ver 03   
Hardware: MAC   
OS: macOS Catalina   

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