Defining Drill Through Parameters to Oracle NetSuite
The parameters required to drill back to Oracle NetSuite are described below.
The server URL for drilling to Oracle NetSuite takes the drill URL address format of: https://<NetSuite
Domain>/app/common/search/searchresults.nl?.
On the detail side (where you specify the search type components), the drill URL to Oracle NetSuite requires the following parameters:
- "search type"
- "search ID"
- Optionally, you can specify additional parameters to filter the drill based on the Account and Period.
Search Type
The drill through parameter list includes the search type of "Transaction." It is specified in the drill through URL as:
Searchtype=Transaction&searchid=customsearch_nspbcs_trial_balance&Transaction_ACCOUNT=$ATTR1$&Transaction_POSTINGPERIOD=$ATTR2$&Transaction_DEPARTMENT=$ATTR5$&Transaction_CLASS=$ATTR4$&Transaction_INTERNALID=$ATTR3$&Transaction_POSTING=T&
The Transaction search types include:
-
Transaction_POSTINGPERIOD
-
Transaction_DEPARTMENT
-
Transaction_SUBSIDIARY
-
Transaction_CLASS
-
Transaction_LOCATION
-
Transaction_INTERNALID
-
Transaction_POSTING=T
Search ID
The drill through list also includes "Search ID." Specify the parameter by using Search StringID.
You can find the value from the Search Definition in Oracle NetSuite.
https://<NetSuite
Domain>/app/common/search/searchresults.nl?searchtype=Transaction&searchid=customsearch_nspbcs_all_transactions_det.
Additional Parameters
You can specify additional parameters to filter the drill based on account and period. Below are some commonly used parameters:
Table 17-2 Additional Filter Parameters
| Label | Parameter | Value | Example |
|---|---|---|---|
|
Account |
Transaction_ACCOUNT |
Account internal ID |
|
|
Main Line |
Transaction_MAINLINE |
T or F |
|
|
Period |
Transaction_POSTINGPERIOD |
Period ID or key of the predefined period |
|
|
Posting |
Transaction_POSTING |
T or F |
|
|
Subsidiary |
Transaction_SUBSIDIARY |
Subsidiary internal ID |
|