Hello:

There is a composite table in GridView named "*OE Ord Detail with Head,IC".

However the IC fields are limited. In particular, we are looking for the On Hand figure.

Is there a composite table available (or in the backroom somewhere) that will do that?

Thank you.

Hi Bruce,

When I open this composite table and scroll to the very bottom, I see the 'Qty on Hand' field. Do you?

If not, this calculated value is the sum of the 5 Quantity fields from the costing lots. If you don't use LIFO/FIFO costing, then all you need is the first costing lot field 'I/C Item Qty on Hand 1'. If LIFO or FIFO is in use, then a calculated column to add all 5 of these fields will do the trick.

Hello:

No I don't see any Qty fields (not a single nor the lots). My bottom fields in the list are:
-I/C Item Std Cost
-I/C Item Weight Unit
-I/C Item Tax Status
-I/C Item User Defined Cost 1
-I/C Item User Defined Cost 2

GV 8.1 (071008)

Can I download an updated file(s)?

Thank you.

Oh yeah, for some reason that I am not aware of, all of the fields after 'I/C Item User Defined Cost 2' are marked as Hidden in the composite table dictionary. If you use the switch to show all fields, you will be able to see the remainder of the IC Item fields.

Perfect!

Thank you.