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
+---