RE: JBA ML - Entering physical inventory adjustments

[jroesch@xxxxxxxxxxxxxxx]

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 ]
You should consider the Physical Inventory or Cycle Count module for your
Inventory process.


-----Original Message-----
From: Kincer, Alan [mailto:akincer@kiusa.com]
Sent: Wednesday, January 02, 2002 9:00 AM
To: JBA listServe (E-mail)
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.