jimmymac
Reputable Poster
We use MCRP26 in the F0006 to designate a reporting hiearchy for another system. We have 7000 or so business units, and about 200 possible values in the UDC 00/26.
The business would like to change the MCRP26 value for all of the business units, and will be providing us a spreadsheet with that information. Now rather than going in one by one and changing each business unit, we are looking for a system way to apply these changes.
I know if we were adding new business units, we could do a mass upload using the Revise Multiple BUs option in the Review/Revise BU's, but we are looking to update existing entries.
Is there anything like the Import option that would allow us to apply a mass change like this?
If not, then it looks like we would do some sort of SQL update or script outside of JDE to do this, but would prefer a system option of some sort within JDE.
Any ideas would be appreciated. We are on E1 9.0.
The business would like to change the MCRP26 value for all of the business units, and will be providing us a spreadsheet with that information. Now rather than going in one by one and changing each business unit, we are looking for a system way to apply these changes.
I know if we were adding new business units, we could do a mass upload using the Revise Multiple BUs option in the Review/Revise BU's, but we are looking to update existing entries.
Is there anything like the Import option that would allow us to apply a mass change like this?
If not, then it looks like we would do some sort of SQL update or script outside of JDE to do this, but would prefer a system option of some sort within JDE.
Any ideas would be appreciated. We are on E1 9.0.