ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Crystal Reports General Issues >> trying to find some fields. Inventory Location
http://www.istechforum.com/YaBB.pl?num=1206370608

Message started by rwest on 03/24/08 at 07:56:48

Title: trying to find some fields. Inventory Location
Post by rwest on 03/24/08 at 07:56:48

I have a simple Crystal Report using the INVTXN table to count number of issues. I was asked to add the bin location to this report and have searched and searched but cannot find where this data is stored. I can only see this data in IN-A. Any ideas what table this is stored in?? :-/

Thanks in advance,

R West

Title: Re: trying to find some fields. Inventory Location
Post by GasGiant on 03/24/08 at 09:39:03

Try PIBINLOC.B or ISBINLOC.B

Title: Re: trying to find some fields. Inventory Location
Post by rwest on 03/24/08 at 09:50:01

Thanks for trying but I don't have those tables. I believe we are using "Classic" I have no idea if that makes a difference.

Title: Re: trying to find some fields. Inventory Location
Post by GasGiant on 03/24/08 at 11:05:21

What version are you on? When was the last time you rebuilt your DDFs? If you go in through Maintain Database do you find those tables?

Title: Re: trying to find some fields. Inventory Location
Post by rwest on 03/24/08 at 12:37:29

version 2004.1 I don't have access to maintain database but I will ask the admin to check for those tables. DDF looks like they were created march of '07

Title: Re: trying to find some fields. Inventory Location
Post by kevind on 03/24/08 at 14:13:51

The Bin Location listed on the IN-A screen is MTIC_PROD_LOC in the MTICMSTR table.

Hope this helps.

Title: Re: trying to find some fields. Inventory Location
Post by rwest on 03/24/08 at 14:50:22

thanks!!!! That did it ;D

Title: Re: trying to find some fields. Inventory Location
Post by GasGiant on 03/25/08 at 03:34:52

I suppose I should have asked if they had bin locations turned on. That's what you get when you assume ::)