Results 1 to 5 of 5

Thread: recording changes to work orders

  1. #1

    Question recording changes to work orders

    hi

    Is there any easy way to write a program that would give us changes that were made to work orders. I don't see any ledger file. We are using JDE 9.0. We need to send changes to our WMS system but I don't really want to mod the existing JDE program to create a separate file

    any help would be great

    thanks,
    Carol
    Carol Schwobe
    One World ERP8
    AS 400

  2. #2
    Here is one way:

    You can turn on outbound interoperability for the Work Orders application. This will create a Z record in the F4801Z1 for every work order change/addition. You can create you external program to pick up records from this table.
    Regards,

    Hari Sharma
    Aellius
    EnterpriseOne: Integration (.Net, Web Services) | Output Management | Monitoring

  3. #3
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,145
    Carol,

    here's what we do:
    1. In JDE Create a clone of F4801 - call it F554801L - that's a mirror image of F4801 plus a Operation (ADD/CHG/DEL) field and a database date/time stamp field that is part of the Primary key.
    2. In JDE Create a BSVW based on F554801L and a simple Find/Browse Form using the BSVW that shows all the columns you care about. Make sure the Form's Data Structure has the DOCO (Order Number) included. In the Post-Dialog-Init event stuff the FI DOCO field into the QC Order Number field (Grid Query Column). Then have it execute Find.
    3. In P48013 - Form J (or whatever WO Apps you want to use) Add a Row Exit that calls your new Custom App/Form passing the Grid Row's DOCO.
    4. Outside of JDE at the database level create a database trigger on F4801 that writes a after-image copy of WO Adds and changes to the F554801L table. Optionally put filters in your triggers to exclude certain programs/events from being logged (to reduce the noise level).

    Now you have your History of changes to WOs accessible via one click from P48013.
    Larry Jones
    E1 9.1 - TR 9.1.5 on Win 2012 R2. Oracle DB 11.2.04
    Wintel, BI Publisher

    Migrating to JDE 9.2 and SQL Server 2016

  4. #4
    We are doing exactly what Larry Jones has outlined. It works great.

  5. #5
    Member Gomer79's Avatar
    Join Date
    Jul 2003
    Location
    Wisconsin
    Posts
    141
    There is also a Quest enhancement request for this functionality if you would like to add your support to it: http://nnf.questdirect.org/questenha....aspx?id=11608
    Project Manager
    JDE 9.2, Tools 9.2.1.4
    IBM AIX on POWER Systems (64-bit) v7.1
    DB2 UDB v8.2
    Web Server: WebLogic 12.1.3.0.6
    IE 11.2007.14393.0

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, Oracle or Peoplesoft.