Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Purchase Order Accrual Search
I feel crazy for having to create this topic, but it seems it does not already exist.
I'd like to create a Purchase Order Accrual search that we can run at month-end to show us all the Purchase Order (PO) Lines that we have received more than we have been billed (Formula: {quantityshiprecv}-{quantitybilled} is greater than 0)
The problem is we have some Expense Lines where Qty does not exist, just an amount. There is an amount on the item receipt transaction, but no amount received on the PO transaction. We could potentially have multiple receipts on an item line or an expense line of the PO.