RE: Duplicating Item Balance records

[Greg Wenzloff <GWenzloff@xxxxxxxxxxx>]

Doug,

I just use a quick and dirty RPG program to read the entire ITEMBL file.
When you have a WH1 record change the house to WH8,  zero or blank
appropriate fields like Quantity on hand and write the record.

Greg Wenzloff
Beck Mfg.

-----Original Message-----
From: Ritsema, Doug B [mailto:Doug.Ritsema@wafers.com]
Sent: Monday, February 05, 2001 11:06 AM
To: 'MAPICS-L@midrange.com'
Subject: Duplicating Item Balance records


We are in the process for creating a new warehouse.  Does anyone have a good
way to add Item balance records for that warehouse?  What I would like to do
is somehow copy the WH1 Item Balance records to WH8.  Is SQL a good option?

TIA

Doug Ritsema
Holland American Wafer Co
3300 Roger B Chaffee
Grand Rapids, MI  49548
doug.ritsema@wafers.com
+---
| This is the MAPICS Mailing List!
| To submit a new message, send your mail to MAPICS-L@midrange.com.
| To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
| To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: dshaw@spartan.com
+---
+---
| This is the MAPICS Mailing List!
| To submit a new message, send your mail to MAPICS-L@midrange.com.
| To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
| To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: dshaw@spartan.com
+---