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?

Hi Laura:

To add one thing to Support's comments, that path looks perfectly correct .. if Adagio is installed on your own PC. In other words, if you are using Adagio through a local area network, we would expect to see a letter other than C: (i.e. F: or G:).

If you aren't certain, check the icons for the other modules that do work and change the drive letter on the GV icon to match those.

After some thought, I think I know what happened: The instruction "C:\Softrak\GVWIN\GVWIN.exe /c /a" provided by Support was an example. It was the "/c /a" part that they suggested be added to whatever the existing path was. If you replace C: with the same drive letter from the other icons, you will be back in business.

yes this is where the program originates from...and i only get the error if i add the /a or /c....i don't get the error normally

thanks

i run the programs from my computer on the c drive...so now i am confused on how to get the /a to work?

Laura:

I would like to suggest that you get your Adagio Consultant Reseller to give you some pointers on how to maintain and modify program short cuts.

There must be a space between the EXE and the command line parameters and a space between the parameters themselves. As a note, "/a" exposes all of the fields in a table and is not for the faint of heart (that's why it's an option).

If setting a program shortcut is beyond your "comfort zone", then I might suggest asking someone to give you a hand over the web.

sorry.....i read make sure there is not a space....thanks for your patience....my reading capabilities need improvement. i will be more careful in the future.
again thank you all for your patience and help.