Use Segments in the Header, or use them on the Transaction Line? How does this affect the GL Posting? Not sure whether to use the header or transaction line Class, Department, and Location segments? Making reporting requirements should help in making this decision. By reporting the P & L by location, adding this information to [...]Read More »

If you’ve been hanging around SuiteWorld, the annual NetSuite user conference, within the last five years then you’ve heard about the work NetSuite has been doing to improve the internal reporting offerings of the solution. It’s time to get excited because with 2018.2 we’re getting our first taste of this new functionality, called Workbooks. Before [...]Read More »

“Greg Cole, the Auditor is here!” said the CFO as I would walk through the silence of my newest client’s audit department. As I am sure you are aware, during my time as a financial statement auditor I was not always my client’s favorite person to see first thing in the morning. It’s understandable. Who [...]Read More »

In 2015, NetSuite introduced the concept of custom segments, which allowed users to post transactions to more than just the three standard segments that NetSuite offers of department, class, location. While this was a great achievement for the ERP, there was one big limitation that NetSuite did not offer at the time, which many users [...]Read More »

If there is one thing an accountant holds dearly to their heart, it is their chart of accounts. Believe me, I have been there. As a CPA, I know what it’s like to be able to rattle off the exact transaction that hit any 5-10 digit code that you can throw at me. However, what [...]Read More »

Every company strives to achieve healthy profit margins, but this can become a laborious task if they sell thousands or hundreds of thousands of different items. NetSuite offers a flexible and powerful mass update tool that can be used to set fields values on key records, in mass, as opposed to updating them one by [...]Read More »

The role of the Financial Controller in middle market companies has evolved leaps and bounds in the past decade. Years ago, the role of finance seemed to focus on meeting the heavy demands of our respective organizations as reporting resources. Today, this has evolved beyond reporting the financials to driving business results. We are able to [...]Read More »

While the Report by Period setting in conjunction with the Allow Transaction Date Outside of Posting Period setting can create some risks for inaccurate reporting as detailed in Part 1 of my post, this setting can also have an effect on what reporting options are available to you as well. As a refresher, the Report [...]Read More »

When running reports (not searches) in NetSuite, there are a few date-related settings that may determine what information you see in your reports. It’s important to understand the impact of these settings to ensure that you are not unknowingly running a report that is inaccurate. The first setting is the Allow Transaction Date Outside of [...]Read More »

As you may have noticed during your last login, NetSuite has announced their 2016.1 release dates. Firstly find the New Release portlet on your Home Dashboard. If you do not see this it’s possible that it may have been closed since NetSuite first added it for you (if you do not see this, please find [...]Read More »