Re: ITH transactions of the type #

We have had occasion to resequence the ITH file as well.  Developed a
simple RPG program that  resequences ITH and then updates IIM for last
sequence number used.

Micki Rogers
Michigan Wheel Corporation
(616) 248-5317


                                                                                
                                
                    Lmittman@aol.co                                             
                                
                    m                      To:     BPCS-L@midrange.com          
                                
                    Sent by:               cc:                                  
                                
                    owner-bpcs-l@mi        Subject:     Re: ITH transactions of 
the type #                      
                    drange.com                                                  
                                
                                                                                
                                
                                                                                
                                
                    03/28/2000                                                  
                                
                    01:49 PM                                                    
                                
                    Please respond                                              
                                
                    to BPCS-L                                                   
                                
                                                                                
                                
                                                                                
                                




Bill:

As you mention, INV300 is sequence number sensitive.  The ITH Seq Number
(ITSEQ) field in the Item Master (IIM) File is a counter that controls the
assignment of the next ITH record for an Item.  BPCS assumes that the
Sequence Number on the ITH record (TSEQ) will be sequential within Item.

Also,  the ITSEQ must NOT be less than the TSEQ for the Item.  If it is,
ITH
records with a greater Seq Number will NOT be displayed.

In addition, duplicate key ITH records will then be created.  If this
situation occurs, a looping problem can result during Inventory Month-End
Close when INV900 tries to purge and reorganize the ITH File.

To correct such a problem, a simple program can be written to resquence the

ITH records in acsending sequence and then reset the ITSEQ field in the
Item
Master.

Thanks.

Les Mittman
BSI Consulting, Inc.
Highland Park, IL
Phone:  (847) 831-9388

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