ISTech Support Forum - trying to find some fields. Inventory Location

Welcome, Guest. Please Login.

	05/06/24 at 16:56:46 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Crystal Reports, ODBC & Access › Crystal Reports General Issues

Pages: 1

trying to find some fields. Inventory Location (Read 1538 times)

rwest Browser I Love YaBB 2! Posts: 4	trying to find some fields. Inventory Location 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
Back to top	IP Logged

GasGiant Administrator How can I help? Posts: 1523 Gender:	Re: trying to find some fields. Inventory Location Reply #1 - 03/24/08 at 09:39:03 Try PIBINLOC.B or ISBINLOC.B
Back to top	IP Logged

rwest Browser I Love YaBB 2! Posts: 4	Re: trying to find some fields. Inventory Location Reply #2 - 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.
Back to top	IP Logged

GasGiant Administrator How can I help? Posts: 1523 Gender:	Re: trying to find some fields. Inventory Location Reply #3 - 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?
Back to top	IP Logged

rwest Browser I Love YaBB 2! Posts: 4	Re: trying to find some fields. Inventory Location Reply #4 - 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
Back to top	IP Logged

kevind Active Member I was more than willing to "pony up", how b'out U? Posts: 639 Gender:	Re: trying to find some fields. Inventory Location Reply #5 - 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.
Back to top	Kevin Damke Spectronics Corporation ISTECH 2004.1 7/26/13 SP1 - 20 user Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user (Prev version was 2004.1 10/24/12) (All Patches Installed as of 7/26/13) Pervasive 2000i SP4 - Crystal Reports V10 IP Logged

rwest Browser I Love YaBB 2! Posts: 4	Re: trying to find some fields. Inventory Location Reply #6 - 03/24/08 at 14:50:22 thanks!!!! That did it
Back to top	IP Logged

GasGiant Administrator How can I help? Posts: 1523 Gender:	Re: trying to find some fields. Inventory Location Reply #7 - 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
Back to top	IP Logged

Pages: 1

ISTech Support Forum › Crystal Reports, ODBC & Access › Crystal Reports General Issues