Maintaining accurate and complete item data is essential for ensuring smooth operations across sales, purchasing, and reporting. One common issue administrators face is incomplete item records—especially items missing descriptions, which can lead to confusion for users entering orders or reviewing data.
To help identify such records, you can use the following SuiteQL query. This script pulls all Sale and Purchase item records where both the description and purchasedescription fields are empty:
Select *
from item
where (
(subtype='Sale' or subtype='Purchase') and
(description is null and purchasedescription is null)
);
This Query Does:
- Filters for items that are classified as either Sale or Purchase items.
- Returns only those where:
- description (used in sales forms and customer-facing documents) is null
- purchasedescription (used in purchase orders and vendor communications) is also null
Items with missing descriptions may not display clearly on transaction forms, which can lead to confusion for users during sales or procurement processes. Additionally, incomplete item information might negatively impact external documents such as quotes, purchase orders, and invoices.
To easily execute a SuiteQL query, see NetSuite Admin Tip | Running SUITEQL Using a Suitelet
The sample code described herein is provided on an "as is" basis, without warranty of any kind, to the fullest extent permitted by law. Oracle + NetSuite Inc. does not warrant or guarantee the individual success developers may have in implementing the sample code on their development platforms or in using their own Web server configurations.
Oracle + NetSuite Inc. does not warrant, guarantee or make any representations regarding the use, results of use, accuracy, timeliness or completeness of any data or information relating to the sample code. Oracle + NetSuite Inc. disclaims all warranties, express or implied, and in particular, disclaims all warranties of merchantability, fitness for a particular purpose, and warranties related to the code, or any service or software related thereto.
Oracle + NetSuite Inc. shall not be liable for any direct, indirect or consequential damages or costs of any type arising out of any action taken by you or others related to the sample code.
We’d love to hear how you integrate SuiteQL into your NetSuite processes! Share your insights and experiences in the NetSuite Admin Corner.