Meir Bulman

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 Inventory Received Not Billed / Accrued Purchases Analysis

Use advanced Saved Search techniques to interpret balances in hard-to-understand General Ledger Accounts

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”

Create Impactful Customer Statements in NetSuite by Leveraging the power of SuiteQL

Learn the background of how Accounts Receivable balances are brought together using SuiteQL

Intercompany Account Balance Troubleshooting

Techniques for getting NetSuite to correctly auto-eliminate intercompany balances

NetSuite Fixed Asset Reconciler Bundle

Announcing a Fixed Asset supplementary bundle that can diagnose and help resolve discrepancies

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”

NetSuite Currency Translation II

Learn how to gain control over Consolidated Foreign Currency Subsidiary Consolidation in NetSuite

Finally! Trace Fixed Asset Depreciation Journal Entries Back to Underlying Assets

Get visibility of the Assets that make up FAM-generated Depreciation Journal Entries using SuiteQL reporting

Amazon Pay Fees and Transfers in NetSuite

Learn how to easily book adjustments and get the accounting right for online payment providers Amazon Pay transactions Amazon Pay is a popular payment capture service (a.k.a “payment gateway”) that collects funds from customers, deducts fees, and transfers a net balance to businesses that use its service. Booking the fees and transfers seamlessly is aContinue reading “Amazon Pay Fees and Transfers in NetSuite”