need to do a suitesql query that goes for the item receipt records and gets every record that is a partial receipt and not a complete of its item lets say you have a inbound shipment or purchase order that has item a - qty 1000 item b - qty 2000 if you have a item receipt : item a - qty 1000 item b - qty 1800 this rec has to apear in the search if you have a item receipt: item a - qty 1000 this rec DOESN't have to appear (it is a full receipt of item a)

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that you can create a SuiteSQL query to find item receipts that are partial and not complete by comparing the amount fulfilled/received to the amount billed. This would need to be done at the detail line level, so you would need to set Main line to False. You can create a saved transaction search with the following criteria: - Type = PO - Mainline = False - Status = Purchase Order:Partially Received, Purchase Order:Fully Billed, Purchase Order:Pending Billing/Partially Received - Applying Link Type = Receipt/Fullfillment This allows you to segregate the receipts only against the PO since vendor bills are also applying transaction for the PO too. For non-inventory purchase orders, you can fudge with your quantity to be able to do partial receipts. For example, don't order "services 1, for $5000 and receive 3600 of it. Order Services 5000 for $1, and receive 3600 of it instead. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******