Re: JBA ML - Entering physical inventory adjustments -- SYSTEM21


Hi Alan,

I used a simular approach when I was doing a data take on for a company that we
had taken over.

I had already setup the items and stockrooms on INP35 and INP60

So I created a count using standard stock take processes on menu INS

I then updated the fields QTEA75 and QTEA77 on INP75 and INP77 from the value in
an Excel spreadsheet using Microsoft Access (which used the standard Client
Access ODBC driver)

I then completed the lists, ran variance reports and ran the final update all
using the standard options on INS menu.

Regards,
Gary.






"Kincer, Alan" <akincer@kiusa.com> on 02/01/2002 11:59:57 pm

Please respond to jbausers-l@midrange.com

To:   "JBA listServe (E-mail)" <JBAUSERS-L@midrange.com>
cc:    (bcc: Gary Brown/Applied Chemicals Pty Ltd)

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.