Dsg value maximizer webinar series
This presentation is the property of its rightful owner.
Sponsored Links
1 / 79

DSG Value Maximizer Webinar Series PowerPoint PPT Presentation


  • 135 Views
  • Uploaded on
  • Presentation posted in: General

DSG Value Maximizer Webinar Series. NetSuite Release 2014.1 February 26, 2014. Value Maximizer. Minimize the “Value Gap” Offerings to help Partnerships – Concur, Adaptive Planning, Box.net, Avalara, B2B Gateway, Dell Boomi

Download Presentation

DSG Value Maximizer Webinar Series

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Dsg value maximizer webinar series

DSG Value Maximizer Webinar Series

NetSuite Release 2014.1February 26, 2014


Value maximizer

Value Maximizer

  • Minimize the “Value Gap”

  • Offerings to help

    • Partnerships – Concur, Adaptive Planning, Box.net, Avalara, B2B Gateway, Dell Boomi

    • Solutions – DSG Powered (CRM Collaborator, Installed Base, Resource Plan & Monitor, Google Locator)

    • Offerings – Realize, Optimize, Revitalize

  • Continuing customer education, awareness and knowledge

    • Value Maximizer Webinar Series

  • Future subjects

    • Release reviews

Value

Maximizer

Webinar

Series

Value Maximizer Webinar 2014.1


Netsuite 2014 1

NetSuite 2014.1

Agenda - Discussion with screen shots

  • Trial Balance & Balance Sheet Enhancements

  • Multi-Book Accounting

  • Statistical Accounts

  • Batch Processing for Rev Rec Journal Entries

  • Enhanced Deferred Rev Rec Reports

  • Collapse/Expand VSOE Column on Sales Transactions

  • Purchase Requisitions

  • File Drag & Drop BETA

  • StickyNotes BETA

  • Maximum Report size changes

  • Expense Account sign changes in Saved Searches

Value Maximizer Webinar 2014.1


Trial balance balance sheet enhancements

Trial Balance & Balance Sheet Enhancements

NetSuite Release 2014.1February 26, 2014


Trial balance now has alternate period ranges

Trial Balance now has Alternate Period Ranges

Value Maximizer Webinar 2014.1


New settings for cumulative value

New Settings for Cumulative Value

Value Maximizer Webinar 2014.1


Amounts in debit and credit

Amounts in Debit and Credit

Value Maximizer Webinar 2014.1


Report results

Report Results

Value Maximizer Webinar 2014.1


Multi book accounting

Multi-Book Accounting

NetSuite Release 2014.1February 26, 2014


Purpose of multi book accounting

Purpose of Multi-Book Accounting

  • Purpose for Multi-Book Accounting

    • Deliver different financial reports to serve different purposes

    • Provide detailed transaction-based reports for each accounting book

    • Automate posting to multiple accounting books according to pre-defined accounting rules

Value Maximizer Webinar 2014.1


Features of multi book accounting

Features of Multi-Book Accounting

  • Adjust financial results on a per-book basis

  • Ensure data integrity across multiple accounting books

  • Enable customization to leverage the Multi-Book Accounting context

Value Maximizer Webinar 2014.1


2014 1 release

2014.1 Release

  • To be released in Phases

    • Phase 1 Features under Enable Features

      • Up to 5 Active Books (including Primary book)

Value Maximizer Webinar 2014.1


Mapping to books

Mapping to Books

  • COA will be mapped using a mapping table

    • Primary book always covers all subs, other books can be a subset of subsidiaries

    • Table will use mapping rules

    • Table can be manually setup or imported using csv import

Value Maximizer Webinar 2014.1


Transactions

Transactions

  • On the Accounting tab of a transaction an additional attribute will be added to select the accounting Book

Value Maximizer Webinar 2014.1


Using multi books overview

Using Multi-Books Overview

  • Dashboards will have a Level Book Selector

  • Set Preferences will have a KPI setting for preferred Book

  • Report will have an additional filter for Book

Value Maximizer Webinar 2014.1


Functional overview

Functional Overview

Similar to Inter-Company transactions, it will handle Intra-Subsidiary per book Transactions

Value Maximizer Webinar 2014.1


Items included in multi book function

Items Included in Multi-Book Function

  • Revenue Recognition by book will be supported

  • Expense Amortizations by Book

  • COGS and Inventory Valuation

  • Fixed Asset Depreciation by Book (2014.2)

Value Maximizer Webinar 2014.1


Backward compatible

Backward Compatible

  • Whatever works today, will also work with Multi-Book

Value Maximizer Webinar 2014.1


Statistical accounts

Statistical Accounts

NetSuite Release 2014.1February 26, 2014


Purpose of statistical accounts

