Is there a way to search OE for Items that were invoiced today, before day end has been processed? We have a problem where the inventory on a certain item is down but the transaction history that shows where the inventory went doesn't appear until after day end is completed. We regularly have to search every Invoice in OE that was invoiced today in an effort to figure out who the product was sold to. With 50 or more Invoices a day with multiple lines per invoice, it is a very tedious manual process. Is there a way to search OE for an item in today's invoices?

Hi Susan,

Inventory items store a value called 'Qty Shipped not Costed', which represents the qty of items sold but not yet processed by OE Day End. You could create a filter in IC that selects all items with a value for this field not equal to zero. Or use a SmartFinder for IC Items with the same criteria. This doesn't list the invoice on which the item appears, just which items are outstanding.

This method isn't completely bullet-proof, in the case where an item has been shipped and also credited, with the net qty equal to zero.

You might also be able to search OE invoices where the 'Costed status' is false, and then look for the items belong to these invoices, in a GridView workspace. I don't believe that the Costed status is stored on the invoice details, which is why this inquiry has to be driven from the invoice level.

Which method would work better for you depends on what information you are looking for - just the list of items, or which invoices/customers belong to those sold items.