<img src="https://ws.zoominfo.com/pixel/5BFMW73xT6Cu70sN1cUt" width="1" height="1" style="display: none;">

Landed Cost Per Line On A Transaction

Posted by Kevin Suh, NetSuite Administrator on Nov 14, 2023 11:00:00 AM

Are you currently making the most of the Landed Costs feature and keen to specify Landed Cost Allocation amounts on a per-line basis in your transactions and receipts? Say goodbye to the hassle of distributing costs based on allocation methods at a transaction level. Landed costs can often form a significant chunk of the total expenses associated with your products. With the Landed Cost Allocation per Line feature, you can gain a more detailed insight into the location-specific expenses linked to your purchases from global suppliers and vendors.

Read More

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, NetSuite Administrator, Transactions, Transaction Lines, Netsuite ERP, Netsuite Updates, Landed Cost

Saved Search Tip: How to Filter Out a List of Specific Transactions

Posted by Sara Duong, Consultant on May 30, 2023 12:44:17 PM

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.

Read More

Tags: NetSuite, ERP, Project Management, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, Saved Search, Transactions, Transaction Lines, Implementation, Transaction IDs

Interchange Items and Expenses Tab on Vendor Bills & Purchase Orders

Posted by Mariella Marquez, Consultant on May 11, 2023 11:17:17 AM

One of the most common edits requested by customers during a new NetSuite implementation is to customize the sublist display for several transaction records, namely the Items and Expenses subtabs on Vendor Bills and Purchase Orders.

Read More

Tags: NetSuite, ERP, Project Management, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, Purchase Order, Transactions, Vendor, Customization, Vendor Bill, Transaction Forms

Removing Journal Entries in A/P Aging Detail Report

Posted by Mariella Marquez, Consultant on Jan 26, 2023 12:14:27 PM

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. 

Read More

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

Manually Creating Statistical Journals

Posted by Mariella Marquez, Consultant on Jan 24, 2023 4:47:14 PM

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.

Read More

Tags: NetSuite, ERP, Reporting, NetSuite How To's, Transactions, Journal Entry, Transaction Lines, Statistical Journals

Add/ Remove Multiple Line Items on a Transaction via CSV Import

Posted by Kevin Suh, NetSuite Administrator on Jan 5, 2023 10:49:46 AM

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.

Read More

Tags: NetSuite, ERP, Reporting, NetSuite How To's, Transactions, Transaction Lines, Multi-Match, Sales Order, CSV Import

Date/Period Mismatch – Life-to-Date

Posted by Justin Myung, Consultant on Oct 6, 2022 9:45:05 AM

There are many reasons why a company may want to have dates and periods not match-up.  One common reason may be related to the month-end close processA company may want to enter the actual date (which is in a prior period) of a vendor bill, but since the previous period has already been closed, they will post to the current period for financial purposes.  NetSuite can allowtransaction dates outside of the posting periods through the company’s Accounting Preferences.  This can increase the risk of unwanted date/period mismatches as well as cause headaches for reconciliations between AR/AP Aging reports to the Balance Sheet.  One way to monitor this is through a Saved Search. 

Read More

Tags: NetSuite, Reporting, NetSuite How To's, Accounting, NetSuite Tips, Accounting Periods, Saved Search, Transactions, Date Mismatch

How to Set Up Vendor Prepayments

Posted by Sara Duong, Consultant on Sep 13, 2022 9:21:44 AM

What are Vendor Prepayments? When Vendor requests a deposit or payment before a Purchase Order is approved or before a Vendor Bill is issued, you can record this payment as a Vendor Prepayment in NetSuite.  

Read More

Tags: NetSuite, NetSuite How To's, Accounting, NetSuite Tips, Financial, Transactions, Vendor, Vendor Payments, Bills, Bill Payment

Get an Undeposited Funds as of Date Report

Posted by Justin Myung, Consultant on Sep 6, 2022 10:59:29 AM

Have you ever wondered if there was an easier way to get a detail report of Undeposited Funds for a previous Date?  If you have a lot of transactions that flow in and out of this account, it can be a daunting task if you don’t reconcile this right after month-end close or even if there happened to be back-dated transactions after you month-end bank reconciliation.   The following search will help you download a saved search report to solve that issue. 

Read More

Tags: NetSuite, Reporting, NetSuite How To's, Accounting, NetSuite Tips, Financial, Bank Reconciliation, Bank Account, Saved Search, Transactions, Undeposited Funds

Best Practice for Reclassing General Ledger Account Segmentation

Posted by Sara Duong, Consultant on Sep 1, 2022 12:13:44 PM

What is Segmentation in Netsuite? Segmentation or classification are ways to categorize entity (Vendor, Customer, Item) records and transactions amounts in NetSuite.  For instance, you may want to see your Income Statement separated out by Location; Location will be a classification field on your transactions.  There is native reporting function that will automatically break up your Financial Statements in segmentations.  

Read More

Tags: NetSuite, Reporting, NetSuite How To's, Accounting, NetSuite Tips, Segmentation, Financial, Transactions, Classification, Income Statement, Journal Entry, Trial Balances, Reclass

Subscribe to our blog!

Recent Posts

Posts by Topic

see all