Results 1 to 4 of 4

Thread: Change a Vendor from V to XV

  1. #1

    Question Change a Vendor from V to XV

    Is there a mass change option to change vendors from V to XV? We have about 875 vendors that need to be changed to XV and my payables person is looking for a way to do a mass change. We run JDE on the iSeries

  2. #2
    Member
    Join Date
    Sep 2001
    Location
    Greene, NY
    Posts
    135
    Not sure about your reference to V/XV but you can either write a program -or- run an SQL update statement to make the changes.

    If using SQL, you'll need to narrowly define the criteria to ensure only the correct records are updated. I prefer to use a SELECT statement first to make sure I'm accessing the right entries...and then change it to an UPDATE statment to make the changes.
    iSeries running at V6R1
    JDE World 7.3, Cum12
    OneWorld XE Coexistence - Configurator

  3. #3
    Member G_Smith's Avatar
    Join Date
    Oct 2000
    Location
    North Central Texas
    Posts
    205

    Old School Update

    And for those of us old timers there is always the World Writer update.

    1. Set the WW Query Group Level Security for the User Profile to allow Field Update (Fupd = Y).
    2. Set the WW Field Level Security for the User Profile/File and set the specific field to allow update.
    3. Build the WW in the Group Authorized in #1 above.
    a. Add fields to query to print including the field to be revised
    b. Add a field to query to have the new value in the Calcs Opt. 1 ex. NWAT1 = 'XV'
    c. Build the Data Selection to only pull the records to change and run a test to view the results
    d. Set the field to update with Opt. 7 Query File Update with the new field name (ABAT1 = NWAT1)
    e, Run the query to update the field with the new value

    I know this is not as easy as just using Interactive SQL but this is lesson in JDE History processing. Much like using P00PURGE to remove records from a file and reorganize it.
    Last edited by G_Smith; 10-25-2018 at 06:16 AM. Reason: Remove extra signature
    George Smith,
    World A9.2 - V7R1,
    Fruit of the Earth
    Fort Worth, TX

  4. #4
    Senior Member
    Join Date
    Nov 2000
    Location
    E Greenville, PA, USA
    Posts
    1,220
    Let's hear it for us old timers!
    Frosty
    *
    Back to the future supporting A7.3 while moving to Oracle EBS

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.