Skip to main content

New Report In NetSuite

   
NetSuite comes with variety of Standard reports which are dynamic and can be customized as per the need of business. But what if those reports doesn't fulfill the requirement of your business?

In that situation you can create an ad hoc report by your own. 

Ad Hoc Report Creation

#1 Go to Reports > New Reports 


#2 Select the Matric ( Type of report you want to create for example Sales, transaction, case etc) 

#3 Give your Report a title.

#4 Select the Metric ( Type of data you want to build report on)

#5 Select the format of the report. There are three types of format available:

     - Summary: Summary is the default report display, providing a summary view.
     - Detail: Detail reports show a list of the items affecting the values in the report.
     - Matrix: A matrix-style report is a summary report with a variable number of columns.
 The  Column list in the report footer transforms a standard report into a matrix or crosstab report.

#6 In last step Select how you want to Summarize the report or how you want to subtotal the report
     - Select the component 
     - Select the Field 
    
   For Example if you want to see the  Transaction Summary report which should include the amount and was subtotal by account Name.

- Report > New Report > Select Transaction from Metric > Give title to report > Select Metric on which you want to build the report in Transaction. ( In are case it is Amount) >  Select the format ( in our case it is Summary) > select the component ( Account) > select the field ( Name) >  Save Report  or Run Report (if you do not want to save this report for future)


If you still see the requirement of adding more column to the report. You can customize the same report via Report Builder.  
                  🠝*Customize > Report Builder
                                                          






Popular posts from this blog

NETSUITE - OPENAIR INTEGRATION (HIGH LEVEL)

  NETSUITE SETUP Features to Enable (NETSUITE) Go to setup > Company > Enable features > Company Subtab > Check if these two features were enabled ➖ Projects Project Manager Custom Records Client Suitescripts Server Suitescripts SOAP Web Services Token-Based Authentication SuiteSignOn Bundles to Install Go to Customization > SuiteBundler > Search and Install bundle : NetSuite OpenAir SRP Integration (Bundle ID 369637) NetSuite OpenAir SRP Single Sign-On (Bundle ID 36919) NetSuite OpenAir SRP Real Time Add-On (Bundle ID 369630) NetSuite OpenAir SRP ARM (Bundle ID 370366) TBA CONSUMER KEY CREATION Setup > Integration > Manage Integration > New Enter the name and set the status on “Enabled” and check the user credential and Token-Based Authentication Checkbox When you’ll save the form, It’ll give you the Consumer key and the Consumer secret key. Make sure, you save that safely with you. Because due to security reasons, it won’t appear on the form second time...

Workflow Trigger Process on Record.

              Workflow Trigger processes in different stages. Types of Workflow Triggers: - 1. Client Trigger Before User Edit Before Field Edit After Field Edit  After Field Sourcing Before User submit 2. Server Trigger  Before Record Load Before Record Submit After Record Submit -  What happen when we edit a record?    1. When We open a record. We request system to fetch record from the database   2. System will fetch record from the database. here's the point where Server trigger gets active ( Before Record Load) . Various pre processing task can be performed  at this stage. like setting default values in a field etc. Page content is pushed to the browser in response to the the record request. Here, Before User Edit client trigger takes place.  3. We make some changes in the record. At this moment Client triggers such as Before field edit after field edit after field sourcing takes place.( depends on user i...