Fwd: INV903

Folks,

Goran (gmihajlo@ssax.com) posted this message, but had HTML, PGP, PPP, or 
some other thing that inserts huge amounts of unnecessary characters into a 
message turned on in his/her mailer so it got bounced due to excessive size.  
Enjoy...

Dean

In a message dated 10/12/00 4:20:22 PM Eastern Daylight Time, 
owner-bpcs-l@midrange.com writes:

> Dennis and Wendy,
>  
>  The reason for this happening is because you don't have any records in ILI 
> file
>  satisfying the condition required to go to the second screen of INV903D, 
> which
>  is to have valid Cycle Count records in the location inventory file (ILI). 
> Valid
>  records are active records with the Last Sequence Number greater than 0. 
If 
> you
>  don't expect to have ILI records satisfying this condition, then program 
> works
>  as designed and in that case, as Genyphyr suggested, you might want to 
> pursue
>  with OGS in order to raise a BMR to add some message or so which would let 
> you
>  know what happened and why program finished without running month end. If 
> you
>  however do expect to have ILI records satisfying this criteria, you might 
> check
>  ILI file for any potential data corruption, for example having Last 
Sequence
>  Number (LTSEQ) < 0 which you can check for by using the following SQL stmt:
>  
>  SELECT COUNT(*) FROM ILI
>  WHERE LTSEQ < 0 AND LID = 'LI'
>  
>  and then investigate further the root cause for this, so that you can 
decide 
> how
>  to fix it i.e. whether it enough to simply use INV810D (to clear 
sequence#s 
> in
>  ILI file and this way reset corrupted ones to 0), or maybe look into ITH 
> file
>  and try to get better idea what values you would expect to have for 
sequence#
> 
>  for such records, or maybe check with OGS to see if data is actually 
> corrupted
>  by some bug in some of the programs updating Last Sequence Number in ILI 
> file.
>  Sorry I can't help you more in this application part of the fix because 
that 
> is
>  not my area, but at least I wanted to give you the technical cause of the
>  problem, after having checked the INV903D logic. As Genyphyr stated, this
>  program does not have any recent BMRs and its most current code does 
contain
>  second screen which you will go to after satisfying condition I mentioned 
> above.
>  Hope this helps,
>  Goran
+---
| 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
+---