This is a frontend static clone of NetSuite, built to help people learn about it before buying it. Learn more here.

Administration and Controls

SuiteQL Query Tool

More
- Add To Shortcuts

Local Query Library

Remote Query Library

Save Query

ERROR

File Name:

Description:

Workbooks

Query Editor
		Enable Pagination Options Return Rows: thru Return All Rows Return Total Rows Count Hide Row Numbers Format Results As: Table DataTable CSV JSON PDF HTML Display NULL Values As: Dimmed Blank null
Template Editor


SuiteQL Query Tool Version 2021.2. Developed by Tim Dietrich.

...title...

...description...

...error...

Cadbury Technology, Inc.

SWITCH TO ANOTHER ACCOUNT

Demo Environment

All Recent Records

Manish Sinha (disabled) (Employee)

SOAP Web Services Preferences

Invoice #INV01 (1 Test company)

on record save (Script)

customdeploymanish_on_record_save (Script Deployment)

STR E - Invoice 2 (Custom Transaction Form)

test (Inventory Item)

1 Test company (Customer)

Manish Sinha (Employee)

Marshall Mathers (Employee)

Add To Shortcuts

Set Preferences

Activities Overview

Scheduling

Setup

Calendar Preference

Payments Overview

Setup

Payment Processing

Bank File Generation

Cheques

Global Payments

Zengin Bank Fee Schedule

Payment Aggregation

Payment File Templates

Payment Schedule

Payment File Template Requests

Electronic Payments Preference

Payment File Administration

Bill Payment Processing

Bill Payment Batches

Invoice Payment Processing

Payment Batch List

Customer Refund Payments

Generate Bill Payment File

Generate Customer Payment File

Bill Payment Processing

Invoice Payment Processing

Customer Refund Payments

Payment Batch List

Bill Payment Batches

Transactions Overview

Bank

Purchases

Payables

Sales

Customers

Order Management

Inventory

Quota/Forecast

Financial

Management

Issue Credit Card Charge

Issue Credit Card Refund

Reconcile Bank Statement

Reconcile Credit Card Statement

Banking Import History

Reconcile Account Statement

Bank Matching and Reconciliation

Reconciliation Rules

Automated Cash Application

Match Bank Data

Enter Purchase Orders

Bill Purchase Orders

Pay Single Vendor

Post Vendor Bill Variances

Enter Vendor Credits

Create Opportunities

Prepare Estimates

Enter Sales Orders

Approve Sales Orders

Manage Payment Holds

Invoice Sales Orders

Create Invoices

Enter Cash Sales

Create Statement Charges

Accept Customer Payments

View Credit Card Transactions

Issue Customer Refund

Issue Return Authorizations

Approve Return Authorizations

Receive Returned Order

Issue Credit Memos

Refund Cash Sales

Assess Finance Charges

Record Customer Deposits

Invoice Billable Customers

Generate Statements

Individual Statement

Generate Price Lists

Individual Price List

Reallocate Items

Adjust Inventory

Adjust Inventory Worksheet

Distribute Inventory

Transfer Inventory

Replenish Location By Inventory Transfer

Approve Transfer Orders

Enter Intercompany Transfer Orders

Enter Transfer Orders

Review Negative Inventory

Establish Quotas

Edit Sales Rep Forecast

Edit Sales Manager Forecast

Make Journal Entries

Make Advanced Intercompany Journal Entries

Revalue Open Currency Balances

Enter Memorized Transactions

View Audit Trail

View Payment Events

View Gateway Asynchronous Notifications

View Cardholder Authentication Events

Transaction Numbering Audit Log

GL Audit Numbering Sequences

Print Checks and Forms

Search Transactions

Accounting

Employees

Relationships

Support

Mailing

Search

Mass Update

Currency Exchange Rates

Item Collections

Item Creation Assistant

Quantity Pricing Schedules

Consolidated Exchange Rates

Bounced Email Addresses

Undelivered Emails

Saved Searches with HTML in Formula(Text)

Saved Mass Updates

Swap Prices Between Price Levels

Entity Duplicate Resolution

Duplicate Resolution Status

Bulk Update Translation

Remove Personal Information

Reports Overview

New Financial Report

Recent Reports

Saved Reports

Scheduled Reports

Saved Searches

Scheduled Searches

Financial

Banking/Budgeting

Employees/HR

Time & Billables

Purchases

Vendors/Payables

