Here's a handy tip for creating drop-shipped items: you can set your preferred vendor and purchase price on the item record itself! This sublist on the Purchasing/Inventory subtab of the item record will reference the vendor in which you are ordering the item from.

Tags: NetSuite, ERP, NetSuite Partner, NetSuite How To's, Accounting, NetSuite Tips, Financial, NetSuite Integrations, NetSuite Administrator, Netsuite Language, Netsuite ERP, Custom Fields, Netsuite Updates, NetSuite Features, NetSuite Support, PO Rate

With every new NetSuite implementation, there is a decision to make with what to do with historical data. Should you import just the month-end trial balances, or bring in all the individual transactions? Cleanest and most common choice is to bring in monthly trial balances. Though not impossible, it is a heavy lift to properly bring in the transactions into NetSuite.  

Tags: NetSuite, ERP, NetSuite Partner, NetSuite How To's, Accounting, NetSuite Tips, Financial, NetSuite Integrations, NetSuite Administrator, data, Netsuite Language, Netsuite ERP, Netsuite Updates, History Record, NetSuite Features, NetSuite Support

Have you ever come across a situation in your NetSuite where a complex subsidiary structure necessitates assigning certain users to specific subsidiaries while excluding others. Although seemingly straightforward, managing this can be a bit more intricate due to the limitation within the employee/user record, which only permits the selection of a Primary Subsidiary. This grants access solely to that subsidiary and any child subsidiaries linked to the chosen parent. If you need to grant access to multiple subsidiaries without a hierarchical relationship, the following steps will help you out!

Tags: NetSuite, ERP, Project Management, Reporting, NetSuite Partner, NetSuite How To's, Accounting, NetSuite Tips, Segmentation, Financial, NetSuite Integrations, NetSuite Administrator, Netsuite ERP, Subsidiary, Netsuite Updates, Changing Subsidiary, NetSuite Features, NetSuite Support

We understand that some companies have a segmentation setup that requires dependencies.  For example, you might want to select a department on a transaction, and based on the department chosen, a specific group of classes from a list to follow.  

Natively, making native dependencies between segmentations/classifications (Department, Class, Location) is not directly supported. However, to achieve this scenario, you may create Custom Segment(s) and make them dependent by following the steps below: 

Tags: NetSuite, ERP, Project Management, Reporting, NetSuite Partner, NetSuite How To's, Accounting, NetSuite Tips, Segmentation, Financial, NetSuite Integrations, NetSuite Administrator, Netsuite ERP, Netsuite Updates, NetSuite Features, NetSuite Support, Segmentation Dependencies

In continuation of the Advanced PDF Amount Due, let's take a look adding Amount Paid on your Invoice PDF as well. 

Tags: NetSuite, ERP, Project Management, Reporting, NetSuite Partner, NetSuite How To's, Accounting, NetSuite Tips, Financial, NetSuite Integrations, NetSuite Administrator, Transactions, Bill Payment, Netsuite ERP, Bill of Materials, Netsuite Updates, NetSuite Features, NetSuite Support, Amount Due

NetSuite standard invoice PDF configuration does not show the amount due when printing out an Invoice which can be a hinderance to a client that often has partially paid invoices. To resolve this, you will have to work in the Advanced PDF Source Code.

Tags: NetSuite, ERP, Project Management, Reporting, NetSuite Partner, NetSuite How To's, Accounting, NetSuite Tips, Financial, NetSuite Integrations, NetSuite Administrator, Transactions, Bill Payment, Netsuite ERP, Bill of Materials, Netsuite Updates, NetSuite Features, NetSuite Support, Amount Due

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

Is your Income Statement in need of a face lift?  If you are not able to over-haul your Chart of Accounts, you can update your Income Statement Layout directly in NetSuite.  I will walk you through some steps that will consolidate the GL accounts on your Income Statement.  From this walk through, you should have enough information for you to customize your own report.

Tags: NetSuite, NetSuite How To's, NetSuite Tips, Financial, Income Statement, Financial Report, Layout, Customization

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.  

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

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. 

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