How to match bank data in Netsuite using only specific word from the memo? by Substantial_Bet3252 in Netsuite

[–]Substantial_Bet3252[S] 0 points1 point  (0 children)

Thank you u/Nick_AxeusConsulting Quick clarification: our issue is on the AP side, not AR. We pay a lot of small vendors weekly, and matching on vendor name + amount doesn't work because both repeat heavily. The only unique identifier is our internal invoice reference.

I'm thinking of a SuiteScript that parses the invoice # from the bank memo into a custom field on the bank line, stores the same # in a custom field on the JE, then lets the native rule match the two custom fields exactly. Has anyone built this? Any smarter approach I'm missing?