I have views that contain ONLY Item rev data, but did not migrate. An incidents(s) have been recorded.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Dale Gindlesperger
Sent: Friday, July 20, 2012 3:29 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] R9 Migration to Client

I believe that they come over OK if the views and such are based on Item Revision, but they are not migrated if you use Item.  Infor wants us to quit using Item Master and use Item Revision for all the PowerLink work.  Check out KB 1043095 for full detail, but here's a summary:

Views migrated to R9 that contained attributes from Item Master will be dropped if EPDM is installed
 
In R9, views over Item Warehouse cannot include attributes from the Item Master, even though they have a many-to-one relationship.
This is because of full EPDM enablment (R9). Even though item is considered part of the query scope in R9 (because of the many-to-1 relationship) the availability of the item master attributes is conditioned to be available only when PDM+ is installed.  And in R9, when EPDM is installed, PDM+ is assumed to not be installed ... per the Application window. Views migrated from a previous release will not contain the item master attributes. 


Resolution
Users will need to update their views to contain the equivalent attributes from the Item Revision file.  The views should then use the data from the current item revision.

If you are planning an R9.1 upgrade, I would strongly recommend going through all your custom stuff and change any use of Item to use Item Revision prior to doing the upgrade.

 
Dale (Cork) Gindlesperger, CPIM
Click here for my professional profile on LinkedIn

"If I'd asked my customers what they wanted, they'd have said a faster horse." - Henry Ford

A Pessimist Sees The Difficulty in Every Opportunity; An Optimist Sees The Opportunity in Every Difficulty; An Analyst Sees How to Achieve the Opportunity!





________________________________
From: Otto Meyn <meyno@xxxxxxxxxxxxxxxxxx>
To: MAPICS-L SUBMIT <MAPICS-L@xxxxxxxxxxxx>
Sent: Friday, July 20, 2012 2:32 PM
Subject: [MAPICS-L] R9 Migration to Client

The PowerLink views for Item revision and Item Balance did not migrate.
I find the Item master file was dropped from any relationship BUT the
file is still listed in the

Integrator.



I can understand, maybe, the dropping of the relationship with the item
rev. BUT, the item balance, (warehouse), record's relationship with the
item rev is by item. We have multiple sites

with the same item numbers.  The items are manufactured in one location
only. I see lots of problems if the warehouse records display item rev
data.



Any comments?  Also, has anyone else find missing views, subset or
sorts after migrating to Release 9?



I also know the price book offline loads will not work anymore, that's
a BIG OUCH for me.





_______________________________________________
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 thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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