Discussions
Here are some examples to get your creative juices flowing.
"Did I pay vendor John Doe last month?"
"Take me to my largest sales order for this month."
"What invoices haven't been paid yet?"
Adding ISO Country Code to Electronic Bank Payments Payment File Template
Based on this community question, How to obtain by freemarker the ISO country code? — Oracle NetSuite Support Community, we are informed that the ability to pull up ISO Country codes instead of Country names is currently a system limitation in NetSuite.
However, some SEPA files require the ISO country code.
My solve for this is to add and make mandatory the "Country Code" freeform text field (custrecord_2663_entity_country_code) from the Bank Details record in the Payment file template in the "Entity Reference fields" section:
<refField id='custrecord_2663_entity_country_code' label='Country Code' mandatory='true' helptext="This field displays the international code assigned to the country where the bank is based."/>
Leaderboard
Community Whiz
Quarter 1 (Jan-Mar 2025)
1
Chelsea Jacobs
8 Points
2
Divya Unnikrishnan
7 Points
3
Diniya A J
7 Points
4
Hormese Paul
7 Points
5
Mel H
6 Points
6
Vernita
5 Points
7
Manu Antony Vadassery
5 Points
8
Honey Soe
5 Points
9
Angela Bayliss
4 Points
10
Alexis Atrizco
4 Points
11
Vairamuthu M
4 Points
12
Able Wilson
2 Points
13
Jordon F
1 Point
14
Veda chalam Mahadevan
1 Point
15
OliverOO
1 Point
16
Vishnu M
1 Point
17
User_2LD8N
1 Point
18
Amanda Edwards
1 Point