1 | NetSuite Integration

This article covers the NetSuite Integration for Bepoz along with all the required credentials for configuration. Net Suite is a cloud-based business managed platform which can be setup as a job within Bepoz. This Integration consists of an integrated ERP management system and allows the operator to handle and manage core business processes.

This article covers the NetSuite Integration for Bepoz along with all the required credentials for configuration.

Net Suite is a cloud-based business managed platform which can be setup as a job within Bepoz. This Integration consists of an integrated ERP management system and allows the operator to handle and manage core business processes.

Prerequisites

• Bepoz requires that all Account and location records must have Export Code 1 set to NetSuite corresponding internal ID's

---

Net Suite Integration

Setting NetSuite Job

• NetSuite is setup as a job within Bepoz. Operators will need to select Jobaccint.dll as the DLL Name and then they will have an option to select Job Net Suite

• To Configure NetSuite settings, the operator will need to select configure from the bottom of the job setup window. When you configure is selected for the first time, an error message will be prompted. The error message is to let the user know that NetSuite has no connection as it has not been configured correctly

General Tab

In the General tab, the operator will need to map the settings according to what is provided by NetSuite 
NetSuite needs to provide an Endpoint, account ID, Email, Password and Role ID. Without the NetSuite credentials, NetSuite cannot be exported

Suppliers Tab

The suppliers tab is where Bepoz Suppliers  is synchronized to NetSuite

Export Suppliers:  Flagged on suppliers will be exported. Flagged Off suppliers will not be exported

Use Custom Form- Flagged on will use Custom Form. Flagged Off will use a standard form

Custom Form ID- Information provided by NetSuite

Default Type- There are two default types to choose from Company and Individual

To populate a list of Suppliers- select the populate button

Once populated a list, it needs to be synchronized to NetSuite

Select Synchronise to sync the suppliers with NetSuite

Below is a sample of a list of suppliers from Bepoz. The line items marked green have not yet synchronised with NetSuite. The white line items already exist in NetSuite

If synchronise is selected at this stage, the operator will receive an error message because of the EntityID not being mapped with a supplier number. The user has to ensure all the suppliers have supplier numbers assigned to the suppliers or the supplier list will not synchronise to NetSuite. 
Sample snapshots have been attached below that shows what would happen if not all suppliers have supplier numbers. 
This message will notify the end user that 2 suppliers failed to synchronise and 2 have successfully synchronised.

Image 1.6 
In image 1.5 there were 4 green line items and now there are 2 because I did not assign a supplier number

 

Products Tab

NetSuite does not have the ability to hold product sizes like Bepoz. Bepoz has to export each product by size – if the operator has multiple sizes for one product then that product will be seen multiple times within the populated list. -1, -2 etc. represents the size e.g. in the sample image 1.8 22-1 is Tropicana size 1 in Bepoz.

If the line item is green as the example- because the line items have not synchronised with Micropower
Export Products- Flagged On will Products to NetSuite. Flagged off will not export orders
Use Custom Form - Flagged On will use Custom From. Flagged off standard form will be used
Custom Form ID- Information provided by NetSuite
VenueID - Information provided by NetSuite
StoreID - Information provided by NetSuite
Price NO - Information provided by NetSuite
GSTFRID - Information provided by NetSuite
GSTID - Information provided by NetSuite

Mapping Options

Cost of Sales - Information provided by NetSuite
Sales - Information provided by NetSuite
Inventory - Information provided by NetSuite

Orders Tab

Export Orders - Flagged On will export orders to NetSuite. Flagged off will not export orders
Use Custom Form - Flagged On will use Custom From. Flagged off standard form will be used
Custom Form ID- Information provided by NetSuite
PLU FieldID - Information provided by NetSuite

Receipts Tab

Export Receipts- Flagged On will export the receipts to NetSuite. Flagged Off will not export the receipts.

Use Custom Form- Flagged On will use custom form. Flagged Off will use standard form

Custom Form ID- Information provided by NetSuite

InvoiceNo FieldID- Information provided by NetSuite

PLU FieldID- Information provided by NetSuite

 

Stock Activity Types

There are 13 Stock Activity Types. These types are related to Bepoz