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

Welcome, Guest. Please Login.

	05/10/24 at 07:39:58 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... (Read 1098 times)

shengzhi Browser I love YaBB 1G - SP1! Posts: 7	trying to find some fields... 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?
Back to top	IP Logged

David Waldmann Active Member Live to work, or work to live? Posts: 1924 Gender:	Re: trying to find some fields... Reply #1 - 07/12/05 at 06:00:44 BKICMSTR, BKIC.PROD.UOH & BKIC.PROD.UOSO
Back to top	David N Waldmann President Vermont Hardwoods Chester, VT Evo-ERP, 5 user IST Build: 3/4/19, patched 04/30/19 Pervasive v11.31 Server 2012 / Win10 x64 Crystal Reports v11 IP Logged

David Waldmann Active Member Live to work, or work to live? Posts: 1924 Gender:	Re: trying to find some fields... Reply #2 - 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.
Back to top	David N Waldmann President Vermont Hardwoods Chester, VT Evo-ERP, 5 user IST Build: 3/4/19, patched 04/30/19 Pervasive v11.31 Server 2012 / Win10 x64 Crystal Reports v11 IP Logged

jhepola Browser Is this corn hand-shucked? -- Bob Wiley Posts: 26 Gender:	David is correct,Re: trying to find some fields... Reply #3 - 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...
Back to top	John Hepola TechnoResources Inc. IP Logged

shengzhi Browser I love YaBB 1G - SP1! Posts: 7	Re: trying to find some fields... Reply #4 - 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~~
Back to top	IP Logged

shengzhi Browser I love YaBB 1G - SP1! Posts: 7	Re: trying to find some fields... Reply #5 - 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
Back to top	IP Logged

Pages: 1

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