Skip to main content

3 Adaptive features retiring in NetSuite and 1 solution

This summer 2024, Workday annouced that it will be retiring 3 features within / related to NetSuite. 

Workday's article said:  (requires community access account)

"Oracle has terminated Workday's participation in the SuiteCloud Developer Network (SDN) Partner Program, effective August 12, 2024"

"3 functionalities enabled by SDN Technology that we (=Workday) won't be able to support: (...)"


What does it mean? 

Oracle is basically removing Workday from their partner program to implement bundles and features within NetSuite. Some Adaptive features co-developed in NetSuite will remain but will no longer be supported.

But rest assured!

The basic "out of the box", most commonly used integration of NetSuite in Adaptive will remain!

If you are using this basic integration, with the native tables (transactions, balances, suppliers, assets etc.) or a custom cloud connection to NetSuite Reports... The good news is that this is staying!


So what are the no longer supported features?

  • 1) Financial Planning Tab in NetSuite toolbar (to allow a connection to Adaptive from within NetSuite and some meta data integration. I've personally never used it and never witnessed any customer using it either...)


  • 2) Drill through to NetSuite > right-click from your Income Statement of Balance Sheet in Adaptive


  • 3) Automated scheduling and running of Saved Searches to the File Cabinet
I am going to explain this 3rd feature in particular and provide you with alternate setup ideas!
This was a bundle (ID: 350286) that you could install in NetSuite and was doing the following:
- Triggering a Saved Search 
- Saving it as a CSV file into the File Cabinet (File Cabinet is basically a storage space for files in NetSuite).

And then in Adaptive (within your NetSuite Integration), you have a File Cabinet integration setup that would fetch this data; this piece of integration is NOT RETIRING. What is retiring (or will no longer be supported) is the bundle that was triggering a Saved Search and saving it as a CSV file in the File Cabinet within NetSuite. 

Luckily there is a workaround! This can be replaced with a Suitelet: a JavaScript that runs in NetSuite to perform various actions.


What are the possible alternatives to replace that bundle?

The bundle was triggering a saved search and putting it into the File Cabinet (then Adaptive fetches it via its integration).
 
Files can be deposited in the File Cabinet in 3 ways:

🙁You manually run the reports in NetSuite, save them as .CSV and put them in the File Cabinet.

🥹 You are using this Adaptive for NetSuite bundle and unfortunately this will no longer be supported.

😄You can automate & schedule the run, save and put your files in the File Cabinet via a deployed Suitelet. 

There are other alternatives but they are way more code heavy and require a more complex setup (and sometimes other tools)... which typically are not really worth the effort!


As you can see... The quickest way is to develop that script that will performs these actions. 
The script can then be manually triggered or scheduled in NS.

There are 2 limitations with this method:
  • The script has a 1 hour run threshold. If you run a complex saved search (either large dataset or a lot of calculations/ logic, customization or filtering), the script will time out and fail after 60 minutes. The saved search itself may not take an hour to run... but to run it, parse it and save it into a CSV file can be time consuming. So keep you search simple... don't add columns you don't use (for example account number and account name... just the account number!)
  • The file can't be more than 10 Mb! It's a known challenge (see here). However you can easily tweak your script and break the data into several files. You would then fetch these files in Adaptive and make a Union table to aggregate them all into 1 table).



Labels:

Comments

Post a Comment

Popular posts from this blog

Adaptive's API

To integrate data in Workday Adaptive Planning, customers typically use the integration module to connect with ERPs, SFTPs, AWS S3, Snowflake, SalesForce, Excel, and Google Sheets, etc.  You can also use third party platforms such as Tray.ai , Boomi , Matilion etc. which leverage Adaptive's APIs in a user friendly setup.  And lastly, you can write your very own scripts (C#, Python, Powershell...) to make these API calls.  Most  common Adaptive's API use cases Import Data from ERPs Actual summaries and transaction details (by supplier, employee...) Assets, amortization, depreciation Payroll details and taxes Import Sales data from CRMs or datalakes Pipeline, churn, opportunities and customers  Billings, bookings, revenue, ARR Import Headcount data from an HRIS Current headcount and terminations Hired, not started Wages and compensation plans Benefits and other demographics Import Other data: Exchange Rates Weather Meta data: currencies, attributes, dimensions suc...
Post a Comment
Read more

What are Metric accounts and when to use them?

 I am often asked: "What are Metric accounts in Adaptive and what is their use case?" Before we jump into the weeds, you can create "global" metric accounts, called standard metric accounts  and within cube sheets.  To create a standard metric account, go to:  Menu > Modeling > Metric Accounts Adaptive will come with a couple of pre-built Metric accounts, such as Gross Margin % What are Metric Accounts? A metric account in Adaptive is a calculated account , meaning it carries a formula .  It does   not carry any data entry .  It can not be a rollup account,  meaning it can not have any "children accounts" rolling up to a parent. Metric accounts are typically used to calculate ratios , this is why they can only be either a number or a percent ! But... there is more subtility in them! Metric accounts are different from the other calculated accounts (custom, modeled, cube etc.) in the sense that their formula is also computed at the level an...
Post a Comment
Read more

One (perfect) Headcount Planning Process in Workday Adaptive for FP&A

FP&A: The Perfect Headcount Planning Process in Workday Adaptive for non Platform customers: Streamlining integration, reconciliation and budgeting This article is for companies that are not on the Workday Platform  (HCM, FINS, Adaptive) and are missing out on the integrated cycle of hiring, planning, reconciliation, and system-wide alignment that Workday offers. I sometimes hear complaints (luckily not too much) about Workday HCM, Adaptive or FINS... but the truth is, no other tool on the market currently offers a complete solution that spans the entire hiring process—from budgeting and requesting to hiring, reconciling, and publishing plans across systems. Workday is the only one with this capability right now!  I’m not paid by Workday to write this… But after working with several HRIS, ATS, and ERP systems, I can confidently say that Workday stands out for its customizable workflows, overall ease of use, and seamless communication across all three systems -- assuming yo...
Post a Comment
Read more