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>




This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].