Results 1 to 5 of 5

Thread: F4111 (CARDEX) Reverse entry

  1. #1
    Member
    Join Date
    Nov 2004
    Location
    USA, PA
    Posts
    205

    F4111 (CARDEX) Reverse entry

    I have a need to create a utility app in JDE (9.1.3) to reverse a F4111 (CARDEX) entry and reset a SO back to a prior status.

    The secenerio is like this:
    1. A Sales Order is ready to ship
    2. The shipping clerk processes the order through Ship Confirmation (P4205)
    3. The BOL is printed
    4. After the BOL is printed, it was found that the wrong items/quantities were selected, or that there is an issue with the shipment of some sort
    5. CURRENTLY, in order to resolve the issue
    a. The Order needs to be invoiced
    b. A credit needs to be applied to the order
    c. The order needs to be re-entered and processed through correctly

    What I am hoping to achieve is to avoid the whole credit and re-order process and just reverse the entries created during Ship Confirm (P4205). Thereby resetting the SO back to a previous point.

    What appears to be the sticky point is reversing the F4111 entry and resetting the F41021 quantities. Resetting the status's and dates is easy.

    Is this possible, and if so, what business functions do I need to use in order to do this as transparently as possible?

    Any advise is appreciated.
    EnterpriseOne E9.1.3 , Tools 9.1.3.1 base, Oracle Linux 6 Enterprise Server, Oracle 11GR2 Database Server on Oracle Linux 6, Oracle Linux 6 Web Logic

  2. #2
    New Member
    Join Date
    Nov 2001
    Location
    New York, NY
    Posts
    14
    Why don't you "Pick" confirm the order at step 2 (advances the order but does not consume the inventory, but hard commits the inventory).

    Then you can just cancel the order if needed. If you don't cancel the order it can consume the inventory during the Sales Update process.

  3. #3
    Member
    Join Date
    Nov 2004
    Location
    USA, PA
    Posts
    205
    I apologize. Step 1 is post Pick Confirmation and step 2 is where the shipping clerk takes over the order.

    I do NOT want to change established processes and procedures which have been in place for over 20 years now, just be able to correct the infrequent discrepancies after the fact. Everyone makes mistakes, fat fingering values, being distracted and entering a wrong value or whatever. Rather than going through the long and disruptive crediting/rebill process, I was hoping to find a short cut and reset the F4111.

    I will keep looking.
    EnterpriseOne E9.1.3 , Tools 9.1.3.1 base, Oracle Linux 6 Enterprise Server, Oracle 11GR2 Database Server on Oracle Linux 6, Oracle Linux 6 Web Logic

  4. #4
    Member Aarto's Avatar
    Join Date
    Oct 2000
    Location
    Copenhagen, Denmark
    Posts
    398
    There is no standard way of reversing F4111/F41021/F4211 effects of ship confirm
    What i would normally recommend is to
    1. Create a new negative line on the same order and process it through ship confirm (this will "reverse" the F41021 and F4111 will have a negative and positive entry balancing each other out)
    2. Blank out the unit price on both original line and new line
    3. Process both lines through invoicing and sales update

    As the total price is zero, there will be no A/R entries and the G/L entries will balance themselves out (if you post in detail) or will not be created at all (if you post in summary mode)

    As for a utility application instead of doing this manually as per above, we developed just that for one customer
    It allowed user to select an Item ledger record created from sales order. If the F4111 GL Date was blank, it would allow user to reverse the entry (Order was not processed through sales update)

    Following updates were done
    1) updated F41021 quantity and hardcommited fields based on the F4111 records (quantity increased, hardcommitted quantity increased),
    2) updated the sales order back to ship confirm status and cleared the "on hand updated" flag SDSO02
    3) Deleted the F4111 record

    Worth noting is that this would only work if the sales order lines was not yet sales updated. In those cases, users still needed to create the negative sales order line manually and process it all the way through invoicing and sales update


    Hope this helps
    Aarto
    Last edited by Aarto; 12-04-2019 at 01:20 AM.
    Aarto Reponen

    Senior JD Edwards/Serialization consultant, xperitus Denmark Aps - Your JDE experts in Scandinavia
    Part of Redfaire International, Oracle platinum partner
    LinkedIn

  5. #5
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,376
    B4101370 F41021 Update Quantities is the BSFN I use to update F41021 quantities

    If an order has stock committed to it but you've not shipped it yet, the only tables affected are the SO and the F41021 (in terms of stock)
    There are no cardex records you need to worry about as such (unless you used a WO to get the stock, then you'll have ICs and IMs)

    So I think, all you need to to is blank the LOTN LOCN in the SO tables and repost R42995

    We also have a process here call Unpack

    If you do have cardex records, a process I have here for consigned stock (cancels out receipts) is I create a mirror cardex record to negate the total. SO if it shows +100 in stock I create a -100 in stock and then go on to do some other stuff.
    But this principle of reversing entries is the same as what you want
    Last edited by johndanter; 12-04-2019 at 02:31 AM.
    John Danter
    You don't go out looking for a job dressed like that do you, on a weekday?

    E900 TR 9.1.5.3 Unix

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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.