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:email@example.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) firstname.lastname@example.org _______________________________________________ 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-Lemail@example.com Before posting, please take a moment to review the archives at http://archive.midrange.com/jbausers-l.