Have you ever wanted or needed a quick comparative view of your Intercompany transactions between your subsidiaries? One way to achieve this is through the use of CASE Statements in Saved Searches. What is a CASE Statement? A CASE Statement is similar to that of an if-then-else statement. You may have encountered this in spreadsheets. In NetSuite, it’s an available function that allows you to program conditions to return values when those conditions are met. So, when a condition is true, NetSuite will provide the results based on those conditions. You can have multiple conditions in one CASE Statement.
Read More
Tags:
NetSuite,
Reporting,
NetSuite How To's,
NetSuite Tips,
Saved Search,
Reconciliation,
CASE,
Formula,
If-Then
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 process. A 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
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
Have you ever noticed that your Balanced Sheet and Income Statement have different month end balances?
Read More
Tags:
NetSuite,
Accounting,
Accounting Periods,
Saved Search,
Transactions,
Date Mismatch
