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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
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.
- Go to Transactions > Bank > Reconciliation Rule.
- Create a Rule Name:
- Enter a descriptive Rule Name (e.g., “Limit Matching to Recent Transactions”).
- Go to the Accounts tab. Check the box next to the bank account(s) the rule should apply to.
- Go to the Conditions
Tagged:
1