Advanced Topics

NetSuite Payment Terms

4min
in netsuite, the payment terms are a dedicated object so, while to the user, they appear to be a text based picklist, in the background, it is instead a dedicated object that presents as a picklist breadwinner needs the netsuite id when creating an invoice using either our guided wizard or global api this means that you will need to find the terms object in netsuite in order to obtain the underlying terms id obtaining the terms id from netsuite to access this object in netsuite, go to "setup > accounting > account lists", click on accounting lists, and then filters, type = term the internal id is the column in the green box this is the number that breadwinner needs passing the id using breadwinner this id must be passed to breadwinner using the custom guided wizard or the global api if using the custom guided wizard, you can see the invoice documentation with terms here it might appear in your custom url like this storing this netsuite internal id in salesforce your users will typically want to see a picklist on the salesforce account (or opp or order, etc) where they can select the terms, which might look like "net 30" in the picklist this text needs to be converted to the netsuite internal id before being passed to breadwinner one easy way to do that is to create a text formula field on the originating object, using the case() formula this formula field might look something like case( account paymentterm c, 'net 15', '1', 'net 30', '2', 'net 45', '3', 'net 60', '4', 'net 90', '5', 'due on receipt', '6', null )