Fund Classification Script on all Transactions

NetSuite also contains a custom script which automatically populates the fund type for each specific designation. Fund types are Unrestricted, Internally Restricted and Externally Restricted. When a new fund is created, it is set up with an associated Fund Class on the record, the script looks up the value on the Designation (or Program Area) record to populate the field automatically.

The fund script will fire automatically for transactions entered directly into NetSuite – as soon as Designation is selected for a line, the Fund field will immediately populate with the correct fund type. If you change the Designation, the fund type will update. The fund script is set to run every 2 hours on imported transactions (i.e. Concur / CSV imports)

Example

When “Social Venture Partners TO: Capacity Building” on the Invoice line below:

The script pulls the fund “Externally Restricted” from the Designation record: