ISTech Support Forum - File Name for Inventory Usage

Welcome, Guest. Please Login.

	05/02/24 at 16:16:45 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

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

‹ Previous topic | Next topic ›

Pages: 1

File Name for Inventory Usage (Read 1062 times)

martel-carol

Member

Posts: 75

File Name for Inventory Usage
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?

IP Logged

GasGiant

Administrator

How can I help?

Posts: 1523
Gender: male

Re: File Name for Inventory Usage
Reply #1 - 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.

IP Logged

martel-carol Member Posts: 75	Re: File Name for Inventory Usage Reply #2 - 10/08/08 at 10:46:42 Yes I have. But I can't find the file name for inventory usage.
Back to top	IP Logged

GasGiant Administrator How can I help? Posts: 1523 Gender:	Re: File Name for Inventory Usage Reply #3 - 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.
Back to top	IP Logged

Pages: 1

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

‹ Previous topic | Next topic ›