ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Crystal Reports General Issues >> File Name for Inventory Usage
http://www.istechforum.com/YaBB.pl?num=1223483595

Message started by martel-carol on 10/08/08 at 09:33:14

Title: File Name for Inventory Usage
Post by martel-carol on 10/08/08 at 09:33:14

I am trying to devise a report for items on hand, on purchase order, usage, primary vendor,. I have BKIC.PROD.UOH and BKIC.PROD.UOO and MTIC.PROD.VNAM. But I can not find the file name for usage.

I have a list of file names from 2007 with their fields, but the fields must have been updated since then. Does anyone know where I can get an updated listing of the fields?

Title: Re: File Name for Inventory Usage
Post by GasGiant on 10/08/08 at 09:50:09

Those field names are fine. The bkic fields are in BKICMSTR and the mtic are in MTICMSTR. The Excel file with the field names is correct.

I am assuming that you have built the ODBC DDFs for the company in question, and that your are replacing the dot (.) with an underscore in the names of the fields (e.g. bkic_prod_uoh) when building your queries.

Title: Re: File Name for Inventory Usage
Post by martel-carol on 10/08/08 at 10:46:42

Yes I have. But I can't find the file name for inventory usage.

Title: Re: File Name for Inventory Usage
Post by GasGiant on 10/08/08 at 10:49:30

oh, I get it. ::)

INVTXN has all inventory transactions... no wait, do you just want the summarized usage numbers for the past twelve months? Just use a group to summarize months. I don't think those numbers are stored anywhere.

Maybe I still don't get it. :-?