Purpose of Statistical Accounts

  • Statistical Accounting feature allows Financial users and Corporate management to enter non-monetary data in order to run cost and revenue Allocations dynamically and enhance Financial Statements with Financial Ratios

  • Supports costing methods as activity based costing, profit and cost centers to better track company performance

Value Maximizer Webinar 2014.1


Enhancement

Enhancement

  • New Capabilities

    • Uses Units of Measure (formerly part of Advanced Inventory)

    • Dynamic Allocations (Usage Base Allocation)

    • Financial Statements with Ratios

    • Allocation Batch

Value Maximizer Webinar 2014.1


Methods to use statistical accounts

Methods to Use Statistical Accounts

  • Creating Statistical Account balances

    • Manual JE

    • JE from a Saved Search : Example headcount from employee list

Value Maximizer Webinar 2014.1


Adding amounts manually

Adding amounts manually

NetSuite Release 2014.1February 26, 2014


Statistical account setup

Statistical Account Setup

Value Maximizer Webinar 2014.1


New menu items

New Menu items

New Menu options under Transactions >> Financial

Value Maximizer Webinar 2014.1


Setting up values in statistical accounts

Setting up Values in Statistical Accounts

Acct 9010

Amount is the Sq. Ft Value by Department

Value Maximizer Webinar 2014.1


Allocation schedules

Allocation Schedules

Lists >> Accounting >> Allocation Schedule

Associate the Acct 9010 pulls in the allocation Weight from the Stored Value

Value Maximizer Webinar 2014.1


Adding amounts dynamically

Adding amounts dynamically

NetSuite Release 2014.1February 26, 2014


Dynamic allocations using the stat accts

Dynamic Allocations using the Stat Accts

Setup another Statistical Account for Headcount

Value Maximizer Webinar 2014.1


Saved search to calculate variables

Saved Search to calculate variables

Use Saved Search to derive the Headcount Value

Employee Search

Count employees

Grouped by Dept.

And Sub (if OneWorld)

Value Maximizer Webinar 2014.1


Dsg value maximizer webinar series

Setup Another Schedule tied to the Saved Search

Add Frequency of Schedule

Value Maximizer Webinar 2014.1


Dsg value maximizer webinar series

From here the process is the same as before

- Click “Create Journal Entry”

Value Maximizer Webinar 2014.1


1 st je from dynamic settings

1st JE from Dynamic settings

JE Detail will show Previous Value, Current Value and Difference

Value Maximizer Webinar 2014.1


Follow up je after stats changed

Follow up JE after Stats changed

When Headcount Changes the stored value also changes

Value Maximizer Webinar 2014.1


Statistical accounts and financials earnings per share

Statistical Accounts and Financials (Earnings Per Share)

NetSuite Release 2014.1February 26, 2014


Dsg value maximizer webinar series

EPS

Use Statistical Accounts to enter Number of Shares

Create a Formula to calculate EPS

Value Maximizer Webinar 2014.1


Batch processing for rev rec je enhanced reporting

Batch Processing for Rev Rec. JE & Enhanced Reporting

NetSuite Release 2014.1February 26, 2014


Batch processing for rev rec je

Batch Processing for Rev. Rec. JE

  • Version 2014 Release 1 introduces the following improvements:

    • The 10,000 batch limit has been removed.

    • When one batch finishes, the next automatically begins.

    • Up to five batches can run concurrently to complete processing more quickly.

Value Maximizer Webinar 2014.1


Enhanced rev rec reporting

Enhanced Rev. Rec. Reporting

  • The four additional fields in the Transaction Dimension group are:

    • Source Document Number – The transaction number of the original source

    • Source Document Type – The transaction type of the original source

    • Source Rev. Rec. Start Date – The revenue start date in the source document

    • Source Rev. Rec. End Date – The revenue end date in the source document

Value Maximizer Webinar 2014.1


Reporting disclaimer

Reporting Disclaimer

  • If you have high volume of Revenue Recognition schedules, reports will not work – Fix is scheduled for 2014.2 release.

  • If you have a low volume, these enhancements are part of 2014.1

Value Maximizer Webinar 2014.1


Reports included for enhancements

Reports included for Enhancements

  • The reports that are enhanced by this addition are:

    • Deferred Revenue By Customer

    • Deferred Revenue by Item

    • Deferred Revenue By State

    • Revenue by Customer

    • Revenue By Item

    • Revenue By State

    • Deferred Revenue Reclassification Activity

    • Deferred Revenue Reclassification

Value Maximizer Webinar 2014.1


Collapse expand vsoe field

Collapse/Expand VSOE Field

NetSuite Release 2014.1February 26, 2014


Collapse expand vsoe field1

Collapse/Expand VSOE Field

  • In a new transaction or in edit mode, the VSOE column includes an edit button. Click the button to open an allocation popup window and enter or change the parameters.

  • In view mode, the lines in the VSOE column are collapsed by default. Click more… to expand the lines and display all of the parameters. Click less… to collapse the lines again.

