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

Sara Duong, Consultant

Sara Duong, Consultant
Find me on:

Recent Posts

Excel Tip – Solver Add On

Posted by Sara Duong, Consultant on May 3, 2022 12:37:13 PM

You find yourself working with columns and columns of data for a client. In this particular scenario, you need to find a combination of transactions that total a certain amount. As you can imagine, this can be endless amounts of combinations to iterate through. There is a data trick using an Excel add-in called Solver. Here’s how it works...

Read More

Tags: NetSuite, NetSuite How To's, NetSuite Tips, data, Calculate Total, Excel

Troubleshoot Integration Concurrency Problems

Posted by Sara Duong, Consultant on May 2, 2022 1:31:45 PM

What is Integration Governance? Integration Governance helps manage the multiple 3rd party integration calls or internal script requests. It is very likely you may run into a concurrency issue if your NetSuite environment is heavily customized with scripts, have several API or EDI connections such as marketplace integrations (Amazon, eBay, HomeDepot, etc), and/or have 3PL connections. NetSuite limits the number of simultaneous calls into NetSuite at one time. When this happens, your call will fail and result in an error.

Read More

Tags: NetSuite, NetSuite How To's, NetSuite Tips, NetSuite Integrations, SuiteCloud, NetSuite Administrator, Concurrency, Performance, Connectors

What can you do if your Bank Reconciliation is not reconciling?

Posted by Sara Duong, Consultant on Mar 1, 2022 10:00:00 AM

If you find yourself reconciling monthly bank statements but the Reconciliation reports keep showing a difference, then it means you have not successfully reconciled one or more previous months.

Read More

Tags: NetSuite, NetSuite How To's, Bank Reconciliation, Bank Account, Bank Reconciliation Errors

Is it possible to redesign your Chart of Accounts after go live?

Posted by Sara Duong, Consultant on Feb 2, 2022 4:44:13 PM

In a previous blog we explored Netsuite Purchase Request vs. Purchase Requisition.  In this blog we’ll explore the complexity of chart of accounts redesign. We provide some tips and learnings from a previous chart of accounts redesign project.  

Read More

Tags: NetSuite, Accounting, Segmentation, Financial, COA, General Ledger, Chart of Accounts, GL

How to Bulk Send Transaction Emails using Mass Update

Posted by Sara Duong, Consultant on Dec 2, 2021 9:30:00 AM

Mass Update function is normally used for data updates to entity and transaction records. In addition, Mass Update can be used to send transactional emails in bulk. For instance, a simple way of sending customers overdue invoice reminders is to send it through Mass Update. You can set criteria of what invoices to send, create a standard message, and attach the invoice to the email. Here is a quick guide on how to do that.

Read More

Tags: NetSuite How To's, NetSuite Tips

Connect Your Google Accounts with NetSuite - CloudExtend Google Workspace

Posted by Sara Duong, Consultant on Nov 30, 2021 10:00:00 AM

As much as we try, companies still end up with multiple email accounts and data storage. There are several ways to connect or integrate all these sources so that NetSuite continues to be your system of record. One particular product is Celigo's CloudExtend Google Workspace. This is a simple SuiteApp that connects popular Google applications with NetSuite records.

Read More

Tags: NetSuite How To's, NetSuite Tips

Introduction to NetSuite's Team Selling Feature

Posted by Sara Duong, Consultant on Nov 16, 2021 12:00:00 PM

It's easy to track who brought in a sale if there is a one sales rep to one transaction relationship. NetSuite easily accommodates for that with the sales rep field on all quote, opportunity, and sales transactions records. For many companies, it takes a whole team to close a sales opportunity; the team can consist of any combination of the sales rep, accounting person, sales operations person, or even the sales manager. Wouldn't it be great to compensate and track each person's contribution to a sale? NetSuite has a team selling feature that will do just that.

Read More

Tags: NetSuite How To's, NetSuite Tips

How Do You Know if a NetSuite Customization is Needed?

Posted by Sara Duong, Consultant on Nov 9, 2021 8:00:00 AM
NetSuite is a very powerful and adaptable ERP platform.  There are some fundamental processes that NetSuite is built around, such as Order to Cash and Procure to Pay.  These fundamental processes make sure the transactions are validated, related, and traceable.  The adaptable part is the countless customizations you can make to the system to help mold and improve the system to your business needs.  As a rule of thumb and best practice, it’s best to maximize the native functionality.  If there is a need for customization, then here are some guidelines to help you decide if the customization is adding value or not.   
Read More

Tags: NetSuite How To's, NetSuite Tips

Accounting 101: Intercompany PO and SO

Posted by Sara Duong, Consultant on Sep 30, 2021 10:04:43 PM
How do you know if you need intercompany transactions: Intercompany Sales Orders and Purchase Orders? Typically if you have multiple subsidiaries that provide goods and services between subsidiaries, you will need intercompany transactions in NetSuite. Many companies use spreadsheets to track the amounts to remove from financial statements so that the revenue or expenses are not double counted when multiple subsidiaries’ financial statements are consolidated. NetSuite has native functionality to help record, manage and reconcile these types of intercompany transactions automatically.
Read More

Tags: Project Management, NetSuite How To's

Accounting: Debits and Credits 101

Posted by Sara Duong, Consultant on Sep 14, 2021 4:06:23 PM

As a NetSuite User, Administrator or Implementor, you don’t have to be a professional accountant. However, knowing some basic concepts helps you understand how your department or function impacts the company’s financials. With some basic accounting knowledge, you can validate if the item or transaction is configured correctly, meaning is it hitting your financial statements the way that it should. For the non accountants, there are 2 accounting concepts that are helpful: a basic accounting equation that always have to balance plus the use of debits and credits.

Read More

Tags: Project Management, NetSuite How To's

Content not found