Map Reduce Script to map the least expiration date from inventory detail record to the item record cutsom fields.

We need to show the expiration date for each item on PLP Page. The value of the field will be from the inventory detail record. Since the Item Record and Inventory Record are two individual records, we can’t get it directly in SCA website. So, we have mapped the value of the expiration date from… Continue reading Map Reduce Script to map the least expiration date from inventory detail record to the item record cutsom fields.

Solution for making the Expiry Date field as a mandatory.

As we cannot set the field ‘Expiration Date’ mandatory via the NetSuite UI, we can use a User Event script as an alternative. This script can be deployed in two records, such as item receipt and inventory adjustment. The following script is designed to prompt the user prior to saving a record if the ‘Expiration… Continue reading Solution for making the Expiry Date field as a mandatory.