search

frappe / erpnext

Free and Open Source Enterprise Resource Planning (ERP)
https://erpnext.com
GNU General Public License v3.0
21.52k stars 7.28k forks source link

Unordered import bank statement through Bank Reconciliation Tool #36203

Open nissekalle0 opened 1 year ago

nissekalle0 commented 1 year ago

Information about bug

Sr. No field can not be matched in the input list if contained as a column in the csv file. Rows with the same date is imported in different order in the file, i.e. they changed position in the Bank Transaction List. I want the same order in the list as in the file after import!

Add the Sr. No filed as importable from CSV file.

Module

accounts

Version

Frappe and ERPNext ver 14.x

Installation method

None

Relevant log output / Stack trace / Full Error Message.

No response

marination commented 1 year ago

Could this not be achieved by sorting the transactions by date? I would assume your CSV file exported by the bank is also sorted by date in some order?

nissekalle0 commented 1 year ago

There could be several transaction with the same date! Time does not follow the bank string... so it won't work unless you keep the order.

Den mån 24 juli 2023 09:24Marica @.***> skrev:

Could this not be achieved by sorting the transactions by date? I would assume your CSV file exported by the bank is also sorted by date in some order?

— Reply to this email directly, view it on GitHub https://github.com/frappe/erpnext/issues/36203#issuecomment-1647356396, or unsubscribe https://github.com/notifications/unsubscribe-auth/AVAVD35EWFAACWDGDU266DLXRYPLZANCNFSM6AAAAAA2QQYIJQ . You are receiving this because you authored the thread.Message ID: @.***>