How can I make a Gridview that shows all items sold on OE Invoices today? Since we can't see the transaction history in IC until after OE day end, we need a method to see what items have come out of stock on the current day.

Hi Susan,

Probably the fastest way it to Filter the Item list to display items where the field "shipped not costed" is not equal to 0. This can be done in GridView or a simple Item Filter in Inventory.

Thanks Andrew,

I think I'm getting it using table OE Ord Detail /w Head, Head Ext and then adding related column Ship not costed from IC. I'm trying to reference the Invoice or Credit number.

Hi Susan,

That'll work. However, it would be faster just to check the flag in the Sales Order Header that indicates whether costing has been done ("Costed Status"). It will be TRUE() if the invoice/credit note has not been run through day end.

It depends a little on the ultimate list you are trying to create. If it is just a list of items, then hitting the item master alone will be much faster than going through OrderEntry.

If you just want information of the Invoice header, then use the "Costed Status" in the sales order header.

You can validate the information you are seeing by checking the "shipped not costed" field as well, but linking across three files (order details, order header and inventory master) is fairly disk intensive.

Hi Andrew,

Why would the items that have already been run through day end have a quantity in "shipped not costed"? Don't they get costed when they are run through day end?

Because another invoice, which has not yet been run through day end, includes the item. If you are looking at the Sales Order detail lines, then you need to check the "Costed Status" for the order.

Thanks Andrew,

What am I doing wrong on this filter:

TRIM({Costed Status}) = "True"

Evaluation failed.

"Costed Status" is a Boolean and therefore equal to TRUE() or FALSE(). This means that you can say:

or, if you find that hard to read:
or

Thanks! 8-)