hello, i'm trying to do a one bank EFT payment to ...
# general
k
hello, i'm trying to do a one bank EFT payment to many bill payments in netsuite to match, but netsuite can't seem to do it. any reason i am doing this wrong, or any workarounds? basically $100K payment will show up as one line in the bank statement, but it is composed of 10 $10K bill payments in netsuite, and it can't seem to match it
a
Are you trying to Match bank data or to create EFT payment file?
k
match bank data
any idea @Arūnas Žindžius?
a
So you mark payment on the statement, then mark 10 bill payments on the right side, both side amounts shoud be equal and then click Match. Not sure whats the issue?
k
i just don't want to have to click it manually each time. i was trying to run reconcilation rules to automatch those but it doesn't seem to catch them
for example, the real situation is it's more like 100 bill payments, which means i have to click 100 checkmarks which is kind of annoying @Arūnas Žindžius
s
Note match bank data is a locked suitelet which cannot be scripted or manipulated
a
Oh I see. It would automatically match without any clicking if you prepare payments (using Electronic payments module) directly from Netsuite but it seems that's not the case, am I right? On other hand you can click "Mark all" if its possible to filter out these payments by date and name.
k
correct we don't use electronic payments module