How to match bank data in Netsuite using only specific word from the memo?
Hello dear community!
Almost all our transactions in NS fail to auto-match because the bank data's memo field contains the invoice number alongside other text. In the settings of the Reconciliation Rules there are only 2 operators available: Equals, Equals (ignore prefix), there is no "contains" operator. So a memo like "WIRE TRF REF# 111111 DRC-22222 INV-333333 BENEFICIARY..." cannot be matched to invoice DRC-22222 or INV-333333. Any suggestions how this can be resolved?
u/Substantial_Bet3252 — 8 days ago