Re: MAPICS/XA to JDE Enterprise 1 -- MAPICS-L

I am just finishing up a project very similar to what you are describing.  In 
my case, I am going MAPICS to MAPICS, but the same process should work as long 
at the JDE data is correctly filled into the offline load tables.  

My customer has two facilities both running MAPICS on two separate 
iSeries/400's.  The corporate installation controls all EPDM maintenance.  Once 
a night (or on demand as needed), programs run looking for adds/changes/deletes 
to the corporate EPDM tables.  When these are found, EPDM offline records are 
written.  These offline tables are saved and FTP'ed to the satelite location.  
The FTP also runs a remote command to execute a program to automatically submit 
the appropriate offline loads on the satelite system.

Some things I have learned:

Release 5 doesn't allow the automatic release to PDM of new items.  I believe 
Release 6 does do that, so that wouldn't be an issue for you.

The offline loads must be run in a strict order:
For adds:
Item Enterprise
Item Revision
Routing Header
Routing Operations
Product Structure Header
Product Structure Detail
Item Process
Item Balance (if applicable - corporate only controls the item class & item 
accounting class, here)

Deletes should be in reverse order of adds.  See below.

I had to separate adds/changes from deletes and run them separately through the 
offline load.  This is because in add/change mode, the header record (PSTHDR, 
RTGHDR) need to exist prior to adding/changing the detail.  In delete mode, the 
header record must be deleted after the detail.

Prior to submitting the automatic offline load, I need to check whether records 
exist in the offline file.  If there are no records, the offline load program 
errors out.

Item Process records cannot be deleted or changed through offline load.  I just 
spoke with the support line, and they couldn't give me a good reason as to why. 
 I was offerred the "enhancement request form".  For deletes, he suggested I 
write a program to delete the Item Process record myself.  He did mention that 
at 5.5 or higher, you need to be careful because it is assumed that all Item 
Revisions have an Item Process record.  Prior to 5.5, it is not a requirement.

--
Regards, 
Penny Lancor 
Technical Services 
TechKnowledge Partners, LLC 
224.715.3967

-------------- Original message -------------- 

> 
> 
> 
> 
> 
> Hi group, 
> 
> We have a new requirement at my company/division. Our corporate owners 
> want us to start producing parts for a number of their products, as well as 
> a couple of their end items (travel trailers), since we have excess 
> capacity at our plant. They run on JDEdwards Enterprise 1 (formerly known 
> as One World). We, of course, run our entire facility on MAPICS/XA R6. 
> For this to work without massive duplication of keying (always a bad idea), 
> we will need to integrate JDE E1 to MAPICS for Item Masters and Bills of 
> Material (they don't use routings) in EPDM. I'm sure I can accomplish this 
> through the EPDM File Maintenance off-line loads, but I was wondering if 
> any of you had experience with this so you could give me some ideas or 
> suggestions on how to streamline this. 
> 
> As usually occurs, this is an immediate project - they already sent 
> Engineers into our plant to start loading drawings and such. 
> 
> Any experienced tips or suggestions will be most welcome. 
> 
> Dale Gindlesperger 
> IT Manager/Special Projects Leader 
> Fleetwood Folding Trailers, Inc. 
> 258 Beacon Street 
> Somerset, PA 15501 
> 
> 
> 
> _______________________________________________ 
> 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. 
>