RE: Duplicating Item Balance records

["Shaw, David" <dshaw@xxxxxxxxxxx>]

Doug,

I've used ASC's Sequel to do it, I imagine it should be do-able with SQL.
Make sure you copy the definition fields, plug in the new warehouse number,
and set the various quantities to zero.  It's not hard - IM isn't too
finicky about what's in Item Balance.  If you're using MRP and/or MPSP it's
a little trickier, but still shouldn't be too tough.

Dave Shaw
MAPICS-L Moderator
Spartan International, Inc.
Spartanburg, SC
 
-----Original Message-----
From: Ritsema, Doug B [mailto:Doug.Ritsema@wafers.com]

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