Inventory/Items

Order Management

Customer/Receivables

Sales

Sales Orders

Forecast

Cases

Marketing

Pipeline Analysis

Integration

Sales Tax US

Item 360

Chart of Accounts

All Saved Reports

Billing Forecast By Customer

Report Schedules

All Saved Searches

Campaign Response

Churn - Customers

Open Purchase Orders Report

Sales History - Item

Income Statement

Comparative Income Statement

Comparative Balance Sheet

Cash Flow Statement

Chart of Accounts

Transaction Detail

Realized Exchange Rate Gains and Losses

Unrealized Exchange Rate Gains and Losses

GL Audit Numbering

CTA Balance Audit

Financial Row Layouts

Row Layout Assignment

Customize Summary

Customize Detail

Customize Summary

Customize Summary

Customize Detail

Customize Summary

Customize Summary

Budget Income Statement

Budget vs. Actual

Customize Summary

Customize Detail

Customize Summary

Customize Summary

Customize Detail

Customize Detail

Employee Change History

Unbilled Cost by Customer

Customize Summary

Customize Detail

Purchase by Vendor

Purchase by Item

Purchase Order Register

Open Purchase Orders

Purchase Order History

Customize Summary

Customize Detail

Customize Summary

Customize Detail

A/P Payment History by Bill

A/P Payment History by Payment

Customize Summary

Customize Detail

Inventory Profitability

Current Inventory Snapshot

Physical Inventory Worksheet

Inventory Valuation

Inventory Revenue

Inventory Back Order Report

Inventory Activity Detail

Items Pending Fulfillment

Inventory Turnover

Transfer Order Register

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Sales Orders Register

Open Sales Orders

Sales Orders Pending Fulfillment

Sales Back Order Report

Shipping Report

Return Authorizations Register

Open Return Authorizations

Return Authorizations Pending Receipt

Customers by Sales Rep

Customers by Territory

Customers by Partner

Customer Profitability

Prospect Analysis

A/R Payment History by Invoice

A/R Payment History by Payment

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Sales by Customer

Sales by Sales Rep

Sales by Partner

Sales by Historical Team

Sales by Historical Team (Transaction Date)

New Customer Sales

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Sales Orders by Customer

Sales Orders by Item

Sales Orders by Sales Rep

Sales Orders by Partner

Sales Orders by Historical Team

Sales Orders by Historical Team (Transaction Date)

New Customer Sales Orders

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Forecast vs. Quota

Forecast by Status Summary

Calculated Forecast by Sales Rep

Forecast by Sales Rep

Forecast by Customer

Forecast (Outstanding) by Customer

Forecast by Item

Forecast Accuracy

Forecast vs. Quota by Class

Forecast vs. Quota by Department

Forecast vs. Quota by Location

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Open Case Analysis

Closed Case Analysis

Open Case Escalation

Closed Case Escalation

Case Activity by Support Rep

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Lead Source Analysis

Gross Lead Source Analysis

Partner Activity

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Pipeline by Status Summary

Total Pipeline by Statuses Summary

Pipeline by Sales Rep

Total Pipeline by Sales Rep

Pipeline by Customer

Total Pipeline by Customer

Total Open Opportunities

Opportunities to Close

Opportunities Won

Opportunities Lost

Estimates to Close

Open Estimates By Lines

Total Open Estimates

Estimates Register

Sales Activity by Customer

Customer Aging History

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Customize Summary

Customize Detail

Sales Tax Liability By Tax Agency

Sales Tax Liability By Tax Item

Sales Tax on Sales

Sales Tax Analysis

Customize Summary

Customize Detail

Documents Overview

Files

Templates

Mail Merge

Attachments Received

Attachments Sent

Email Templates

Letter Templates

Company

Accounting

Sales

Marketing

Support

Import/Export

Users/Roles

Integration

Employee Directory/Org Browser

Dashboard Tiles

Navigation Portlet

License Client

Bundle Deployment

Records Catalog

SETUP TASKS

Company Information

Enable Features

Subsidiary Settings Manager

Rename Records/Transactions

Auto-Generated Numbers

States/Provinces/Counties

Application Publishers

PREFERENCES

General Preferences

SuiteCloud Processors

COMMUNICATION

Outbound Request List

Sent Email List

EMAIL

Email Preferences

System Email Templates

AI

CLASSIFICATIONS

Convert Classes to Departments

