NetSuite Integration
You can integrate your Asset Panda Pro account with your Oracle NetSuite account to fetch and manage your business data efficiently. This integration ensures that key records from NetSuite are available in Asset Panda Pro, enabling better asset tracking and operational visibility.
This integration supports one-way data synchronization, pulling data from NetSuite into Asset Panda Pro. Changes made in Asset Panda will not reflect in NetSuite
NetSuite is a third-party application, and Asset Panda Pro does not control updates made within NetSuite. For more information, refer to NetSuite resources.
Prerequisites
Active NetSuite account with administrative permissions
Active Asset Panda Pro subscription with administrative permissions
Token-Based Authentication (TBA) enabled in NetSuite
NetSuite tasks
Enable required features
Log into NetSuite as an administrator.
Select Setup > Company > Enable Features.
Select the SuiteCloud tab.
Enable the following settings:
Token-Based Authentication
REST Web Services
Click Save.
Create an integration record
Select Setup > Integrations > Manage Integrations > New.
Enter a name (for example,
Asset Panda Integration).Ensure Token-Based Authentication is enabled.
Click Save. NetSuite generates the Consumer Key (Client ID) and Consumer Secret (Client Secret).
Copy and store the Consumer Key (Client ID) and Consumer Secret (Client Secret) securely.
Generate an access token
Select Setup > Users/Roles > Access Tokens > New.
Select the following details:
Application Name (integration record created earlier)
User
Role
Click Save. NetSuite generates the Token ID and Token Secret.
The Token Secret is shown only once and must be stored securely.
Retrieve the Account ID
Select Setup > Company > Company Information.
Copy the Account ID.
Asset Panda tasks
Set up the NetSuite integration
Log into Asset Panda Pro with an administrator account
Navigate to
Settings > Account Management.Expand the appropriate account and module.
Click Manage in the Integrations card.
Select Integrations Store.
In the NetSuite tile, click Add. The Integrations in this module tab is displayed.
In the NetSuite tile, click Configure.
Enter the following details to authenticate Asset Panda Pro with NetSuite:
Account ID
Consumer Key / Client ID
Consumer Secret / Client Secret
Token ID
Token Secret
Click Test and save connection.
If the test is successful, click Continue with mapping.
Click Add mapping option.
Enter a Mapping Name for your configuration.
Select the External Entity for which you want to map data fields:
Purchase Orders
Departments
Items
Subsidiaries
Item Receipts
Vendors
If Items was selected in the previous step, click Filter to filter the sync based on one or more selected Item Types:
Inventory Item
Non-Inventory Item
Service Item
Assembly Item
Kit/Package Item
Item Group
Matrix Item
Select the Asset Panda Pro Collection where the NetSuite data should be stored.
In the Mapping & Sync Direction section, map the Asset Panda field from NetSuite to the relevant column in your Asset Panda Pro collection. See Configure data mapping.
Click Save.
Configure data mapping
Proper field mapping is critical to avoid duplication or mismatched records
Under Oracle NetSuite, select the NetSuite fields to map.
Under Asset Panda Pro, select the corresponding Asset Panda Pro fields. See NetSuite field mapping.
To map additional fields, click Add more and then repeat steps 1-2.
Click Save.
You can schedule the sync to run on a configured schedule or choose Run now for the automation to trigger the sync manually.
You can view Automation Logs to review the sync status and any errors or failures. See Activity Stream.
NetSuite field mapping
Purchase Order fields
Amount
Total amount for the purchase order line
Map to cost or value fields
Currency ID
Internal currency identifier
Backend/reference use
Currency Name (Display)
Currency name
Map for readability
Order Date (Tran Date)
PO creation date
Map to order date
Due Date
Payment due date
Useful for tracking
Ship Date
Shipping date
Map if required
Status Name (Display)
PO status
Use for filtering
Purchase Order Internal ID
Internal PO identifier
Backend/reference use
PO Number (Tran ID)
PO number
Map for display
Vendor ID (Entity ID)
Vendor identifier
Backend/reference use
Vendor Name (Display)
Vendor name
Map to vendor field
Item ID
Item identifier
Link to inventory
Item Name (Display)
Item name
Map to asset name
Quantity
Item quantity
Map to quantity
Rate
Unit cost
Map to cost
Line Sequence Number
Line order
Optional
Last Modified Date
Last updated timestamp
Useful for tracking
Department fields
Department ID
Internal department identifier
Backend/reference use
Name
Department name
Map to department field
Subsidiary IDs
Linked subsidiaries
Useful for hierarchy
Inventory Item fields
Item Internal ID
Internal item identifier
Backend/reference use
Item Code / Number
SKU or item code
Map to asset code
Display Name
Item name
Map to asset name
Item Type (Display Name)
Type of item
Useful for filtering
Item Type Code
Internal type code
Backend/reference use
Is Inactive
Inactive status
Filter inactive items
Created Date
Creation date
Map if needed
Last Modified Date
Last updated timestamp
Useful for tracking
Average Cost
Averate item cost
Map to cost
Last Purchase Price
Latest purchase price
Reference pricing
Purchase Cost (Base)
Base purchase cost
Map to cost
Total Value (On Hand)
Inventory value
Reporting use
Units Type ID
Unit identifier
Backend/reference
Units Type Name (Display)
Unit name
Map to unit field
Subsidiary fields
Department ID
Internal department identifier
Backend/reference use
Name
Department name
Map to department field
Subsidiary IDs
Linked subsidiaries
Useful for hierarchy
Item Receipt fields
Item Receipt Internal ID
Internal identifier
Backend/reference
Receipt Number (Tran ID)
Receipt number
Display/reference
Receipt Date (Tran Date)
Date received
Map to receiving date
Amount
Total amount
Map to value
Quanitity Received
Quantity received
Map to quantity
Quantity Billed
Quantity billed
Financial tracking
Rate
Unit cost
Map to cost
Item ID
Item identifier
Link to inventory
Item Name (Display)
Item name
Map to asset
Department ID
Department identifier
Backend use
Department Name
Department name
Map to field
Location ID
Location identifier
Backend use
Location Name
Location name
Map to location
Subsidiary ID
Subsidiary identifier
Backend use
Subsidiary Name (Display)
Subsidiary name
Map to org
Vendor ID (Entity ID)
Vendor identifier
Backend use
Vendor Name (Display)
Vendor name
Map to vendor
Posting Period ID
Period identifier
Backend use
Posting Period Name
Period name
Reporting
Source PO Line ID
PO line reference
Traceability
Source PO Reference
PO reference
Link records
Line Sequence Number
Line order
Optional
Last Modified Date
Last updated timestamp
Tracking
Vendor fields
Vendor Internal ID
Internal vendor identifier
Backend/reference
Vendor Name (entityid)
Vendor name/identifier
Map to vendor field
Company Name
Vendor company name
Display/reporting
Legal Name
Registered name
Compliance use
Email address
Map to contact
Phone
Phone number
Map to contact
Currency ID
Currency identifier
Backend use
Currency Name (Display)
Currency name
Map to currency
Balance (Vendor Currency)
Outstanding balance
Financial tracking
Balance Primary (Base Currency)
Base currency balance
Reporting
Credit Limit
Vendor credit limit
Financial use
Unbilled Orders Amount
Pending billing amount
Procurement tracking
Subsidiary Edition
Linked subsidiary
Org mapping
Is Inactive
Inactive status
Filter records
Is Job Resource Vendor
Vendor type flag
Optional
Last Modified Date
Last updated timestamp
Tracking
Last updated