SCENARIO
User need to Filter the imported Bank data lines
SOLUTION
Imported bank lines can be sort on the Automatic Cash Application page.
Navigate to Transactions > Bank > Automatic Cash Application to filter imported bank lines.
Choose the proper bank or credit card account from the Account list.
A list of all bank lines for which NetSuite was unable to locate corresponding payments is shown by NetSuite.
Click the arrows to view the following or previous page of results if the number of bank lines in the list exceeds the page limit.
Data filtering
Click Show Excluded Only to convert from a list of all bank lines to a list of the bank lines not used to generate payments.
Reminder: Display Excluded only applies if the box for one or more bank lines is ticked.
Start typing the text or numeric value into the Search area to search for it on the page. NetSuite narrows the list of results as you type.
Choose a date format that corresponds to the format shown on the website when inputting a date (as set in the User Preferences). Enter May to look for a date in May, for instance, if you use the long date format (March 1, 2019). Enter the year with four numbers (for example, 2019). Always use two digits for the month or day when using a short date format (for instance, 03/01/2018).
Enter or pick the dates in the From and To columns to change the date range for the list’s bank lines.