Convert Classes to Locations

COMPANY MANAGEMENT

Bulk Processing Status List

Duplicate Detection

Administrative Notifications

Sandbox Accounts

Release Preview

Customer-Scheduled Maintenance

NETSUITE ACCOUNT INFORMATION

Service Tier Dashboard

Billing Questions

View Billing Terms

View Billing Information

NetSuite Support Login

SETUP TASKS

Enter Opening Balances

Accounting Lists

Expense Categories

Employee Related Lists

MANAGE G/L

Chart of Accounts

Fiscal Calendars

Manage Accounting Periods

PREFERENCES

Accounting Preferences

Invoicing Preferences

Payment Preferences

Inventory Costing Preferences

Finance Charge Preferences

Customize Fulfillment Email

FINANCIAL STATEMENTS

Payment Processing Profiles

Financial Institution

TAXES

Tax Control Accounts

Use State Sales Tax Tables

SETUP TASKS

Customer Statuses

PREFERENCES

Sales Preferences

SALES MANAGEMENT

Sales Territories

Territory Reassignment

SETUP TASKS

Online Customer Forms

Promotional URLs

Campaign Subscriptions

SETUP TASKS

Case Priorities

Case Origin Types

PREFERENCES

Support Preferences

CASE MANAGEMENT

Case Territories

Territory Reassignment

Online Case Forms

ESCALATION MANAGEMENT

Case Alerts (Beta)

IMPORT TASKS

Import CSV Records

View CSV Import Status

Saved CSV Imports

CSV Import Preferences

EXPORT TASKS

Bulk Update Translation

Full CSV Export

Delete Config Data

Import Config Data

USER MANAGEMENT

Show Role Differences

View Login Audit Trail

User Access Reset Tool

TWO-FACTOR AUTHENTICATION

Two-Factor Authentication Roles

INTEGRATION MANAGEMENT

SOAP Web Services Preferences

SOAP Web Services Process Status

SOAP Web Services Usage Log

Manage Integrations

Integration Governance

MANAGE AUTHENTICATION

Device ID detail

Manage Dashboard Tiles

Manage Shortcut Group

License Dashboard

Manual License Request

License Test Mode

Customization Overview

Lists, Records, & Fields

Forms

Scripting

Workflow

Plug-ins

Centers and Tabs

SuiteBundler

Translations

SuiteCloud Development

Performance

Transaction Body Fields

Transaction Line Fields

Transaction Item Options

Other Record Fields

Custom Help for Standard Fields

Transaction Forms

Advanced PDF/HTML Templates

Transaction Form PDF Layouts

Transaction Form HTML Layouts

Script Deployments

Single Page Applications

Scripted Records

Scheduled Script Status

Map/Reduce Script Status

Priority Settings

Script Execution Logs

Script Debugger

Custom Plug-in Types

Plug-in Implementations

Manage Plug-ins

Center Categories

Search & Install Bundles

Bundle Audit Trail

Manage Translations

Installed SuiteApp List

SuiteApp Marketplace

Deployment Audit Trail

Performance Health Dashboard

Record Pages Monitor

Page Time Summary

Page Time Details

SuiteScript Analysis

SuiteCloud Processors Monitor

SuiteCloud Processors Job Details

SOAP Web Services Analysis

REST Web Services Analysis

Concurrency Monitor

Search Performance Analysis

Search Performance Details

Commerce Overview

Hosting

Marketing

INTELLIGENT RECOMMENDATIONS

Recommendation Scenarios

Recommendation Blocklists

Recommendation Availability

Recommendation Preferences

Administration and Controls Overview

Alerts

Analyze

Audit

Customers

Items

Transactions

Transactions Approved By Creator

Saved Search Log

Bundle Audit Trail

Change Status of Accounting Period

Deleted Record Audit Log

GL Audit Numbering Sequences

Saved Search Log

Script Changes Log

Script Execution Logs

System Notes Audit Log

System Notes For Configuration Settings

System Notes on Custom Records Results

Transaction Audit Log

Transaction Numbering Audit Log

View Audit Trail

View Login Audit Trail

Item Sales Description Change

Item Price Change

Item Purchase Description Change

Purchase Order Rate Changes

Returns by Employee

Sales Detail Query

Transactions Audit

Transactions Approved By Creator

SuiteQL Overview

SuiteQL

Support Overview

Go to SuiteAnswers

Solution Design