RE: Duplicating Item Balance records -- MAPICS-L

Title: RE: Duplicating Item Balance records

Good point! I think this point can't be emphasized enough. I have seen many problems resulting from trying to special-load Item Masters or Balance records. COM also presents it's own problems as it has some Item Master and Pricing Files as well.

-----Original Message-----
From: Shannon, George [mailto:GShannon@BDFUSA.com]
Sent: Tuesday, February 06, 2001 2:32 PM
To: 'MAPICS-L@midrange.com'
Subject: RE: Duplicating Item Balance records

Since there are several files connected with the ITEMBL file (especially if you use MRP), you could use the offline load option in IM. This will insure that all related MAPICS files are updated properly.

-----Original Message-----
From:   Greg Wenzloff [SMTP:GWenzloff@beckmfg.com]
Sent:   Tuesday, February 06, 2001 2:49 PM
To:     'MAPICS-L@midrange.com'
Subject:        RE: Duplicating Item Balance records

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