Fields in NetSuite store values in different data types, such as STRING, INTEGER, and FLOAT. String- text values, such as a customer name Integer- positive or negative whole numbers that do not contain a decimal, such as counts Float- numeric values that can contain a decimal, such as amounts Some fields need to be cast… Continue reading Casting Field Values using TO_NUMBER and TO_NCHAR
Author: Karishma Krishnadas
How to prevent the HTML content from being displayed in saved search results
Go to Navigates the General Preferences and Check the below mentioned checkbox to prevent HTML content from being displayed in saved search results.
Auto-calculation of reorder point and preferred stock level
For Items that use Advanced Inventory Management to calculate demand, there are cases that auto-calculated inventory metrics may not be accurate if the sample of data does not match the order analysis interval. This could occur in the following cases: Account is new and user has no sales history data entered. New Item Records have no sales history data.… Continue reading Auto-calculation of reorder point and preferred stock level
HTML Form – Phone Number validation
We validate a phone number of 10 digits with no comma, no spaces, no punctuation and there will be no + sign in front the number. Simply the validation will remove all non-digits and permit only phone numbers with 10 digits. Here is the function. To valid a phone number likeXXX-XXX-XXXXXXX.XXX.XXXXXXX XXX XXXXuse the following… Continue reading HTML Form – Phone Number validation
How to perform form validation for a required field in HTML
The form data is very important for a website and it is necessary that the correct form data or valid form data is submitted to the form. In order to make sure that the form data is valid or to make an input field mandatory, various attributes can be used. Required Maxlength Minlength Min and… Continue reading How to perform form validation for a required field in HTML
Shopify Fulfillment Orders API
The FulfillmentOrder resource represents either an item or a group of items in an order that are to be fulfilled from the same location. There can be more than one fulfillment order for an order at a given location. Fulfillment orders are created automatically when an order is created. We can retrieve all fulfillment orders related to a given… Continue reading Shopify Fulfillment Orders API
NetSuite Connector Syncs
NetSuite Connector enables to work with following syncs: Product Sync Product sync synchronizes data from NetSuite to the storefront. This enables us to maintain items and inventory numbers in multiple storefronts by using NetSuite as the primary data. Enable Product sync in NetSuite connector. Create test item in NetSuite. Sync the test item to… Continue reading NetSuite Connector Syncs
NetSuite Amazon Connector
NetSuite Amazon Connector Specifically, the Amazon NetSuite connector is customized to your company needs to ensure that you only concentrate in achieving your business goals whilst using the cost effective, hassle free, stable, highly efficient and secure connector service. This connector is the perfect way of connecting the Amazon Seller Central to the web store… Continue reading NetSuite Amazon Connector
How to Detect a Mobile Device with JavaScript?
1.User Agent Detection One way to check for a mobile device is to check the user agent. This isn’t the best way to check if a user is using a mobile device since user agent strings can be spoofed easily. However, it’s still an easy way to check what device is being used by the… Continue reading How to Detect a Mobile Device with JavaScript?
Display Safety Stock on the Transaction Saved Search
Navigate to Reports > Saved Searches > All Saved Searches > New Search Type: Select Transactions Click Results subtabNote: For every required field use the drop-down menu to select it and once adjusted click Add if needed. Select Item Fields… Select Location Preferred Safety Stock Level Select Item Fields… Select Location Click Save & Run