E1: 31B: Wine Premises Report R31B5120 Displays Multiple Lines for a Single Operation (Doc ID 1985161.1)

Last updated on DECEMBER 10, 2015

Applies to:

JD Edwards EnterpriseOne Blend Management - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Symptoms

E1 9.1 / P31B5120 Wine Premises Report Preview

The Wine Premises Report Preview calculates/displays multiple lines for a single operation each line with the same Orig Lot Quantity.  
The F31B66 will contain multiple records for a single operation if the operation lot contains more than one EUR.  A record is written to the F31B66 for each EUR.
However, because each record (for the same operation number) contains the same Orig Lot Quantity from each record, the quantity on the report is doubled, tripled, etc.

If the sum of the F31B66 Units value on each record for each operation is used (instead of the Orig Lot Quantity), the report value would be correct.
Or, Use the Orig Lot Quantity value but write only one line to the P/R31B5120.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms