- This will be helpful when user time format is in hh:mm AM/PM
- Follow the bellow steps to create a custom field that will convert the time am/pm to 24 hour time.
- Create the Time field.
- Go to Setup – Customization – Lists, Records, & Fields – Entity Fields – New.
- Enter label for the field.
- Set Type as Time of Day.
- Check the Store Value field.
- In the Applies to tab – select the record this field should be applied. For example: select Customer.
- Click Save.
- Create the second field that will convert the time am/pm to military time.
- Go to Setup – Customization – Entity Fields – New.
- Enter label for the field.
- Set Type as Free-Form text.
- Uncheck the Store Value field.
- In the Applies to tab – select the record this field should be applied. For example: select Customer.
- In the Validation & Defaulting tab – Default Value = “to_char({field ID in step A},’hh24:mi’)” and check the Formula field.
- Click Save.
Trick to convert a custom field from am/pm time to 24 hours format
Topics: Customization, ERP
At one point or another, most organisations consider implementing NetSuite to increase efficiency in their business operations. These organisations will require assistance from an experienced NetSuite partner. Planning and establishing a long-term working relationship with right NetSuite partner will help with internal adoption and increase the likelihood of a successful NetSuite ERP implementation. It’s very easy for a vendor to walk you through how NetSuite system completes specific tasks. But what does it look like for your business? Preparing a script with a few business processes that the vendor will work through the NetSuite system not only ensures they understand your requirements but helps you to see if the system will really work for you (and possibly improve your processes).
Topics: Customization, ERP, NetSuite
When custom field type is changed, the values stored in that field will be lost due to the change since most field types do not hold the same value.
Note: After field type was changed, logs on the System Notes will be deleted for this field due to the change so there will be no way of retrieving the value of the field.
Example 1: If custom field type is changed to Currency from Integer Number, New field has the value of old field.
Example 2: If a custom field type is changed to Integer Number from Phone Number, Old field value gets deleted.
Topics: Customization, ERP
Trick to override the preferred vendor for the Drop Ship Purchase Order
In General while creating a Sales order for Drop ship items, preferred vendor is automatically assigned to related Purchase order. Later on we can able to open the Purchase order and change the Vendor name.
Topics: Customization, Cloud ERP
In order to use drag and drag functionality in NetSuite first install the following bundle by navigating through Customization–> SuiteBundler –> Search and Install Bundles.
Bundle Name: File Drag and Drop
Bundle ID: 41309
Step 1:
Step 2:
1. Notice that after installation there will be a new center category added under documents folder. Drag and Drop files –> File Cabinet
2. After installation Drag and Drop feature will be available for all employees in the company, but still under Home –> Set Preference –>Custom preference there will an option for employees to enable/disable the feature in user account.
Step 3:
Navigate to Setup —> Customization –> File Drag and Drop Setup and set default preferences like.
1. Setting up default folder
2. Enabling for this feature for different record types.
3. Click on Save & Next and Finish
Advantages
1. Single time multiple files can be uploaded
2. Upload files directly from fields
3. Users can drop files to line level
Note:
1. Ensure to have files tab on form level, if files tab is removed drop zone area will not appear.
2. File size should not exceed 10 MB
Topics: Customization, CRM, NetSuite