As your NetSuite environments are being updated to release 2022.1, we thought we’d highlight some of the new features that may be worth exploring.
SuiteAnalytics Workbooks Dataset Linking now available in UI
This is the novelty that we are excited about. If you are familiar with NetSuite’s workbooks, you would understand how difficult it was in the past to take two disjointed datasets and link them together in a Pivot table. Although, in the previous releases, you were able to join two datasets via scripting, not many NetSuite customers attempted it as it was too complicated and required considerable SuiteScript competence. In addition to this, users were also not able to group datasets by two attributes.
For example, if we have MRP planned orders and we wish to connect them to our item demand plans, we can now do it with the help of this new feature. (See our screenshots below).
We can now turn these attributes into joins and proceed with Pivot building / grouping.
Supply Chain Control Tower Enhancements
For those of you who use Supply Chain Control Tower, you will be happy to know that NetSuite has introduced some Vendor Performance enhancements in 2022.1. Below are the steps you can perform to test this functionality.
Step 1. View and calculate vendor performance KPIs
Go to Lists > Supply Chain > Review Vendor Performances (Administrator).
On this page, you will select the Vendors for which you want NetSuite engine to calculate an assess risk of late purchase order receipt / late arrival of shipments.
Step 2. Review recommendations
Next, go to your ‘Control Tower Dashboard’ (Lists > Control Tower Dashboard).
You will see NetSuite’s alerts in the Predicted Risks portlet.
Click on the title that you wish to investigate further. On the next screen you will see all PO lines that may be late along with NetSuite recommendations.
In our example, the order is 16 days late. By switching the Vendor (i.e.: ACOM Business Solutions), we can expect earlier delivery (based on predicted days late / early setting on the ACOM vendor record).
To simulate the delivery on the Supply Chain Snapshot, we will click on [Add Recommendation to Snapshot] button.
When we view the Snapshot, we can see the ‘Simulation’ line that was created by NetSuite, and it’s clear that we will receive our product 16 days earlier based on our Vendor ACOM’s performance history.
Next, the purchasing manager will authorize the simulation, see the screenshot below.
When the recommendation is followed, it will disappear from the ‘Supply Chain Predicted Risks’ page.
Step 3. Add system notes to your dashboard
NetSuite included vendor performance data in its system notes. This means that you can now create a saved search reminder / alert from system notes and add it to your Dashboard.
See our example below.
Step 4. Review vendor delivery performance scores
The final enhancement can be observed directly on the Purchase Order. You will now see the [Get Predictions] button, each time you create a PO. The button should help you see the Vendor Score.
Note, when we were testing this functionality, we encountered the following message.
When we spoke to NetSuite about this error, they said that for each Vendor there needs to be a considerable number of (PO) transactions, before the AI component of this solution can be properly trained. As with everything new, this latest enhancement is still being perfected, so do expect to face some issues in the first couple of releases.
Invoice Presentation Template
The Invoice Presentation Template (IPT) SuiteApp provides project-based businesses with the ability to present data in multiple formats through invoice presentation templates.
Step 1. Installation
You can simply go to your ‘SuiteApps’ tab, look it up in the search and click on Install button when ready.
Step 2. Preference Setup
Next, go to Transactions > Sales > IPT Preference (Administrator). On this page, you can define the templates for each of your subsidiaries (that is if you operate in OneWorld environment).
Step 3. Create a presentation template
Go to Transactions > Sales > Invoice Presentation Templates > New (Administrator).
Note, on the layout you will map various project sections to your PDF layout, including the individual fields.
Step 4. Assign the template
Through assignments, you will be defaulting specific template(s) on your Invoice transactions. The assignment is done on the Customer and Invoice records. See the images below.
Once completed, the invoices will look like image examples below.
In conclusion, we enjoyed testing these new enhancements and we would love to discuss them with you. Should you have questions around how you can implement them in your environment, do not hesitate to contact us at [email protected]; we would love to talk to you!