RE: Erroneous Balances in ILI/IWI

        Thanks to great help, I now have determined that an incorrect
inventory balance is created for a Kit whenever the Kit is shipped and the
location selected for the resulting B and = transactions is one for which no
record exists in ILI. A new ILI record is created and the BPCS program
brings into the new ILI record the sum of 1)the issues FROM THE PREVIOUS ILI
RECORD processed and 2)the issue quantity of the B transaction. 

        So now I have about one hundred balances to correct.

        HOWEVER - I still have two other problems with erroneous ILI
balances, some of which are not related to Kit transactions.

        Problem Two is: the mystical  appearance of an ILI record for an
item number several months after the last transaction for the item. Example:

        One item was built on a shop order in December 1999, and shipped the
same month. No transaction was processed for it after December. In February,
an ILI record appeared for a quantity of 1 and this added into the on-hand
balance (probably at month-end). The location selected was the location from
which it had been shipped.  This would not have noticed if it hadn't been
for a forklift truck, our primary product. 

        Problem Three is: The total of ILI on hand quantities does not equal
the on hand in the IWI file. It is definitely true that the original Kit
problem one generates some of these imbalances - during the month in which
they occur. Then at the end of the month, IWI gets synchronized with ILI (to
the incorrect ILI balance).  However, this is only one source of this
problem. I have seen many references here to having to run a synchronization
program - and we have run it too, but, as the Kit situation proves, the
result is wrong.  

        Does anyone have some other sources of (or solutions to) Problems
Two and Three?

        Dick Bailey
        MCFA



                -----Original Message-----
                From:   Bailey, Dick [mailto:Dick_Bailey@MCFA.com]
                Sent:   Friday, May 19, 2000 9:25 AM
                To:     BPCS-L@MIDRANGE.COM
                Subject:        Erroneous Opening Balances in ILI



                        We're on 6.1 BPCS - and are finding this problem.
Can anybody help
                us figure out what to do?

                        At the end of each month after running the month end
summarizing of
                inventory balances, we see erroneous opening balances. For
example, on a
                part that had no inventory (ILI) records on 1/1, and had
only these
                transactions during January:

                        B transaction -1 from location P04E
                        = transaction  +1 to location P04E
                        B transaction -1 from location PICK
                        = transaction +1 to location PICK

                on 2/1 we got ILI records like these:

                        Location P04E    -98
                        Location PICK    -194

                Most of the cases we have identified so far are associated
with allocated
                kit transactions like these, but there others that have
taken place when
                there is no intervening transaction at all.

                        Dick Bailey
                        MCFA, Inc

                +---
                | This is the BPCS Users Mailing List!
                | To submit a new message, send your mail to
BPCS-L@midrange.com.
                | To subscribe to this list send email to
BPCS-L-SUB@midrange.com.
                | To unsubscribe from this list send email to
BPCS-L-UNSUB@midrange.com.
                | Questions should be directed to the list owner:
dasmussen@aol.com
                +---
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---