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 email@example.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: firstname.lastname@example.org +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.