My Oracle Support Banner

E1: 42: Sales Update (R42800) Doesn't Write G/L Entries for Configured Item Components with Accrued to G/L Price Adjustments (Doc ID 2874678.1)

Last updated on JULY 29, 2022

Applies to:

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

Symptoms

When an Accrued to G/L Price Adjustment is applied against a configured item component which has Kit/Configurator Pricing Method 4 (Components Discounted Prices), Sales Update (R42800) does not create the G/L entries for the accrual.

Steps to reproduce:

  1. In Item Master (P4101) Configured Parent item is setup as follows:
    1. Stocking Type = C (Configured Item)
    2. Line Type = W (Work Order)
    3. Kit/Configurator Pricing Method = 4 (Components Discount Prices)
  2. Base Price (P4106) on Parent in Branch is 300.00
  3. In Item Master (P4101) Configured Component is setup s follows:
    1. Stocking Type = P (Purchased)
    2. Line Type = S (Stock Item)
  4. Component Price in Branch is 200.00
  5. Create Price Adjustment Definition (P4071) for the Component Item
    1. Adjustment Control Code = 4 (Accrued to G/L)
    2. Line Level Adjustment
    3. Quantity Level Break
  6. Create a Price Adjustment Schedule (P4070) with the one adjustment on it.
  7. Add the price adjustment schedule to the Customer Billing Instructions (P03013)
  8. Create Price Adjustment Detail (P4072) record for the customer and component item number.
  9. In DMAAI 4270 setup a G/L Account (200.5175)
  10. In DMAAI 4280 setup a G/L Account (200.4190)
  11. Enter a sales order with Quantity 1 of the Configured Parent Item
  12. Configured Item Screen appears. Validate the configuration. Add to the Order
  13. Save the order for the Configured Parent
  14. Reinquire and select the Component Line and Row Exit to Price History.
  15. The G/L Accrual Price Adjustment was applied to the Component Line Number (1.001)
  16. Complete the Work Order for the Configured Item.
  17. A lot number was assigned to the Parent Item on the Sales Order by the Work Order Completion.
  18. The sales order Statuses were updated by the Work Order Completion.
  19. Ship Confirm (P4205) the Configured Parent Item
  20. Run Invoice Print (R42565)
  21. Run Sales Update (R42800).
    1. No entries were created for AAI 4270 Accrual Account 200.5175
    2. No entries were created for AAI 4280 Accrual Account 200.4190
Note: Accounts Referenced above are from internal demo data. No actual customer data has been referenced.

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
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.