Is there a table that will give me:

* Item #
* Qty on Hand
* Location
* Last Receipt Date
* Last Ship Date

I need a report to show dead stock at our other branches.

I can use I/C Items (1,3) Master for a dead stock list but I can't break it down by location.

Or I can use *IC Item Loc w IC Item but then I can't view the Last Receipt Date or Last Ship Date.

Hi Susan,

It seems that many of the fields in the 'IC Item Loc w IC Item' are set as 'hidden'. If you add /a to the end of the target path on the shortcut you use for starting GridView, this will display All fields, including those that are hidden.

You will see other additional information including internal dictionary names, and table sorting may be different and look strange, but you can get all the fields you need. Once the view is created and saved, you can remove /a from the shortcut to get back to the normal appearance.

Hi Susan,

I've asked that these fields be "unhidden" in the next release of Inventory/GridView. With composite tables we hide many of the fields, otherwise the resulting field list is overwhelming.

WOW!!! /a is great.

I was reading your thread. I am trying to learn to use gridview to make reports better for my client. I went to the short cut, target path and put /a at the end (after .exe) and it says that the path is not valid. What am i doing wrong.

thanks
Laura

Make sure that there is a space between the exe and the /a. Also make sure that there is no space between the / and the a.

EG. C:\softrak\gvwin\gvwin.exe /c /a
Will allow Create access and list All fields

thanks for the quick reply....i did exactly what you said but it came up incorrect. I am using windows vista.....does it have something to do with that?

Hi Laura:

Please open the GV icon, highlight everything in the "Target" field, copy it and paste it into a message here in the Forum.

C:\SOFTRAK\GVWIN\GVWin.exe
thanks bruce
is it because the letters are not all small?

Captilatization does not matter. Neither does vista.

Is this the location of where Adagio GridView is installed? Can you see this with Windows Explorer? Also, do you get the error as is without the /a or /c parameters?