Posts by Patrick Quirke
How do Pigment Data Slices Work and When do I use them?
Pigment Data Slices Data Slices are the key to streamlining reporting within Pigment. With many implementations utilizing Scenarios, Versions, and Snapshots, data slices allow you to create clear comparisons. This article will explain what Data Slices are and how to use them. What are Data Slices? Data Slices use a dimension to map two or…
Read MoreHow Can I Automate Email Notifications in NetSuite with Saved Searches
Why Saved Searches for Email Automation? Saved searches are more than just reporting tools. When combined with scheduled email delivery, they become automated communication engines that push critical information directly into your team’s inboxes. Instead of relying on employees to pull reports, NetSuite can push the right data to the right people at the right…
Read MoreHow can I reduce scripts in NetSuite?
Chaining Map/Reduce Scripts in NetSuite Introduction When working with large processes in NetSuite, it’s common to split logic across multiple Map/Reduce scripts that need to run in sequence. Since execution times can vary based on data volume and queue availability, using scheduled deployments alone is unreliable. If one script starts before another finishes, it can…
Read MoreHow to Master Allocations in Netsuite
Expense allocations in NetSuite offer a powerful way to automatically distribute expenses across departments, locations, or other organizational segments. This functionality helps streamline financial processes, improve reporting accuracy, and support compliance with internal accounting policies. What is Expense Allocation? Expense allocation is the process of dividing a single expense among multiple accounts or segments based…
Read MoreHow do you Update Script Deployments in NetSuite
Are you looking to enhance or update the functionality of your scripts in NetSuite? Understanding how to properly manage script deployments is key to keeping your system aligned with evolving business needs. The NetSuite Script Deployment tool provides a flexible framework for customizing how and when your scripts run. In this guide, we’ll walk through…
Read MorePlanning Analytics SaaS: Migration and Operational Changes FAQ (Part 2)
What should you expect during migration, and how will operations differ once you are on Planning Analytics SaaS? This FAQ is written to stand on its own for readers who mainly need to understand what changes operationally when an on-premises Planning Analytics environment is moved to IBM Planning Analytics SaaS. It assumes the reader is…
Read MorePlanning Analytics SaaS: Readiness and Planning FAQ (Part 1)
Is your organization ready to move from on-premises Planning Analytics to a SaaS model? This FAQ is intended for existing Planning Analytics customers that are considering a move from on-premises deployments to IBM Planning Analytics SaaS on Azure or AWS. It focuses on the early-stage questions: why customers are interested in SaaS, what benefits are…
Read MoreWhat Are Post Vendor Bill Variances and How Do They Work?
Mismatches between what you ordered and what you were billed, whether in price, quantity, or exchange rate, often leave messy balances in your Accrued Purchases account. If you have Advanced Receiving enabled in NetSuite, you can easily clean up these discrepancies. This process generates journal entries that move variances to the correct accounts, ensuring your financial reporting remains accurate…
Read MoreWhat is the Standard Deviation Calculation in Pigment?
Standard Deviation Calculation in Pigment Using the REMOVE Modifier with STDEVS and STDEVP Overview Pigment supports standard deviation calculations directly within metric formulas using the REMOVE modifier. By specifying either the STDEVS or STDEVP aggregator, you can calculate the standard deviation of values across one or more dimensions — without needing a separate calculation…
Read MoreHow do I Instal, Upgrade & Uninstall when using Netsuite SuiteApp?
NetSuite SuiteApp: Install, Upgrade & Uninstall Introduction NetSuite and NetSuite Tools handle many of the use cases and requirements of end users innately, but there are surely edge cases that need to be addressed separately. Custom solutions can be crafted but, making sure a solution is not already available is a necessary step in the process.…
Read More