• Subject: RE: Duplicating Item Balance records
  • From: "Shaw, David" <dshaw@xxxxxxxxxxx>
  • Date: Mon, 5 Feb 2001 11:23:50 -0500


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?


Doug Ritsema
Holland American Wafer Co
3300 Roger B Chaffee
Grand Rapids, MI  49548
| 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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

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

This mailing list archive is Copyright 1997-2022 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.