Re: JBA ML - Entering physical inventory adjustments

This guy's from KI.  Doesn't matter but maybe we have a copy of those steps
we use on file that we could email him?

I think I've only seen a hard copy.

Mike

-----Original Message-----
From: Kincer, Alan <akincer@kiusa.com>
To: JBA listServe (E-mail) <JBAUSERS-L@midrange.com>
Date: Wednesday, January 02, 2002 9:00 AM
Subject: JBA ML - Entering physical inventory adjustments


>This message is in MIME format. Since your mail reader does not understand
>this format, some or all of this message may not be legible.
>--
>[ Picked text/plain from multipart/alternative ]
>
>
>Like to know if anyone has any ideas on entering the results of a physical
>inventory. I am retracing the steps of a predecessor (who is not
available).
>So far this is the completed work:
>
>1. Run a query to create a file that has the part numbers I need (in this
>case MRO-related only).
>
>2. Export the data to an Excel file and format to print into forms that
>workers can write-in their findings.
>
>3. Forms are given to entry clerk who keys results into original Excel
file.
>
>4. Excel file is emailed back to me:
>
>What I originally suspected was that that there is some SQL approach to
>mass-replacing the old totals with the new ones in INP35. However in
talking
>with others I find that there is apparently an adjustment made that is
>included in each part's movement history under 4/INE (from the previous PI)
>so whacking one number with another looks like a bad idea.
>
>An aside: If anyone knows how to view whatever data file(s) are in play
>during while a particular screen is up please advise. I know the program
>name is in the upper corner but I am curious about uncombing the myriad of
>interconnected data tables and their relationships.
>
>Thanks in advance
>
>Alan Kincer - MCP, A+
>MIS - KI(USA)
>501 Mayde Rd.
>Berea, Ky. 404075
>859.986.1420
>859.986.1485 (fax)
>mis@kiusa.com
>_______________________________________________
>This is the GEAC/JBA System 21 Users (JBAUSERS-L) mailing list
>To post a message email: JBAUSERS-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/jbausers-l
>or email: JBAUSERS-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/jbausers-l.
>
>