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. UsingContinue 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: Voila! You then can type text in the FilterContinue 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 Types Table Field Meaning All Types transactionLine foreignamount Transaction amount in transaction currency All Types transactionAccountingLine amount Transaction amount in GL base currency Invoice transaction foreignAmountPaid Total paidContinue reading “NetSuite SuiteQL A/R and Customer Deposit Fields”

Reconcile NetSuite Auto-Elimination Amounts

Get clarity on hard-to-find NetSuite elimination entry sources to ease consolidation Consolidation and Elimination Entries NetSuite OneWorld offers some really powerful tools to make consolidated reporting simple. A key feature offered is the “Automate Elimination Entries” tool. The concept is straightforward: Intercompany transactions that occur during the period are “flagged” for eventual elimination, and atContinue reading “Reconcile NetSuite Auto-Elimination Amounts”