Tag: currency

When a Specific Bank Account is Selected, User is Unable to Select Other Currency From the Dropdown

Standard behavior on the Currency field in Write Checks page. In NetSuite, a Bank Account is associated and maintained in only one currency. In writing checks, if the currency of subsidiary is different from the currency of the bank account, the Currency available is the bank account’s currency. On the other hand, if the currency… Continue reading When a Specific Bank Account is Selected, User is Unable to Select Other Currency From the Dropdown

Saved Search to Expose all Currencies Associated with a Vendor

If users want to expose the Other Currencies assigned to the Vendor, then Vendor Currency Balance Fields: Currency should be used. Navigate to Lists > Search > Saved Searches > New Click Vendor Click Results Click Columns Click Remove All Field:  Note: Always click Add once Field is selected and adjusted as needed Select Name Select Vendor Currency Balance Fields… Vendor Currency Balance Fields: Select Currency… Continue reading Saved Search to Expose all Currencies Associated with a Vendor

Change Currency After Transaction Has Been Saved

Per standard Netsuite functionality, it is not allowed to change the currency setup once a transaction has been saved. Below is an alternative solution to this. If the currency is incorrect, we can make a copy of the transaction and change the currency on the copy instead. To do this, open the invoice record and… Continue reading Change Currency After Transaction Has Been Saved

Format numbers to currency strings

Description Create format.CurrencyFormatter object to format numbers into currency strings. Returns –> Object Supported Script Types –> Client and server scripts Governance –> 10 units Module –> N/format/i18n Module Parameters options.currency (required/optional) Code of the currency that is used by formatter. options.locale (required/optional) Code of the locale that is used by formatter. Warning : These parameters are… Continue reading Format numbers to currency strings

Why the entity name is not available under Name Column When Entering a Journal Entry Line

Scenario When creating a Journal Entry, user can specify on the Name field the supplier or Customer at the line level. In some instance, a particular entity may not be listed or found from the Name drop-down menu.  Example: 1. Navigate to Transactions > Financial > Make Journal Entries 2. Subsidiary: Select Company A 3. Notice that Currency field is automatically set to USD (the primary currency) 4. Under Lines tab, add a row with these… Continue reading Why the entity name is not available under Name Column When Entering a Journal Entry Line

Convert Numerical Sum From Integer to Currency in Advanced PDF/HTML Template

Advanced PDF/HTML templates allows simple computations through the use of the Freemarker language. For instances where values needs to be compared or displayed on a certain format, the Freemarker language has a built in function that converts the type casting of variables. Solution Navigate to Customization > Forms > Advanced PDF/HTML Templates Preferred Advanced PDF/HTML Template: Click Edit Create a variable to… Continue reading Convert Numerical Sum From Integer to Currency in Advanced PDF/HTML Template