Tag Archives: NetSuite

NetSuite Currency Revaluation Enhancer

View the detail related to native NetSuite currency revaluations for non-A/R and non-A/P accounts Photo by Pixabay on Pexels.com Introduction The native functionality of NetSuite lacks the capability to offer a detailed analysis of currency revaluations affecting financial accounts beyond Accounts Receivable and Accounts Payable. This article and video below describe how we bridge thisContinueContinue reading “NetSuite Currency Revaluation Enhancer”

Quick Tip: NetSuite “Overwrite Sublists” for Journal Entry CSV Imports

Hat tip to my colleague Boban for this one! CSV transaction imports in NetSuite offer an option to “overwrite sublists” when you are updating transactions. This is a useful way to avoid trying to target specific transaction lines to be updated. See SuiteAnswers article 31848 for more details on how to use this feature. UsingContinueContinue reading “Quick Tip: NetSuite “Overwrite Sublists” for Journal Entry CSV Imports”

Saved Search Text Filtering

Do you want a filter on Saved Search results to use Keyword typing instead of a Drop Down? Often, drop-down filters are hard to use in Saved Searches, especially if the list is long. Here are 2 ways to change the filter to support text typing: If the filter is a “joinable” record (e.g. theContinueContinue reading “Saved Search Text Filtering”

NetSuite SuiteQL A/R and Customer Deposit Fields

Ever get confused about which fields do what when creating A/R – oriented SuiteQL reports? Here’s a table that help organize the fields and their meanings: Transaction TypesTableFieldMeaningAll TypestransactionLineforeignamountTransaction amount in transaction currencyAll TypestransactionAccountingLineamountTransaction amount in GL base currencyInvoicetransactionforeignAmountPaidTotal paid amount, in the transaction currencyInvoicetransactionforeignAmountUnpaidTotal unpaid (open) amount, in the transaction currencyCustomer Deposit, Payment, CreditContinueContinue reading “NetSuite SuiteQL A/R and Customer Deposit Fields”