If you want to show in your Saved Search results an aggregation of your results from a CASE statement then you will want to apply the Sum aggregation type in the Group section of your saved search field. Let’s illustrate this through the use of an example. For example, let us assume I want to find out the BALANCE of an Account on what has been charged for our customers and what remains pending in scheduled Sales Orders that have a future invoice date. ...

Saved searches are a powerful tool to fetch and display data in NetSuite. However, there may be times with the display of our saved search data where we want to transform the data into something else. To display data in a format based on a condition we need to use the Formula fields in the Result tab. Within the Formula field for us to apply a condition we can use either the following formulas: ...

When working with NetSuite’s Advanced PDF/HTML Templating system it’s difficult in being able to find documentation on the syntax structure for working with logic in the templates. One of the requirements I had was being able to determine whether the quantity ordered on an item has the same quantity ordered as the previous item. This required the ability to determine that the item being iterated through with the #list function was not the first item (otherwise it wouldn’t have been able to compare to the previous item – as there would be none!) and if the item was NOT the second to be able to compare the previous item’s quantity to its current quantity (if it’s then different to do stuff). ...

An important aspect within any business to effectively plan is the ability to monitor cash flow. Everybody in business knows “cash is king” and that “cash flow is the life blood of any business”. Without having cash you can’t do anything. Being able to monitor a weekly cash flow statement in Adaptive Planning is a little cumbersome, due to its standard monthly time-frame structure, however, creating a cash flow statement is not an impossible task. ...

Markdown is a popular way of writing content and converting it to HTML. Many popular web development sites use it including StackOverflow and GitHub. In fact these very pages that you see here on this sight have been created from source documents written in Markdown. However, one little problem I’ve recently bumped into is appending width and height parameters to the image tags so images can be sized responsively, which can easily be solved applying the following changes via CSS: ...

When working with formulas in your model sheets in Adaptive Planning you may come across an oblique error which doesn’t initially appear to make sense, but once you understand what it is, it becomes fairly obvious what it means (like most errors!). Problem So what is the error and how do you fix it? Have you been writing an if statement or two in your formula? The reason for the error is that it relates to an if function used in your formula. You need to make sure the structure of your if formula statements contain a truth-y capture, and a false-y capture. ...

When working with Adaptive Planning, especially for the first time as I have recently done, it is a little difficult understanding the time functions and what they return when they are used within time-series sheets (such as the Standard, Cube or Calculated Accounts in Modelled Sheets). If you’re looking for a brief understanding on what each of these functions return here’s a little sample on what they return. Assumptions about the structure of the data are as follows: ...

If you’re starting out with Handlebars and using it to create your HTML web pages, you may come across an oblique error message which may not make too much sense. One such error you may encounter returns the following response: throw new Exception(‘Must pass iterator to #each’) To solve this problem you need to locate within your Handlebars template code an {{#each}} call. For example, you may have something like this in your code where it is intended to loop through something and fetch the url and the link and output them as an anchor tag: ...

Recently, I had to merge two columns into only one column on a spreadsheet. The way I found to do this was by using the following common spreadsheet functions: JOIN, TRANSPOSE and SPLIT, and if needed UNIQUE. I was able to find a solution, and I’ll illustrate how it worked by using an example. Let’s assume the following columns of data: The first thing we will do is move to the next adjacent column, column C, and in cell C1 enter the following formula: ...

I’ve fallen in love with the new Lightbox / Fancybox alternative Colorbox. Unfortunately though I spent half a day in frustration trying to get a simple YouTube clip displayed in an iframe popup. The errors I received in the console were: E r r o r : c b o x E l e m e n t m i s s i n g s e t t i n g s o b j e c t Which produced Access-Control-Allow-Origin errors or http protocol errors and a whole myriad of other warnings – just from a simple YouTube iframe setup. ...