My Oracle Support Banner

E1: 42: Sales Update (R42800) Fails To Create Reversal Cycle Billing Entries for Freight Lines. (Doc ID 2896833.1)

Last updated on NOVEMBER 01, 2022

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When a non-stock Freight Line is populated on a Sales Order, Deferred Journal Entries for Freight (Line Type FD, Inventory Interface N) created by Cycle Billing (R49700) do not get reversed by Sales Update (R42800). 

Steps to Reproduce:

  1. Setup two new line types
         a. Setup Line Type LP for Sold Items with Inventory Interface = D (Direct Ship) but the Generate Purchase Order Checkbox is UNCHECKED.
         b. Setup Line Type FD for Freight Lines with Inventory Interface = N (Non-Stock) and the Edit Item Master for Non-Stock Items checkbox is CHECKED.
    2. Setup Order Activity Rules for SO/LP
    3. Setup Order Activity Rules for SO/FD
    4. Create a three-line Direct Ship (SD) Sales Order
         a. Line 1.000 and 2.000 have Line Type LP an Extended Price of 247.35, and Extended Cost of Zero.
            - Line 1.000 and 2.000 for sold items are in a different branch plant than the header branch
         b. Line 3.000 has a Line Type of FD an Extended Price of 100.00, Extended Cost of Zero.
            - Line 3.000 for Freight is in the same branch as the header branch plant
    5. Ship Confirm (P4205) the order.
         a. Set Actual Ship Date as Today’s Date.
    6. Setup a version of In Journal Entry MBF Processing Options (P0900049)
         a. Set Zero Amounts Tab Option #1 = Blank (Allow zero amounts).
    7. Setup a Version of Sales Update (R42800) to be called by Cycle Billing (R49700) as follows:
         a. Select Ship Date as A/R Date and G/L Date
         b. Set G/L Account Business Unit as 1 (Detail Business Unit)
         c. Summarize A/R Entries AND G/L Entries
         d. Set Version Tab Option #2 (G/L Master Business Function (P0900049)) to the version name you setup to allow zero amounts.    
         e. Set to run in Final Mode
    8. Setup a Cycle Billing Version (R49700) that calls the Sales Update (R42800) version.
    9. Make sure the Cycle Billing Preference has been setup for the customer but leave the branch plant blank to cover all branch plants on the order.
    10. Run Cycle Billing (R49700). Report PDF shows the following journal entries are created.
         a. Deferred Revenue (AAI 4231) Credit (first and second LP line) -494.70 (summarized)
         b. Deferred Revenue (AAI 4231) Credit (third FD Freight Line) -100.00
         c. Deferred Cost of Goods Sold (AAI 4221) ZERO (Summarized)
         d. Inventory (AAI 4240) ZERO (Summarized)
         e. Unbilled A/R (AAI 4232) Debit (first and second LP line) 494.70 (summarized)
         f.  Unbilled A/R (AAI 4232) Debit (third FD Freight Line) 100.00
    11. Run Invoice Print (R42565) with Invoice Date set to end of month (9/30/2022)
    12. Check Sales Update (R42800) Version processing options
         a. Select Invoice Date as A/R Date and G/L Date
         b. Set G/L Account Business Unit as 1 (Detail Business Unit)
         c. Summarize A/R Entries and Summarize G/L Entries
         d. Set Version Tab Option #2 (G/L Master Business Function (P0900049)) to the version name you setup to allow zero amounts.    
         e. Set to run in Final Mode
    13. Run Sales Update (R42800). Report PDF shows the following
         a. AAI 4231 Deferred Revenue Debit for +100.00 for Freight Line in Branch 10 is MISSING
         b. AAI 4232 Unbilled A/R Credit for -100.00 for Freight Line in Branch 10 is MISSING
         c. AAI 4230 Sales Revenue Credit of -494.70 (Summarized)
         d. AAI 4231 Deferred Revenue Debit of +494.70 (Summarized)
         e. AAI 4232 Unbilled A/R Credit only of -494.70 (Summarized)

Cycle Billing (R49700) Journal Entries

Sales Update (R42800) Journal Entries

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.