Re: JBA ML - Entering physical inventory adjustments

Please disregard this inadvertant post.  This was intended for a coworker in
an attempt to assist Mr. Kincer.   Maybe I could use JBA better, if I'd
learn email 1st! :)

Sorry,
Mike

-----Original Message-----
From: Mike Von Stein <vonstein@wcoil.com>
To: jbausers-l@midrange.com <jbausers-l@midrange.com>
Date: Wednesday, January 02, 2002 10:53 PM
Subject: 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.
>>
>>
>
>_______________________________________________
>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.
>
>