|
Send MAPICS-L mailing list submissions to
mapics-l@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/mapics-l
or, via email, send a message with subject or body 'help' to
mapics-l-request@xxxxxxxxxxxx
You can reach the person managing the list at
mapics-l-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific
than "Re: Contents of MAPICS-L digest..."
Today's Topics:
1. item warehouse change (Weston Wheat)
2. Re: item warehouse change (Joe Perrault)
3. Re: item warehouse change (Sansi, Jim)
4. Re: item warehouse change (Jon Le Roi)
5. Product Structure Maintenance (jeffw@xxxxxxxxxxxxxxxx)
6. Re: item warehouse change (Greg Wenzloff)
7. Re: Product Structure Maintenance (ARojas@xxxxxxxxxxx)
8. Re: Product Structure Maintenance (sjones@xxxxxxxxxxxxxx)
----------------------------------------------------------------------
message: 1
date: Tue, 3 Mar 2009 14:50:57 -0700
from: "Weston Wheat"
subject: [MAPICS-L] item warehouse change
Hello All
Does anyone have a slick way of transferring items from one warehouse to
another,
without doing all the transactions?
We want to transfer about 1000 or more warehouse items to a new
warehouse.
RPG program?
Thanks in advance
Weston Wheat > Information Systems Manager > Quality Thermistor Inc >
2108 Century Way > Boise, ID 83709
O|208|377|3373 F|208|376|4754 > wwheat@xxxxxxxxxxxxxx
www.thermistor.com
------------------------------
message: 2
date: Tue, 3 Mar 2009 16:48:00 -0600
from: "Joe Perrault"
subject: Re: [MAPICS-L] item warehouse change
You can use the inventory transaction offline entry to do this.
Joe Perrault
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Weston Wheat
Sent: Tuesday, March 03, 2009 3:51 PM
To: mapics-l@xxxxxxxxxxxx
Subject: [MAPICS-L] item warehouse change
Hello All
Does anyone have a slick way of transferring items from one warehouse to
another,
without doing all the transactions?
We want to transfer about 1000 or more warehouse items to a new
warehouse.
RPG program?
Thanks in advance
Weston Wheat > Information Systems Manager > Quality Thermistor Inc >
2108 Century Way > Boise, ID 83709
O|208|377|3373 F|208|376|4754 > wwheat@xxxxxxxxxxxxxx
www.thermistor.com
_______________________________________________
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.
------------------------------
message: 3
date: Tue, 3 Mar 2009 14:53:47 -0800
from: "Sansi, Jim"
subject: Re: [MAPICS-L] item warehouse change
You know that's what I was thinking off hand... a quick and dirty RPG
program could read the ITEMBL and populate the OFFTRN file then just run
the offline load for IM.
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Joe Perrault
Sent: Tuesday, March 03, 2009 2:48 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] item warehouse change
You can use the inventory transaction offline entry to do this.
Joe Perrault
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Weston Wheat
Sent: Tuesday, March 03, 2009 3:51 PM
To: mapics-l@xxxxxxxxxxxx
Subject: [MAPICS-L] item warehouse change
Hello All
Does anyone have a slick way of transferring items from one warehouse to
another,
without doing all the transactions?
We want to transfer about 1000 or more warehouse items to a new
warehouse.
RPG program?
Thanks in advance
Weston Wheat > Information Systems Manager > Quality Thermistor Inc >
2108 Century Way > Boise, ID 83709
O|208|377|3373 F|208|376|4754 > wwheat@xxxxxxxxxxxxxx
www.thermistor.com
_______________________________________________
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.
------------------------------
message: 4
date: Tue, 3 Mar 2009 15:03:52 -0800
from: "Jon Le Roi"
subject: Re: [MAPICS-L] item warehouse change
I just did a similar process for importing 14,000 items from a recent
acquisition and it worked very well. I was able to create Item Master,
Item Balance and Product Structure records from an Excel spreadsheet.
The RPG program to load the various TMP files was pretty straight
forward. The MAPICS Inventory Manual could have been a little clearer
but the offline load program prints an edit report for identifying
errors and reducing the amount of garbage you can load into the system.
Regards,
Jon Le Roi
Director of I.T.
Tegal Corporation
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Sansi, Jim
Sent: Tuesday, March 03, 2009 2:54 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] item warehouse change
You know that's what I was thinking off hand... a quick and dirty RPG
program could read the ITEMBL and populate the OFFTRN file then just run
the offline load for IM.
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Joe Perrault
Sent: Tuesday, March 03, 2009 2:48 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] item warehouse change
You can use the inventory transaction offline entry to do this.
Joe Perrault
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Weston Wheat
Sent: Tuesday, March 03, 2009 3:51 PM
To: mapics-l@xxxxxxxxxxxx
Subject: [MAPICS-L] item warehouse change
Hello All
Does anyone have a slick way of transferring items from one warehouse to
another,
without doing all the transactions?
We want to transfer about 1000 or more warehouse items to a new
warehouse.
RPG program?
Thanks in advance
Weston Wheat > Information Systems Manager > Quality Thermistor Inc >
2108 Century Way > Boise, ID 83709
O|208|377|3373 F|208|376|4754 > wwheat@xxxxxxxxxxxxxx
www.thermistor.com
_______________________________________________
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.
_______________________________________________
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.
------------------------------
message: 5
date: Wed, 4 Mar 2009 07:18:27 -0600
from: jeffw@xxxxxxxxxxxxxxxx
subject: [MAPICS-L] Product Structure Maintenance
Hi list. I have was wondering if anyone had any experience writing their own
product structure maintenance routine? We have multiple warehouses in our
system and now we have two people maintaining product structures. The problem
is we only want one person to maintain product structures for one warehouse
and not the other. I have asked Mapics and there is no way to do this in the
PDM (green screen version we are using). Has anyone had any experience writing
their own product structure maintenance routine or any other ideas? I guess my
other option is to modify the Mapics source program. Hope this makes sense.
Thanks
Jeff Williams
------------------------------
message: 6
date: Wed, 4 Mar 2009 08:49:17 -0500
from: "Greg Wenzloff"
subject: Re: [MAPICS-L] item warehouse change
Weston, we create item balance records often by using query to capture
copies of the records in the existing warehouse. Then run that file
into a simple RPG program to change the warehouse and other fields.
Then write the record.
Information contained in the item master file and product structure file
are already established so you just need the new item balance record.
Try something like this:
FC92OUT IP E DISK
F C92OUT KRENAMEX
FITEMBL UF E K DISK A
C*
C IBKEY KLIST
C KFLD ITNBR
C KFLD HOUSE
C*
C MOVE 'C46' HOUSE
C IBKEY CHAINITEMBLMC 95
C *IN95 IFEQ '1'
C Z-ADD0 MOHTQ
C MOVE 'A' ACREC
C Z-ADD0 MALQT
C Z-ADD0 QTSMO
...
...
C Z-ADD0 MPSFA
C Z-ADD0 SALBF
C Z-ADD0 SALAF
C MOVE ' ' LPOWU
C WRITEITEMBLMC 90
We are at XAR4. This works for us.
Greg
-----Original Message-----
From: Weston Wheat [mailto:wwheat@xxxxxxxxxxxxxx]
Sent: Tuesday, March 03, 2009 4:51 PM
To: mapics-l@xxxxxxxxxxxx
Subject: [MAPICS-L] item warehouse change
Hello All
Does anyone have a slick way of transferring items from one warehouse to
another,
without doing all the transactions?
We want to transfer about 1000 or more warehouse items to a new
warehouse.
RPG program?
Thanks in advance
Weston Wheat > Information Systems Manager > Quality Thermistor Inc >
2108 Century Way > Boise, ID 83709
O|208|377|3373 F|208|376|4754 > wwheat@xxxxxxxxxxxxxx
www.thermistor.com
------------------------------
message: 7
date: Wed, 4 Mar 2009 07:41:38 -0800
from: ARojas@xxxxxxxxxxx
subject: Re: [MAPICS-L] Product Structure Maintenance
EPDM has options to do offline maintenance (add/change/delete), I don't
know if you can do it with PDM
Antonio Rojas
Manager Applications Development
Semtech Corp.
Cell. (805) 216-4651
Office (805) 480-2135
From:
jeffw@xxxxxxxxxxxxxxxx
To:
MAPICS ERP System Discussion
Date:
03/04/2009 05:19 AM
Subject:
[MAPICS-L] Product Structure Maintenance
Hi list. I have was wondering if anyone had any experience writing their
own
product structure maintenance routine? We have multiple warehouses in our
system and now we have two people maintaining product structures. The
problem
is we only want one person to maintain product structures for one
warehouse
and not the other. I have asked Mapics and there is no way to do this in
the
PDM (green screen version we are using). Has anyone had any experience
writing
their own product structure maintenance routine or any other ideas? I
guess my
other option is to modify the Mapics source program. Hope this makes
sense. Thanks
Jeff Williams
_______________________________________________
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.
------------------------------
message: 8
date: Wed, 4 Mar 2009 10:55:35 -0500
from: sjones@xxxxxxxxxxxxxx
subject: Re: [MAPICS-L] Product Structure Maintenance
Maybe I am not thinking clearly this morning, but product structure is not
warehouse specific so how will you know that the item they are maintaining
is in their warehouse? Thinking you could check item balance for the
parent would tell you what warehouse it is in. Does sound like you will
have to make changes to the program to do this.
Steve Jones
From:
ARojas@xxxxxxxxxxx
To:
MAPICS ERP System Discussion
Date:
03/04/2009 10:44 AM
Subject:
Re: [MAPICS-L] Product Structure Maintenance
Sent by:
mapics-l-bounces@xxxxxxxxxxxx
EPDM has options to do offline maintenance (add/change/delete), I don't
know if you can do it with PDM
Antonio Rojas
Manager Applications Development
Semtech Corp.
Cell. (805) 216-4651
Office (805) 480-2135
From:
jeffw@xxxxxxxxxxxxxxxx
To:
MAPICS ERP System Discussion
Date:
03/04/2009 05:19 AM
Subject:
[MAPICS-L] Product Structure Maintenance
Hi list. I have was wondering if anyone had any experience writing their
own
product structure maintenance routine? We have multiple warehouses in our
system and now we have two people maintaining product structures. The
problem
is we only want one person to maintain product structures for one
warehouse
and not the other. I have asked Mapics and there is no way to do this in
the
PDM (green screen version we are using). Has anyone had any experience
writing
their own product structure maintenance routine or any other ideas? I
guess my
other option is to modify the Mapics source program. Hope this makes
sense. Thanks
Jeff Williams
_______________________________________________
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.
------------------------------
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) digest 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.
End of MAPICS-L Digest, Vol 7, Issue 29
***************************************
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
