Save searches have emerged as a powerful tool to sift through high volumes of data and uncover relevant information. However, there are instances when you need to extract data for a specific subset of transactions, without the overload of excess information. In this article, we will explore ways to leverage unique identifiers, such as Transaction IDs or Internal IDs, to streamline your search and focus solely on data that matters to you most.
Tags: NetSuite, ERP, Project Management, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, Saved Search, Transactions, Transaction Lines, Implementation, Transaction IDs
With the new year beginning and accounting teams working busily to close the prior year financials one of the biggest errors we see is offsetting journal entries stuck on your A/P Aging report. If you are posting offsetting journals that post to your Accounts Payable transaction without first adding an “A/P Clearing Vendor” you might be asking how to clean up your reporting. Below we will walk you step by step on how to clear up your A/P Aging and remove these transactions entirely.
Tags: NetSuite, ERP, Reporting, NetSuite How To's, Accounting, Financial, General Ledger, GL, Accounting Periods, Transactions, Journal Entry, Transaction Lines, Financial Report, Accounts Payable, AP Aging
In NetSuite manually creating statistical journal entries is like manually creating general financial journals with the exception that you do not provide financial specific data. Instead, you areutilizing the unit of measures we previously set up to allocate fees such as monthly rent per department or shipping cost by items sold. When manually creating statistical journals, you are also given the opportunity to make an absolute balance for multiple statistical accounts at the same time.
Tags: NetSuite, ERP, Reporting, NetSuite How To's, Transactions, Journal Entry, Transaction Lines, Statistical Journals
Having trouble with the error: “Ambiguity error on logical key multi-match”? This article helps you to add multiple line items with the same item on a transaction via CSV Import or you would like to add new line items to existing transactions using CSV file uploads.
Tags: NetSuite, ERP, Reporting, NetSuite How To's, Transactions, Transaction Lines, Multi-Match, Sales Order, CSV Import
One of the most important Netsuite metric is your monthly transaction line use. Your transaction line use directly impacts yourNetsuite service tier because of how Netsuite’s service tiers scale with use. Simply put, the more transaction lines you use, the higher your service tier will be. For this reason, it’s critical to have a clear understanding of the distribution of transaction lines across the types of transactions you create. Understanding this data can help youidentify opportunities to reducetransaction use and can have a tangible impact on financial costs relating to your Netsuite service tier. In this blog we’ll look at what tools are available for monitoring transaction line usage and provide a use case for reducing usage if you have standard costing enabled.
Tags: NetSuite, Reporting, NetSuite How To's, NetSuite Tips, Netsuite Tier, Standard Cost, Inventory Costing, Inventory Cost Revaluation, Transaction Usage, Transaction Lines