You might have received a notice last month regarding the news that JP Morgan Chase (JPMC) is moving away from Screen Scraping technology and will no longer support connections to their credential-based sites. Per notification, this change is part of JPMC’s transition to Open Banking technology which aims to improve security and ensure smooth bank feeds connection. If you are using the NetSuite Bank Feeds SuiteApp which may be importing data from the JP Morgan Chase & Co. (JPMC) financial institution, you might have encountered the bank data import errors on or after April 21, 2022.
Tags: NetSuite, Reporting, NetSuite How To's, Accounting, NetSuite Tips, Financial, Bank Reconciliation, Bank Account, data, Excel, Bank Statements
You find yourself working with columns and columns of data for a client. In this particular scenario, you need to find a combination of transactions that total a certain amount. As you can imagine, this can be endless amounts of combinations to iterate through. There is a data trick using an Excel add-in called Solver. Here’s how it works...
Tags: NetSuite, NetSuite How To's, NetSuite Tips, data, Calculate Total, Excel