My Oracle Support Banner

WS: 42: With ECS = Y And Advanced Pricing, The Cancelled & Open Sales Order Line Doubles DMAAI 4230 Revenue Account Value At Sales Update - P42800, Ship Confirm P4205 Quantity (Doc ID 2562780.1)

Last updated on MAY 17, 2021

Applies to:

JD Edwards World Sales Order Management - Version A9.3 cume 1 and later
Information in this document applies to any platform.


When ECS is turned on in the System Constants, you have a Sales Order (P4211) containing an Advanced Pricing Adjustment and a portion of the original sales order line is canceled (due to not enough qty on hand), Sales Update P42800 still takes into account the canceled quantity and the open SO lines resulting in an incorrect DMAAI 4230 Revenue value. It should only report the value for the open line.

This does not occur when ECS is turned off = N in the system constants.

Steps to Duplicate:

1.  Set Item Master and Item Branch to not allow backorders for a newly created item.
2.  Set up a price on the item with currency turned on.
3.  Adjust P4112 quantity 1 into the system.
4.  Set sales order processing options to NOT hard commit and to NOT check availability.
5.  Enter a sales order for qty 2 of the item so both are shippable.
6.  Set processing options at ship confirm P4205 as follows:
    a. Options 11- 13 = 1 to check availability, prevent shipment from location with zero on hand, greater than the order qty.
    b. Option 19 = 1 to automatically backorder or cancel any remaining qty not shipped.
7. Ship Confirm the order for qty of 1. The remaining qty is canceled. Review the sales order to see the cancelled line.
8. Invoice the sales order.
9. Set Sales Update processing options to summarize journal entries and process in final mode.
10. Review the Sales Update Report.
   a. The DMAAI 4230 Revenue AAI account value is incorrect. The value is for the open and cancelled quantities. This should only be for the open quantity value.
11. Run the same test but turn off ECS in the system constants.
   a. At Sales Update the DMAAI 4230 Revenue AAI account value is correct.


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

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