Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
sales orders invoiced but not fulfilled, at a particular date
does anyone know how to get a search/report of sales orders that were invoiced, but not fulfilled, at a particular date?
the reason is: at the end of each month we want to get a figure for the amount of sales to move to deferred income - ie the sales we've invoiced, to get payment in advance, but haven't fulfilled and thus can't recognise in the P&L
i can create a search (shown below) that finds all the sales order line items that are either invoiced before X OR fulfilled after X, which is a superset of what i want, but i can't do an AND - it returns nothing, because the search is returning two rows for each sales order line item, one row for the invoice and one row for the fulfillment.
0