Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
NSC | How to Prevent Auto-Matching of Imported Bank Data to Older NetSuite Transactions
Scenario:
If imported bank data is being auto-matched to older NetSuite transactions (e.g., April transactions instead of May), it's likely due to the bank data being imported before the corresponding NetSuite transaction was posted.
Solution:
To prevent this, you can create a Reconciliation Rule that limits matching to transactions within a specific date range.
- Open Reconciliation Rules page.
• NetSuite: Go to Transactions > Bank > Reconciliation Rules.
• NetSuite Next: Open Explore (hamburger icon on the bottom left corner beside the Home button). In the menu, go to Transactions > Bank > Reconciliation Rules. - Create a New Rule/Rule Name:
- Enter a descriptive Rule Name
Tagged:
1