RE: MAPICS -- Warehouse going away

Bob,

There are a number of steps that will need to take place.

First, you will need to make sure your inventory has been cleared from the
item balance records.

Next, you will have to write a user program to load the information into the
item balance offline load file.  Off the top of my head, I believe the name
of this file is tmp113.

Now, you will need to delete the records from the item master, routing and
product structure files.  Again, you will need to write a program to do this
because you may have items in other warehouses that you are still
manufacturing.  If this is the case, then you will probably not want to
delete any records from these files.

Once you are comfortable with what you are going to delete, you can run the
offline file maintenance from the CAS File maintenance menu.  The bad thing
about this is that you will need a dedicated environment.

The offline file maintenance process is well documented in the PDM and IM
manuals in the appendices.  The file names are listed here.

Another alternative to this is to write your own "blaster" program to go
through and physically delete the records from these files.  If you are not
intimately familiar with the product data base, I would not recommend this.
You need to make sure you get all of the records associated so you do not
have any "orphans" out there.

I hope this helps.

Sincerely,


Richard T. Molder
 
President
Moldrich Solutions, LLC.
 
Ph. 814-451-0165

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Bob Anderson
Sent: Thursday, April 28, 2005 9:52 AM
To: MAPICS ERP System Discussion
Subject: RE: MAPICS -- Warehouse going away

Richard,
        I can see where this is useful but how do you get a file to use as
the
offline Maint. when they already reside on the Product Structure.

Sorry this is the first I've ever played with Offline Maint.

Bob

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]On
Behalf Of Richard T. Molder
Sent: Thursday, April 28, 2005 9:04 AM
To: 'MAPICS ERP System Discussion'
Subject: RE: MAPICS -- Warehouse going away


Bob,

Generally speaking, the "best" way to perform a mass delete without pdm plus
or epdm is to utilize the offline maintenance feature of pdm.  That is
generally the best way to let "MAPICS do what MAPICS (or Infor XA)" do what
it does best.



Richard T. Molder

President
Moldrich Solutions, LLC.

Ph. 814-451-0165
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Bob Anderson
Sent: Thursday, April 28, 2005 9:03 AM
To: MAPICS ERP System Discussion
Subject: MAPICS -- Warehouse going away

Good Morning,
        We have a warehouse we have closed and we want to delete all of the
data
that is associated with it.  What is the best way to do a Mass delete all of
the PDM structures and Item Balances that associated with that warehouse.

Bob Anderson
IT Guy
Kent Sporting Goods Inc.
New London OH
Ph: 419-929-7021 x315
Fax: 419-929-1380

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.10.4 - Release Date: 4/27/2005

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.



_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.


--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.10.4 - Release Date: 4/27/2005

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.10.4 - Release Date: 4/27/2005

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.