Value Maximizer Webinar 2014.1


Topics

Topics

  • Requisitions

  • File Drag & Drop BETA

  • StickyNotes BETA

  • Maximum Report size changes

  • Expense Account sign changes in Saved Search

Value Maximizer Webinar 2014.1


Requisitions

Requisitions

NetSuite Release 2014.1February 26, 2014


Requisitions overview

Requisitions - Overview

  • Advanced Procurement Module

    • Managed Bundle

    • This is the only feature currently available in the Module.

      • More coming in 2014.2 release

      • Full Bundle pricing is not set

      • If you want this feature now, let us know and we can get you the details on pricing

Value Maximizer Webinar 2014.1


What are requisitions

What are Requisitions?

  • Simpler version of a Purchase Request

  • Don’t need to assign a Vendor

  • Don’t need to deal with prices

  • Can make on behalf of others

    • Ex: An Admin can make a Requisition on behalf of several buyers

  • Allows optimization of resulting Purchase Orders

Value Maximizer Webinar 2014.1


Purchase requisitions workflow

Purchase Requisitions workflow

  • Provides a tool to consolidate and aggregate purchase requests and results in Purchase Orders

Value Maximizer Webinar 2014.1


Requisitions administration

Requisitions Administration

  • Similar to current Purchase Requests

    • Requisitions that are approved result in a Purchase Order

    • Access through Employee Center is recommended

      • Can be associated to an internal Role, but there are implications to the Approval path

    • Approval Routing tools are the same as other records

    • Can add Expenses or Items

  • Can use both Requisitions and Purchase Requests concurrently if desired

Value Maximizer Webinar 2014.1


Requisitions highlights

Requisitions Highlights

  • Items must already exist in the system

    • Expect to be allowed to create Items in the future

    • Preferred Vendor and/or Purchase Price from Item record will flow to Requisition, regardless of user entry

  • Requisitions are available to be consolidated onto Purchase Orders per vendor, with reference to Requisition record

    • No automated line-level consolidation

    • 10 lines requested = 10 lines on the PO

  • Requisitions are single-subsidiary only

    • Users whose Roles access multiple Subsidiaries will need to choose one on the Requisition

Value Maximizer Webinar 2014.1


Screenshot requisition form

Screenshot - Requisition form

Value Maximizer Webinar 2014.1


Screenshot order requisitions

Screenshot - Order Requisitions

Select Requisitions to be consolidated onto Purchase Order for the Vendor

Value Maximizer Webinar 2014.1


File drag drop dad beta

File Drag & Drop (DAD) BETA

NetSuite Release 2014.1February 26, 2014


File drag drop dad

File Drag & Drop (DAD)

  • Free managed Bundle/SuiteApp

    • Bundle ID: 40319

    • BETA – Available on upgrade

  • Chrome and Firefox only as of today

  • Once installed it adds a “drop zone” to the header of records

Value Maximizer Webinar 2014.1


Dad file administration

DAD File Administration

  • Upload must finish without page refresh, but can work on other fields on same record

  • Can be set to Automatically create a subfolder for each record type

    • Best practice will be to constitute a root folder by record type to support this, where record specific folders are held

  • Can repoint destination folder for each round of DAD files on the fly

  • Can upload to:

    • Record header

    • Editable Text fields (inline and on the fly)

    • Sublist Line items

Value Maximizer Webinar 2014.1


Dad highlights

DAD Highlights

  • Maximum single file size: 5MB

  • Maximum concurrent files loading: 5

  • Drop Zone available when in Edit mode

    • Not available in View mode this release

  • User must have ‘attach files to records’ permission

  • Available to Custom and Standard records

    • Administrator can select records to include/exclude easily

Value Maximizer Webinar 2014.1


Screenshot dad upload progress bar

Screenshot – DAD upload progress bar

Value Maximizer Webinar 2014.1


Screenshot dad to text field

Screenshot – DAD to Text field

Typing in “new Details” field and wish to add an image of a Screenshot.

Drag to field. Field turns green when file is pointed to it.

Value Maximizer Webinar 2014.1


Screenshot dad to text field results

Screenshot – DAD to text field results

Example result of adding files on-the-fly to editable text field

File #1

File #2

Value Maximizer Webinar 2014.1


Screenshot file to line item

Screenshot – File to line item

Drag file over line item

Destination DAD field/line will turn green when selected

Value Maximizer Webinar 2014.1


Screenshot dad files attached record view

Screenshot - DAD Files attached (record view)

Value Maximizer Webinar 2014.1


Dad files attached file cabinet view

DAD – Files attached (File Cabinet view)

Set up a “root folder” by Record Type

Set SuiteApp to create subfolder for each individual record

