Issue Client would like to import the account statements from a particular bank and to display it under the “Match Bank Data” page in NetSuite for the account reconciliation purpose. They will provide the Statement API details to import the data from the bank. Solution To automatically import bank statement data into NetSuite for reconciliation… Continue reading How to automatically import Bank Statements to NetSuite using Statement API?
Tag: Bank Statement Import
Date Format Issue in Import
In bank statement imports, the date format should be MM/DD/YYYY. But even if the date format is correct, the error message will show. The error message is “The file could not be imported, because the date is not in the correct format”. To solve this problem, Insert an apostrophe (‘) before the date/s (e.g. ’01/31/2021)… Continue reading Date Format Issue in Import
CSV Import error ‘Unexpected Error’
When Importing the Bank Statements, the ‘Unexpected Error’ may receive. The possible reason for this one may be special characters in the Memo value. Remove the special characters from the statement file and reimport. To clean the memo field you can use the trim function. Ex: TRIM(CLEAN(F2))
‘Unexpected Error’ on Bank Statement CSV import
When importing the bank statements, user may encounter this error. One of the reasons for this one may be the line breaks on any of the CSV file columns. That is the header may be in two lines. For example, for the column Invoice Number(s), the header may be like InvoiceNumber(s). Change the format and… Continue reading ‘Unexpected Error’ on Bank Statement CSV import