When uploading the Bank data for reconciliation, N...
# accounting
r
When uploading the Bank data for reconciliation, NetSuite says Your import completed successfully but when I go to Match Bank Data. some entries does not show up under any TO BE MATCHED, MATCHES TO SUBMIT OR EXCLUDED Subtab. Any idea what might be causing this.
a
Not much assistance, but if you have checked the locations listed, make sure you are uploading to the correct account if not using a financial institution. Otherwise mess around with date ranges? Possibly the date in your file is off. Pretty irritating that NS removed the ability to see the number of imported lines to validate these imports
c
There are likely BAI codes that do not match. NS only maps certain BAI codes out of the box.
k
normally I can't get the record to upload correctly if there are codes that don't match - I would doubt that's the issue
r
@Alex K @Chap Moore @KevinJ of Kansas This is the data which we download from Well Fargo bank as csv and upload to NS. I do not get what codes are you referring to
a
Doesn't look like you are using the BAI2 parser which I believe @Chap Moore is referring to, this looks like a standard csv format. Idk, most likely some sort of user error. If you have a test environment try there or create a ticket with NS support
r
@Alex K BAI2 parser is something through scripting
c
No BAI is not scripted take a look in this doc
Page 69 of 148 is the place
r
@Chap Moore Thank you. I was able to resolve it by modifying the csv format.
c
Good news