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...
http://www.istechforum.com/YaBB.pl?num=1121133288

Message started by shengzhi on 07/11/05 at 17:54:48

Title: trying to find some fields...
Post by shengzhi on 07/11/05 at 17:54:48

i'm trying to find the fields of inventory quantity onhand and quantity on sales order. could anyone tell me where they are?

Title: Re: trying to find some fields...
Post by David Waldmann on 07/12/05 at 06:00:44

BKICMSTR, BKIC.PROD.UOH & BKIC.PROD.UOSO

Title: Re: trying to find some fields...
Post by David Waldmann on 07/12/05 at 06:02:11

PS: there is a very handy file available (free), I think somewhere on the ISTS main web site. It's an Excel file that lists every file and field in the DBA system. A lot of them have english interpretations as well.

Title: David is correct,Re: trying to find some fields...
Post by jhepola on 07/12/05 at 06:14:41

David is correct, but DBA also stores these values per location in BKICLOC (BKIC_LOC_UOH & BKIC_LOC_UOSO). Plus sometimes these values don't quite add up to that in BKICMSTR (mostly they do but some program glitches cause inconsistencies at times), thus the need for "Reconcile Inventory On-Hand" SM-J-C...

Title: Re: trying to find some fields...
Post by shengzhi on 07/13/05 at 13:24:05

thanx David, why i've never thought about Inventory Master-Accounting.. >:(
could you please also tell me where i can find that excel file u mentioned? cheers~~

Title: Re: trying to find some fields...
Post by shengzhi on 07/13/05 at 13:31:06

yes! i found it, that excel file !!
here's the link:
http://www.istechsupport.com/dl/dbafile.zip