i need to find POs where the amounts on the item receipts are greater than what's on the PO. which report should I create?

AI generated answer (using internal Slack threads):

To find Purchase Orders (POs) where the amounts on the item receipts are greater than what's on the PO, you can create a custom report or saved search in NetSuite. Here's a general approach: 1. Go to Reports > New Search. 2. Select Transaction as the record type. 3. On the Criteria subtab, set the following filters: - Type is Purchase Order - Status is Purchase Order: Partially Received or Purchase Order: Received 4. On the Results subtab, add the following fields: - Document Number (this is the PO number) - Amount (this is the PO amount) - Quantity (this is the PO quantity) - Received (this is the quantity received) 5. Add a formula (numeric) field with the formula

{quantity}-{received}

. This will calculate the difference between the PO quantity and the received quantity. If the result is negative, it means the received quantity is greater than the PO quantity. 6. You can also add a formula (currency) field to calculate the difference in amount if needed. Remember to enable the account preference

Allow Overage on Item Receipts

(Setup > Accounting Preferences > Order Management) to allow over-receiving. Also, consider implementing the Match Bill to Receipt and the Post Vendor Bill Variances Process to handle variances between item receipts and bills. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******