× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MAPICS-L
  3. April 2005

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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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