Build a report for approved bills where quantity received is less than quantity billed

AI generated answer (using internal Slack threads):

To build a report for approved bills where the quantity received is less than the quantity billed, you can create a saved search in NetSuite. Here are the steps: 1. Navigate to

Reports > New Search

. 2. Select

Transaction

as the record type. 3. On the

Criteria

tab, add the following filters: -

Type

is

Purchase Order

-

Status

is

Purchase Order: Approved

-

Main Line

is

False

(to include line items) 4. On the

Results

tab, add the following fields: -

Document Number

-

Item

-

Quantity

-

Quantity Billed

-

Quantity Received

5. Add a

Formula (Numeric)

field with the formula

NVL({quantity},0) - NVL({quantityreceived},0)

. This will calculate the difference between the quantity billed and the quantity received. 6. Set the

Summary Type

of this formula field to

Sum

to get the total difference for each bill. 7. Save and run the search. This will give you a report of all approved bills where the quantity received is less than the quantity billed. You can further customize this search to suit your needs. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******