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 IBKEY KLIST
C KFLD ITNBR
C KFLD HOUSE
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.
From: Weston Wheat [mailto:wwheat@xxxxxxxxxxxxxx]
Sent: Tuesday, March 03, 2009 4:51 PM
Subject: [MAPICS-L] item warehouse change
Does anyone have a slick way of transferring items from one warehouse to
without doing all the transactions?
We want to transfer about 1000 or more warehouse items to a new
Thanks in advance
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