Overview
This article guides a user through the process of connecting their NetSuite Inventory Management with the Scispot platform. The integration creates a two way sync between NetSuite and Scispot, allowing for actions initiated by either platform to be instantly and seamlessly reflected on the other.
Step 1: Connect Scispot to NetSuite
Go to app store within Scispot and select the NetSuite icon
Input the Rest API key to allow Scispot to access existing NetSuite Inventory and update changes to the quantities
Step 2: Map your fields
Inventory Metadata in Scispot LIMS and NetSuite ERP
Inventory Items:
Item Name/Number: Ensures consistency in naming conventions between systems.
Description: Detailed description of the inventory item.
Category: Classification of the item, which helps in organizing inventory.
Quantity on Hand: Real-time inventory levels to avoid discrepancies.
Unit of Measure: Standardized measurement units.
Cost: Acquisition cost of the inventory items.
Price: Selling price if applicable.
Location Details:
Location Name: Identifies the physical location of inventory items.
Address: Detailed address of the inventory location.
Contact Information: Contact details for the inventory location.
Supplier Information:
Supplier Name: Name of the supplier providing the inventory.
Supplier Code: Unique identifier for the supplier.
Contact Details: Contact information for the supplier.
Source of Truth for Fields
Scispot LIMS
Experimental Data: Data related to experiments, tests, and research should originate and be maintained in Scispot LIMS.
Test Results: Detailed outcomes of experiments and tests.
Sample Metadata: Information about the samples used in experiments.
Protocol Information: Experimental protocols and methodologies.
Lab Inventory Details:
Lab Equipment: Metadata about lab equipment and instruments.
Reagents and Chemicals: Information on reagents and chemicals used in the lab.
NetSuite ERP
Financial Information: Data related to financial transactions should be maintained in NetSuite.
Invoices: Billing and invoicing details.
Purchase Orders: Information about orders placed with suppliers.
Payments: Payment records and transaction details.
Customer and Supplier Management:
Customer Information: Details about customers, including contact information and purchase history.
Supplier Information: Supplier details, including contact information and transaction history.
Step 3: Initiate First Sync
Click initiate sync button to run a first sync
This will result in Scispot importing all NetSuite inventory data
Results in creation of a Inventory Management Labsheet reflecting NetSuite information
This Labsheet is now linked to NetSuite; changes on either platform will reflect on the other
Step 4: Try It Out!
Now when completing a protocol, simply consume the used items using Scispot's Inventory Automation from the Inventory Management Labsheet created above, and see this consumption instally reflected on NetSuite without ever having to leave your workflow
Step 5: Run Analytics in Scispot
Once your data is sync'd between Netsuite and Scispot Inventory module, you can easily generate charts to understand your inventory consumption in Scispot.
Example:
