Skip to main content

NetSuite Development

A New Day

A great deal has changed since I last published on this blog. I've transitioned from a career in graphics and animation to one that revolves around data analytics and NetSuite development. These days, I work in NetSuite daily, creating reports and developing workflows and scripts to streamline processes and support the operations team effectively.

Currently, my primary focus is on the Operations and CRM sides of NetSuite, where I handle a variety of tasks. At the same time, I'm committed to continuously expanding my knowledge and expertise in this platform. Moving forward, I plan to share insights into the challenges I’ve tackled, the ideas I’ve explored, and the solutions I’ve developed. My hope is that these shared experiences can benefit others navigating similar paths.

I’ve always enjoyed tinkering, and my latest fascination is with the incredible capabilities of AI. The image displayed here, for instance, was generated using AI, showcasing just a glimpse of its creative potential. As I continue to explore this technology, I find myself experimenting with various AI tools and techniques. Along the way, I may share some of the creations I come up with or the insights I gain as I delve deeper into this evolving field

Popular posts from this blog

Delta Cubes - The Dark Side of The Greendale

I'm a huge fan of Community ( @nbccommunity )  And I am also a huge fan of Pink Floyd.  So I decided to do a little mash-up after watching the last episode Season 04 Episode 07 - "Economics of Marine Biology"  And since I haven't posted in awhile, I thought I would Share.

Logo Design

I started working on some Freelancer.com Contests.  It's been good to push me to create some work within a somewhat restricted space.  Also helping me keep the creative juices flowing.  This is a design I did for Philippe Diamonds.  It was rejected.  I like it though, so I thought I would share. I have worked on a bunch of others, either they aren't done yet, or I don't fully endorse the design.

Turning Saved Search Logic Into Insight: A Lesson in NetSuite Date Math

  Sometimes it's the smallest slice of a project that demands the most ingenuity. What seemed like a simple enhancement to a Saved Search ended up stretching my understanding of NetSuite’s formula logic—and my patience. 🔍 The Objective I needed to compare two types of project actions occurring within a 30-day window. Here’s the twist: Project Actions are a custom child record of a NetSuite Project (Job) , and they’re not stored in a way that makes direct comparison easy. So, I had to retrieve them through a Project Search , pulling in individual Action records via joins—first hurdle cleared. 📅 Date Math, NetSuite Style Next came the math. I needed to calculate whether one action happened within 30 days of another, but NetSuite doesn’t make date arithmetic feel intuitive. My first instinct was to use TO_NUMBER() to convert the dates into values I could compute on. Spoiler: it didn’t work. So I tried a workaround—subtracting a fixed reference date ( TO_DATE('01/01/2000...