dsg value maximizer webinar series
Download
Skip this Video
Download Presentation
DSG Value Maximizer Webinar Series

Loading in 2 Seconds...

play fullscreen
1 / 79

DSG Value Maximizer Webinar Series - PowerPoint PPT Presentation


  • 187 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' DSG Value Maximizer Webinar Series' - ling


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

slide31

Setup Another Schedule tied to the Saved Search

Add Frequency of Schedule

Value Maximizer Webinar 2014.1

slide32

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

slide36
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

ad