Bug 19665

Summary:	[Import - Sales] - Incorrect Due Date, Date Format, and Amount Values Displayed in Customer Payments and Finance Charges After Sales Import.
Product:	ML DB 64-bit Win	Reporter:	Swathi <kswathi>
Component:	Import	Assignee:	SVPrasad <SVPrasad>
Status:	RESOLVED FIXED
Severity:	Major
Priority:	High
Version:	Version-08
Hardware:	Windows
OS:	Windows 10 Pro

Description Swathi 2026-06-02 13:06:33 IST

Issue 1:-
After importing Sales with all fields, the following issues are observed in the Customer Payments screen.

1.The Due/Disc Date is displaying incorrect values.
2.The Date field format is displayed incorrectly as MM/D... instead of MM/DD/YY.
3.The Amt Due value is displayed By multiple of 100.

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

Issue 2:-
After importing Sales with all fields, the Due Date displayed in the Finance Charges screen is incorrect 
Screenshot1:-
https://drive.google.com/file/d/1AqaZUPN-qUr57B-KvKfy6sIwrIkWCvSY/view?usp=sharing

TXT File:-
https://drive.google.com/file/d/1TVWWo3SNuxQbq-bB38cL4QnviAGA7b7l/view?usp=sharing

Comment 1 Swathi 2026-06-04 10:54:41 IST

Same Issue 1 is getting for invoices also 
Issue 3

Screenshot:-
https://drive.google.com/file/d/1CL6gh_HluQfVwPL3mYvCG2y6bTCJvhUG/view?usp=sharing
Txt file:-
https://drive.google.com/file/d/1jtWtGJ-aw0D1AniTmaf_LMYOtBtMUvlm/view?usp=sharing

Comment 2 Kmaneesh 2026-06-18 13:19:34 IST

Fixed And Available For Next Build