Requirement :
Client would like to add a script that automates two CSV imports into a custom record, which should run once every day at 9:00 PM. The script should:
- Create a new “Bin Enhancement” record if the “Bin Enhancement Bin” column is empty in the CSV import.
- Update the “Bin Enhancement” record if the “Bin Enhancement Bin” value is different from the “Preferred Bin” value, setting the “Bin Enhancement Bin” value to match the “Preferred Bin” value.
Current Functionality:
Currently the file containing item details is creating using following saved search.
Saved search: Preferred Bin – Bin Enhancement Check
Using the data from the saved search, the client performing 2 imports to create and update the “RF-SMART Item Bin Enhancement” custom records.
Import for Bin Enhancement creation:
If column Bin Enhancement Bin is empty in the file, new “RF-SMART Item Bin Enhancement” custom record will be created using import.
Import for Bin Enhancement Update:
If the Bin Enhancement Bin value is different from the Preferred Bin in the item record, the “RF-SMART Item Bin Enhancement” custom record will be updated to match the Preferred Bin Value
using CSV import.
Functionality Needs to be implemented:
The client would like to implement automation to create Bin Enhancement custom records in NetSuite instead of manually importing the files.
If the inventory item satisfies the conditions in the mentioned saved search, the “RF-SMART Item Bin Enhancement” custom record needs to be created or updated.