//Info: NTPL- 445 We can preview NetSuite data and transfer it to a third-party database using the ODBC Driver.We need to verify some cases before proceeding with this process. 1. We’re assuming you planned on collecting the posting transactions. Do you intend to retrieve any additional types? (These types of records are typically accessible as… Continue reading Things to check before transferring NetSuite data via ODBC driver
Author: Bibin Thomas
Service item fulfillment is possible?
//info: CDUS-1042 By setting certain fields in the associated item, we can transform service items to make them fulfilled directly through the script. Related Article to do so:http://jobinandjismi.in/service-sale-items-to-resale/ We can also set this through the UI to fulfill the order.To accomplish this, we must enable the Fulfill feature in the relevant Item. Note:Service items are… Continue reading Service item fulfillment is possible?
Displaying the availability of items on a sales order from a warehouse
//Info: CDUS-1010 REQUIREMENT Would NetSuite be able to show us how many items we have in both warehouses at the same time when we type the SKU? So, when we are entering orders, the system automatically shows us how many items we have in either Miami or Dallas warehouse depending on the primary location or… Continue reading Displaying the availability of items on a sales order from a warehouse
Proposal for Showing Availability of Items on Sales Order from Both Warehouses.
PROPOSAL SUMMARY This Proposal is to show the availability of items on a sales order in the item Sublist. When an item is selected, the item count will be displayed based on the primary location opted initially. Here, we add an additional column that will display the availability for both the warehouses REQUIREMENT Would NetSuite… Continue reading Proposal for Showing Availability of Items on Sales Order from Both Warehouses.
Add Button based on Record Status
//Info:APCN-214 Instead of applying to every record, we may need to add buttons to record pages that only apply to specific statuses such as Open, Processing, and so on.In this case, we created a Button to Quote record that will appear only if the status is not Voided & Expired.
Attach a file from a previously produced file via email
//Info: HL-174 We encountered a scenario in which we had to save the errors generated to the file cabinet as a CSV file and then attach this file to the specific email id provided.
Change Tracking number value from Package sublist in IF record
//Info: HL-140 Changing Sublist fields does not always operate as expected in some circumstances.One example is updating the tracking number in the Item Fulfillment record. Along with the regular rec.setCurrentSublistValue, we must include rec.selectLine and rec.commitLine routines as this field change dynamically.
Add corresponding Invoice Balance in Customer Statements
//info: CDU-949 In most cases, statements are generated based on records such as INV, Credit Memos, and Payments.The system counts the credits and overpayments on top and displays the results in the Balance field. Solution:We have created another column for showing the balance for each row.
Mandatory Filters to be added while updating an IF Record
//Info: HL-139 There are chances to have multiple Item Fulfillment records with the same internal id but hold some values differently.In order to make it more clear, it’s better to add these filters to the search criteria.
Setup connection between HubSpot & NetSuite
//info: VCPL-15 Initially, you have to create an account in Hubspot.Then, Install Netsuite from App Marketplace. Make sure that you enable Soap web services, REST web services, Token-based authentication, Server Suitescript in NS Enable features section. Install HubSpot Sync Bundle from Customization > SuiteBundler > Search & Install Bundles. Assign HubSpot Sync role from Lists > Employees > Employees > Search Role >… Continue reading Setup connection between HubSpot & NetSuite