Copy Items from LIVE environment to Development

[mnarewec]

Is there a simple way to copy items from live environment to Development
Environment? Only the Inventory part.

Marsh
_________________________________
Marsh Rei Narewec
JDE400 Development, Training & Support
Steamships Computer Services
Papua New Guinea
Ph: (675) 322 0245

--------------------------------------------------------------
CAUTION:
1. This message may contain privileged and confidential information
intended only for the use of the addressee named above. If you are not the
intended recipient of this message; you are hereby notified that any use,
distribution or reproduction of this message is prohibited
2. If you have received this message in error, we apologise. Please notify
us immediately at [email protected]
3. Any views expressed in this message are those of the individual author
and may not necessarily reflect the views of Steamships Trading Company.
4. The sender disclaims liability for any errors, omissions, viruses, loss
and/or damages arising from using, opening or transmitting this e-mail.




------------------------
JDE/400 7.3 00009
Papua New Guinea
Opinions or Post I express are not from my employer

 

[jean_driscoll]

No, not really. Depending on how much of the item setup you require to have copied:
F4101 Item Master
F4102 Branch PLant
F41021 - Item Locations
F0911 - Inventory $$ records
F4111 - Item History

and if you are using MFG, there are more F30* tables.

You can use SQL and insert specific records from one environment to another.

You can write an RPg program that allows you to select from one and adds to the other

You can copy the entire table. We usually 'refresh' the dev environment from production by clearing the DEV data library and restoring PROD data to the DEV library

 

[jean_driscoll]

oh and don't forget the cost table, F4105 and pricing tables from the Sales system.

 

[got_to_love_jde]

Hi Marsh,
What do you want to copy ? Just data ?
Regards,
Dave

 

[lutesk]

Easy: G96, menu option 14, then menu option 16.

 

[mnarewec]

I just looking for that .... Thank you very much for the information.

Marsh
_________________________________
Marsh Rei Narewec
JDE400 Development, Training & Support
Steamships Computer Services
Papua New Guinea
Ph: (675) 322 0245



lutesk
<[email protected]> To: [email protected]
Sent by: cc:
jdeworld-bounces@j Subject: Re: Copy Items from LIVE environment
delist.com to Development


18/02/2004 05:24
Please respond to
JDELIST World
Discussions






Easy: G96, menu option 14, then menu option 16.
--------------------------
To view this thread, go to: http://www.jdelist.com/ubb/showthreaded.php?Cat
=&Board=W&Number=68049

This is the JDELIST World* Mailing List. To stop receiving these messages,
login to http://www.jdelist.com/forums, click Control Panel, then click
Edit by "Subscribe / Unsubscribe from receiving board posts by email,
change message notifications, etc." and adjust your subscription
preferences. JDEList is not affiliated with JDEdwards®




--------------------------------------------------------------
CAUTION:
1. This message may contain privileged and confidential information
intended only for the use of the addressee named above. If you are not the
intended recipient of this message; you are hereby notified that any use,
distribution or reproduction of this message is prohibited
2. If you have received this message in error, we apologise. Please notify
us immediately at [email protected]
3. Any views expressed in this message are those of the individual author
and may not necessarily reflect the views of Steamships Trading Company.
4. The sender disclaims liability for any errors, omissions, viruses, loss
and/or damages arising from using, opening or transmitting this e-mail.



------------------------
JDE/400 7.3 00009
Papua New Guinea
Opinions or Post I express are not from my employer