NetSuite
Introduction
Our in-house built solution creates a seamless integration between NetSuite and Point of Sale that supports your day-to-day business processes and is also easily scalable and customizable to fit your exact requirements.
Point of Sale & NetSuite Integration Introduction
The Point of Sale and NetSuite integration creates a seamless connection between your point of sale system and NetSuite, enabling efficient data synchronization across both platforms.
Direction: 2 Way (Point of Sale ↔ NetSuite)
Point of Sale to NetSuite
| Point of Sale | NetSuite |
|---|---|
| Customers | Customers |
| Sales Documents | Sales Orders, Cash Sales, Credit Memos |
| Payments | Customer Deposits, Customer Payments |
| Purchase Orders | Purchase Orders |
| Inventory Adjustments | Inventory Adjustments |
NetSuite to Point of Sale
| NetSuite | Point of Sale |
|---|---|
| Customers | Customers |
| Items | Products |
| Price Levels | Price Lists |
| Vendors | Suppliers |
| Locations | Locations |
| Purchase Orders | Purchase Orders |
| Item Fulfillments | Inventory Receipts |
Sync Entities
Customers
Customer sync can be bidirectional (two-way) between Point of Sale and NetSuite. This means that customer records created or updated in either system can be synchronized to the other system.
Field Names
| Point of Sale | NetSuite |
|---|---|
| First Name | First Name |
| Last Name | Last Name |
| Full Name | Company Name |
| Company | Company Name |
| Phone | Phone |
| Mobile Phone | Mobile Phone |
| Billing Address | Default Billing Address |
| Shipping Address | Default Shipping Address |
Products
Product sync is one-way from NetSuite to Point of Sale. NetSuite is the master system for product information.
Field Names
| NetSuite | Point of Sale |
|---|---|
| Display Name | Name |
| Item ID / SKU | Code |
| UPC Code | Barcode |
| Sales Description | Description |
| Base Price | Default Price |
| Cost Estimate | Cost |
| Tax Schedule | Tax Rate |
| Item Type | Type |
| Inventory Item | Inventory Item |
| Vendor | Supplier |
| Vendor Item | Supplier Code |
Price Lists
Price list sync is one-way from NetSuite to Point of Sale. NetSuite price levels are mapped to Point of Sale price lists.
Field Names
| NetSuite | Point of Sale |
|---|---|
| Price Level Name | Price List Name |
| Price Level Values | Price List Values |
| Currency | Currency |
Suppliers/Vendors
Supplier/vendor sync is one-way from NetSuite to Point of Sale. NetSuite vendors are mapped to Point of Sale suppliers.
Field Names
| NetSuite | Point of Sale |
|---|---|
| Vendor Name | Supplier Name |
| Vendor ID | Code |
| Phone | Phone |
| Address | Address |
Locations
Location sync is one-way from NetSuite to Point of Sale. NetSuite locations are mapped to Point of Sale locations.
Field Names
| NetSuite | Point of Sale |
|---|---|
| Location Name | Location Name |
| Location ID | Code |
| Address | Address |
Purchase Documents
Purchase document sync can be bidirectional between Point of Sale and NetSuite. Purchase orders can be created in either system and synchronized to the other.
Field Names
| Point of Sale | NetSuite |
|---|---|
| Purchase Order Number | Purchase Order Number |
| Date | Date |
| Supplier | Vendor |
| Location | Location |
| Line Items | Line Items |
| Status | Status |
Inventory Receipts (Item Fulfillments)
| Point of Sale | NetSuite |
|---|---|
| Inventory Receipt Number | Item Receipt Number |
| Date | Date |
| Supplier | Vendor |
| Location | Location |
| Line Items | Line Items |
| Status | Status |
Inventory Adjustments
Inventory adjustment sync is one-way from Point of Sale to NetSuite. Inventory adjustments made in Point of Sale are synchronized to NetSuite.
Field Names
| Point of Sale | NetSuite |
|---|---|
| Adjustment Number | Adjustment Number |
| Date | Date |
| Location | Location |
| Reason | Memo |
| Line Items | Line Items |
Sales Documents
Sales document sync is one-way from Point of Sale to NetSuite. Sales invoices, cash sales, and credit notes created in Point of Sale are synchronized to NetSuite.
Field Names
| Point of Sale | NetSuite |
|---|---|
| Document Number | Document Number |
| Date | Date |
| Customer | Customer |
| Location | Location |
| Line Items | Line Items |
| Salesperson | Sales Rep |
| Discount | Discount |
| Tax | Tax |
| Total | Total |
Payments
Payment sync is one-way from Point of Sale to NetSuite. Payments recorded in Point of Sale are synchronized to NetSuite as customer deposits or customer payments.
Field Names
| Point of Sale | NetSuite |
|---|---|
| Payment Number | Payment Number |
| Date | Date |
| Customer | Customer |
| Payment Method | Payment Method |
| Amount | Amount |
| Reference | Reference |
| Applied Document | Applied Document |
Global Features
Synchronization Intervals
The integration runs on scheduled intervals, typically every 15 minutes. These intervals can be customized based on your business needs, with a minimum interval of 5 minutes.
Integration Setup
Our team will work with you to set up and configure the integration according to your specific requirements. This includes:
- Mapping fields between NetSuite and Point of Sale
- Setting up document type associations
- Configuring synchronization intervals
- Testing the integration in sandbox environments
- Deploying to production