how can i list all items that are in pounds, i need to convert to kg

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To list all items that are in pounds and need to be converted to kilograms, you can create a saved search in NetSuite. Here are the steps: 1. Navigate to

Reports > Saved Searches > All Saved Searches > New

. 2. Select

Item

from the list. 3. In the

Criteria

tab, add a new criterion:

Weight Unit

is

lb

. 4. In the

Results

tab, add the fields you want to display, such as

Name

,

Weight

,

Weight Unit

, etc. 5. Save and run the search. This will give you a list of all items that are in pounds. For the conversion part, you can create a client-side script that runs on the item record. This script would check the

Weight Unit

field, and if it's

lb

, it would convert the

Weight

field to kilograms using the conversion rate (1 lb = 0.453592 kg). Please note that this solution assumes that you are using the native NetSuite

Weight

and

Weight Unit

fields. If you are using custom fields, you would need to adjust the script and saved search accordingly. Also, keep in mind that this solution does not change the actual data in NetSuite, it just provides a way to view the weight in kilograms. If you need to permanently convert the weight to kilograms, you would need to update the item records, which could be done via a mass update script or manually.