Re: item warehouse change

["Greg Wenzloff" <GWenzloff@xxxxxxxxxxx>]

Weston,  we create item balance records often by using query to capture
copies of the records in the existing warehouse.  Then run that file
into a simple RPG program to change the warehouse and other fields.
Then write the record.

Information contained in the item master file and product structure file
are already established so you just need the new item balance record.

 Try something like this:
  FC92OUT  IP  E                    DISK                           
  F            C92OUT                            KRENAMEX          
  FITEMBL  UF  E           K        DISK                      A    
  C*                                                               
  C           IBKEY     KLIST                                      
  C                     KFLD           ITNBR                       
  C                     KFLD           HOUSE                       
  C*                                                               
  C                     MOVE 'C46'     HOUSE                       
  C           IBKEY     CHAINITEMBLMC             95               
  C           *IN95     IFEQ '1'                                   
  C                     Z-ADD0         MOHTQ                      
  C                     MOVE 'A'       ACREC                      
  C                     Z-ADD0         MALQT                      
  C                     Z-ADD0         QTSMO                      
		...
<change any significant fields>
		...	
   C                     Z-ADD0         MPSFA                  
   C                     Z-ADD0         SALBF                  
   C                     Z-ADD0         SALAF                  
   C                     MOVE ' '       LPOWU                  
   C                     WRITEITEMBLMC               90        


We are at XAR4.     This works for us.

Greg


-----Original Message-----
From: Weston Wheat [mailto:wwheat@xxxxxxxxxxxxxx] 
Sent: Tuesday, March 03, 2009 4:51 PM
To: mapics-l@xxxxxxxxxxxx
Subject: [MAPICS-L] item warehouse change

Hello All

Does anyone have a slick way of transferring items from one warehouse to
another,

without doing all the transactions?

We want to transfer about 1000 or more warehouse items to a new
warehouse.

RPG program?

 

Thanks in advance

 

  <http://www.thermistor.com/> 

Weston Wheat > Information Systems Manager > Quality Thermistor Inc >
2108 Century Way > Boise, ID 83709

O|208|377|3373   F|208|376|4754 > wwheat@xxxxxxxxxxxxxx
<mailto:srowhanian@xxxxxxxxxxxxxx>  > www.thermistor.com
<http://www.thermistor.com>