This will help greatly with organization

Value Maximizer Webinar 2014.1


Stickynotes beta

StickyNotes BETA

NetSuite Release 2014.1February 26, 2014


Stickynotes

StickyNotes

  • Free Managed Bundle/SuiteApp

  • BETA – Available in March

  • Adds a StickyNote toolbar beside the action menu

  • Enables a myriad of collaborative options

Value Maximizer Webinar 2014.1


Stickynotes administration

StickyNotes Administration

  • Administrator can configure what records are eligible for StickyNotes

  • StickyNotes can be Public (visible to all), Private (visible only to the author), set to a particular Recipient, or with Recipients AND Public.

  • Recipients set on StickyNotes get an email; Public StickyNotes are visible to anyone who can access the Record.

  • Notion of a StickyNotes ‘thread’

  • Notion of a StickyNotes User ‘Board’

    • View all StickyNotes where user is recipient or StickyNote is public.

    • Filters to help view by Record type, Priority, Owner, Date, etc.

    • List or Grid view

    • Reply to threads from here or the note itself

  • User level preferences for things like colors for priorities, but cannot be printed

  • No System Notes within the record (not auditable against the record).

    • Logged on a separate Custom record

    • Deletions are full deletions (no trace)

Value Maximizer Webinar 2014.1


Stickynotes highlights

StickyNotes Highlights

  • Can be private (for me only), to specific users, or public to anyone viewing the record.

  • Place anywhere on the record, move around

  • Only appears on the record where it’s created

  • Only the owner/creator can fully delete

  • Can create a StickyNote whether in Edit or View mode

  • Record can be set to Hide All/Show All by default, per user

  • StickyNotes are local to the record they are ‘stuck’ to only. (No pass-through the record sequence i.e. Sales Order > Fulfillment > Invoice)

  • Will be able to share file attachments to recipients (wave 2)

Value Maximizer Webinar 2014.1


Screenshot add new stickynote

Screenshot - Add new StickyNote

Value Maximizer Webinar 2014.1


Screenshot thread

Screenshot – “Thread”

Value Maximizer Webinar 2014.1


Screenshot multiple stickynotes

Screenshot – Multiple StickyNotes

Value Maximizer Webinar 2014.1


Screenshot stickynote user board

Screenshot – StickyNote User ‘Board’

Value Maximizer Webinar 2014.1


Report size and sign change for expense account saved search

Report Size and Sign Change for Expense Account Saved Search

NetSuite Release 2014.1February 26, 2014


Maximum supported report size

Maximum Supported Report Size

  • Before this release, the maximum number of rows that could be retrieved for a report was either 25,000 or 75,000 rows, but it depended on the kind of report

  • As of this release, the limits for retrieved rows per report are:

    • 100,000 rows — for a report executed on demand

    • 500,000 rows — for a report executed in the background (scheduled, emailed or exported reports)

Value Maximizer Webinar 2014.1


Change of sign for expense account amounts in saved searches

Change of Sign for Expense Account Amounts in Saved Searches

  • Until now, Transaction saved searches displayed positive amounts for credit posting transactions and negative amounts for debit posting transactions

    • Note that this behavior impacted only saved searches; it did not impact reports or accounting processes

  • As of Version 2014 Release 1, Transaction saved searches “correctly” handle expense accounts as debit accounts.

    • positive amounts for debitposting transactions and

    • negative amounts for credit posting transactions

  • This change ensures that expense accounts are consistently displayed throughout NetSuite.

Value Maximizer Webinar 2014.1


Change of sign for expense account amounts in saved searches1

Change of Sign for Expense Account Amounts in Saved Searches

  • Best practice is to review your Saved Searches in your Preview account before the upgrade happens

  • There are ways to retain the ‘old’ format if it is mission critical for your business.

  • If you see behavior you don’t understand, contact us and we can help

Value Maximizer Webinar 2014.1


Release dates and what s next

Release Dates and What’s Next

NetSuite Release 2014.1February 26, 2014


Netsuite 2014 1 release dates

NetSuite 2014.1 Release Dates

  • Release Dates

    • 01/24/14 – Early Adopters – DSG

    • 02/21/14 – 12% of DSG Customers

    • 03/07/14 – 14% of DSG Customers

    • 04/11/14 – 74% of DSG Customers

Value Maximizer Webinar 2014.1


Netsuite 2014 11

NetSuite 2014.1

  • Make sure to check out the release notes

Value Maximizer Webinar 2014.1


What s next

What’s Next?

  • Know your preview availability and upgrade dates.

  • Work with your DSG Account Manager to test existing functionality and implement new features.

  • Review release notes/NetSuite training videos to learn about many of the other new features.

  • Need assistance? Ask us, we can help!

Value Maximizer Webinar 2014.1


Thank you

Thank you


  • Login