E1: 03B: Stats History Refresh (R03B16A) Incorrectly Updates The Amount of Last Payment (ALP) Field In The F03B16S Table For Receipts That Include Negative Pay Items (Doc ID 2440733.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

Currently, when Statistical History Refresh (R03B16A) is run for a customer who paid the balance of an invoice which had two pay items, one positive and one negative, the Amount of Last Payment (ALP) in the A/R Statistical Summary table (F03B16S) shows only the amount of the positive pay item, and not the amount of the receipt.

For example invoice 123 has the following two pay items with gross and open amounts as indicated:

001    245.99-

002 1,791.62

Invoice's total gross/open amount is 1,545.63. A receipt is created for this amount. After R03B16A is run, ALP incorrectly shows an amount of 1,791.62 instead of the actual receipt amount of 1,545.63.

Other fields, such as High Balance Amount (AHB), Invoice Amount (AG), Sales Amount (SAG), Invoiced This Year (ASTY), Payment Amount (PAAP), and Paid Late (AIPL) correctly show the 1,545.63 amount, including the negative pay item.

Cause

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