RE: IWI and ILI Imbalances

["Bailey, Dick" <Dick_Bailey@xxxxxxxx>]

        What we have sounds different - the resulting inventory balance is
correct in either ILI or IWI but not both.  Here are two specific examples:

        #1 - Item G3KFC/3404770, for which no ILI or IWI record existed on
6/1, we had:

        PR transaction for a quantity of 1 on 6/13.

        Result was Receipts of 1 in both the IWI and ILI records, and a
total of -1 Adjustments in the IWI record. 

        No other transactions prior to this one.  ILI shows one on hand, IWI
shows zero.

        #2 - Item 9542703010, for which on 6/1 there were no ILI records,
and an IWI record containing zero opening balance, zero adjustments, zero
receipts and zero issues.

        On 6/22 we had a B transaction for 2 and a = transaction for 2 (We
shipped this kit) - and ended up with an ILI record containing Issues of 2
and Receipts of 2.  The IWI record, however, had Receipts of 3 and Issues of
2.  So ILI showed zero on hand but IWI showed -1. 

        No previous transactions since 3/22.

        Dick


                -----Original Message-----
                From:   Lacelle, Marc [mailto:LACELLE@rcmint.ca]
                Sent:   Tuesday, June 27, 2000 8:32 AM
                To:     'BPCS-L@midrange.com'
                Subject:        RE: IWI and ILI Imbalances

                Hi Ho.

                        How about that INV971D. Kidding.

                        We are also experiencing the same problems. SSA
cannot duplicate the
                problem and this leaves us to fix the problem ourselves. SSA
when trying to
                duplicate the problem probably only generate 10
transactions. We on the
                other hand generate about 50,000 transactions of which 10 or
so items are
                affected.
                        
                        We to have noticed the B and T transactions are
giving false
                information. For those who are wondering what we are talking
about. This is
                the situation.

                        In your INV300 you will notice a MTD and a YTD
column. These columns
                are the sum of Issues - Receipts - Adjustments - Sales for
the month and
                year.

                        The B and T transactions:
                                The "B" transaction will affect the Issue
and Sales
                                The "T" transaction will affect the
Adjustment

                        For some unknown reason the quantities are being
posted in the wrong
                place. 
                                Example: A "B" transaction for 20 will post
against the
                ADJUSTMENT and SALES. Remember the "B" should affect the
ISSUE and the
                SALES. 

                        What those this do to my inventory Marc, you ask?
Nothing. Your
                inventory is adjusted properly, since the calculation is
(Opening + Receipts
                - Issues  - or + Adjustments). Even  though the transaction
was posted
                incorrectly as an adjustment the calculation for your on
hand is correct.

                        I have written a program that fixes the problem for
YTD. Since your
                MTD at the end of each month goes to 0, I never bothered to
write on that
                fixes the MTD.

                        Hopefully Dick, someone else will notice this and we
could make a
                case to SSA. Let's keep in touch on this one.

                Marc Lacelle
                Royal Canadian Mint
                 
                > ----------
                > From:         Bailey, Dick[SMTP:Dick_Bailey@MCFA.COM]
                > Reply To:     BPCS-L@midrange.com
                > Sent:         Sunday, June 25, 2000 11:36 AM
                > To:   'BPCS-L@midrange.com'
                > Subject:      IWI and ILI Imbalances
                > 
                > 
                > 
                >       Here I am again,  trying to maintain some faith that
BPCS on hand
                > balance programs work - We keep getting out-of-balance
conditions between
                > IWI and ILI MTD adjustment balances during the month, with
no apparent
                > pattern. In this case the IWI record always is incorrect.
It is not a new
                > IWI record, and is not related to a transaction in which a
new ILI record
                > is
                > created. 
                > 
                >       The transactions involved include B and T so far.
                > 
                >       Anybody have a clue what we have to fix??   (And
please don't tell
                > me to run a program to re-synch the records; we know how
to do that.)
                > 
                >       Dick Bailey
                >       MCFA
                > +---
                > | 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
                +---
+---
| 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
+---