JBA ML - Entering physical inventory adjustments

["Kincer, Alan" <akincer@xxxxxxxxx>]

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