Trick to convert a custom field from am/pm time to 24 hours format

Posted by CuriousRubik on 01 Sep, 2015
  • 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.
Read More

Topics: Customization, ERP

NewYork NetSuite Implementation Services

Posted by CuriousRubik on 01 Sep, 2015

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).

Read More

Topics: Customization, ERP, NetSuite

Field behaviors when Field types are changed

Posted by CuriousRubik on 01 Sep, 2015

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.

Field-behaviors

 

Field-behaviors-changes

Read More

Topics: Customization, ERP

Trick to override the preferred vendor for the Drop Ship Purchase Order

Posted by CuriousRubik on 01 Sep, 2015

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.

Read More

Topics: Customization, Cloud ERP

NetSuite Drag and Drop Files

Posted by CuriousRubik on 01 Sep, 2015

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: 

Drag-and-Drop-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.

Drag-and-Drop-23. Click on Save & Next and Finish

Advantages

1. Single time multiple files can be uploaded

2. Upload files directly from fields

Drag-and-Drop-3

3. Users can drop files to line level

Drag-and-Drop-4

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

Read More

Topics: Customization, CRM, NetSuite

Featured E-Books

  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik
  • NetSuite CuriousRubik

Follow Us

twitterfacebook3linkedin1google_plus2play125


 

badge Original

We are proud to announce that we have been awarded the Prestigious Partner Of the Year Award @ NetSuite SuiteWorld, a global event of NetSuite with over 7000+ attendees and hundreds of partners. CuriousRubik is humbled and honored to win this award, and motivated to continue developing SuiteApps and delivering best in class NetSuite services globally.