My Oracle Support Banner

E1: 42: Sales Order Line with Zero Price Creates Line In Accounts Receivable (F03B11) After Installing Fix for Zero Amount Pay Status (Doc ID 2693151.1)

Last updated on JULY 28, 2020

Applies to:

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

Symptoms

Sales Update (R42800) is creating separate pay items in the Customer Ledger (F03B11) for sales lines with zero amounts even though Sales Update (R42800) Summarization Tab Option #1 (Summarize A/R entries by Invoice) is set to 1 (Summarize A/R entries by Invoice). This happens if Defaults Tab Option #6 (Pay Status Code for Zero Amount Pay Items) is set to P (Paid) on the Invoice Entry MBF (P03B0011). This problem appeared after applying the ESU for Enhancement 10783889 which introduced the new processing option.

The issue can be reproduced at will with the following steps:

  1. Create a Sales Order with four lines. Two lines have amounts greater than zero and two lines have amounts of zero.
  2. Create a new Version of Invoice Entry MBF (P03B0011) and name it ZERO.
  3. Set Defaults Tab Option #6 (Pay Status Code for Zero Amount Pay Items) to P (Paid).
  4. Create a new version of Sales Update (R42800) and name it ZERO.
  5. Summarization Tab Option #1 (Summarize A/R entries by Invoice) is set to 1 (Summarize A/R entries by Invoice).
  6. Set Versions Tab Option #1 to ZERO.
  7. Process the order through Sales Update (R42800) calling the version of Invoice Entry MBF (P03B0011) that sets amounts of Zero to Pay Status “P”. The Sales Update (R42800) PDF report shows the AR WAS Summarized from 4 sales order lines into 2 accounts receivable lines.
  8. The Customer Ledger Inquiry (P03B2002) shows the two lines with positive amounts have Pay Status = “A” because the Amount of 5,500.00 has not been paid. The two lines with zero amounts were also summarized but have Pay Status = “P” because they cannot be summarized with Pay status “A” lines and must be on their own pay item line.


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.