Proposal summary Interface Description is a Brucker Warehouse Software system. The shipping and tracking of the order needs to be synced between the NetSuite and Brucker Warehouse system. Requirement The requirement is to integrate the Brucker Warehouse software system with NetSuite. The integration will be done using the SFTP file transfer since the Brucker Warehouse… Continue reading NetSuite-Interface Integration Proposal
Month: February 2022
NetSuite-Magento Integration Functional Document
Proposal summary This proposal details how the integration between NetSuite and Magento is handled and also the full plan of the integration. Requirement The overview scope of the NetSuite-Magento integration as follows: Item SYNC from NetSuite to Magento Item Inventory SYNC(Stock Update) from NetSuite to Magento Customer SYNC from Magento to NetSuite Order SYNC from… Continue reading NetSuite-Magento Integration Functional Document
Fetch all Transaction Details via Query REST Web Services.
REST Web Services is a standard API that is provided by NetSuite. In REST Web services we can use the Query to list and filter the supported records. The query operation is used to execute a query on a specific record type based on a set of criteria. Record query only returns record IDs and… Continue reading Fetch all Transaction Details via Query REST Web Services.
Item Receipt Details Bulk Extraction via SOAP Web Services via search and getList Operations
SOAP Web services can be used for extracting item receipts details from the NetSuite account. We need to define the SOAP request with the body to fetch the data. With the SOAP request, we can directly fetch the data from the NetSuite. SOAP is a standard NetSuite API. Following are the steps for the extraction… Continue reading Item Receipt Details Bulk Extraction via SOAP Web Services via search and getList Operations
Auto-Calculation of Reorder Point and Preferred Stock Level Troubleshooting
Scenario To troubleshoot Reorder Point and Preferred Stock Level concerns. Below are the possible instances which may prevent the auto-calculation from running on an item record: User’s account is new and have no sales history data entered. Account have new item records that have no sales history data. User enabled Multi-Location Inventory and have no sales history data… Continue reading Auto-Calculation of Reorder Point and Preferred Stock Level Troubleshooting
Multi Location Inventory / MLI_LOCATION_REQUIRED Error
A transaction or its items must have a location. The error “MLI_LOCATION_REQUIRED“will be encountered if the Item involved was not distributed to any location by using the Inventory Distribution Transaction. The user needs to check Transactions > Inventory > Distribute Inventory > Lists to verify that an Inventory Distribution was made. If there is already… Continue reading Multi Location Inventory / MLI_LOCATION_REQUIRED Error
Proposal for fetching items sales data from iQmetrix
Proposal summary This proposal is for retrieving item sales data from iQmetrix and storing it in a Netsuite custom record.. Requirement We need to be able to sell through data. By any date range we want By any dealer? Can it fetch daily and add it and we can analyze all that data through a… Continue reading Proposal for fetching items sales data from iQmetrix
Item Fulfillment has No GL Impact
Scenario User noted some Item fulfillment that does not post any value in the GL impact. Solution Item Fulfillment may not post value in the GL impact due to the following reasons: 1. Item shipped is a Non-inventory Item 2. Item Fulfillment was created form a Dropshipment order 3. Inventory item was sold underwater or has a negative inventory at the time of fulfillment To determine if there are… Continue reading Item Fulfillment has No GL Impact
Create an online contact form template
Goto : Setup> marketing > online customer form Add the title and also the template. Add all the fields that is needed to be displayed in the template in the netsuite and save To add the template to netsuite, goto documents> templates>marketing templates. Create an online form template. Add the html file
Proposal for updating the VRMA’s ready to return checkbox
Updating VRMA