E1: 45: Address Type Invalid Error (1020) in Check Price and Availability (P4074) (Doc ID 2214340.1)

Last updated on JANUARY 10, 2017

Applies to:

JD Edwards EnterpriseOne Advanced Pricing - Sales - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Check Price and Availability (P4074)

When attempting to retrieve prices from the Ship To Address (4244) using the Check Price and Availability (P4074) inquiry, the related Sold To address is not retrieved and instead, the Ship To Address is populated in the Sold To field and the following error occurs.

ERROR
Address Type Invalid Error (1020)

CAUSE . . . . You have entered an address number in the sold to field, but that address number is coded as a ship to only address in billing instructions. Or you have entered an address number in the ship to field, but that address number is coded as a sold to only address in the billing instructions.

RESOLUTION. . If no address number was entered in the highlighted field, the system will default an address based on the related address in billing instructions. This default address may be coded as a specific bill to or ship to and is not valid for the address it is defaulting to (see above).

When attempting to retrieve prices from the Ship To Address (4244) using the Sales Order Entry (P4210 or P42101) programs, the related Sold To address is retrieved from the Ship To as expected.

Client is upgrading from World where P4074 and P4210 both worked without an error using this setup.

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

  1. Address 4244 is setup with Billing Address Type (BADT) S (Ship To Address Only) in Customer Billing Instructions (P03013).
  2. Address 4244 is setup with Related Address 5 (Factor Payee) in Customer Billing Instructions (P03013).
  3. Address 4244 has Related Address 4242 set as Factor/Special Payee on the Related Address Tab of Address Book Revisions (P01012)
  4. Address 4242 is setup with Billing Address Type (BADT) B (Sold To Address Only) in Customer Billing Instructions (P03013).
  5. The user enters Check Price and Availability (P4074) program and populates Ship To Address, Branch Plant and Item Number, leaving Address Number blank and clicks the Find button.
  6. The Ship To Address 4244 is pulled into the Address Field instead of the Related Sold To Address 4242.
  7. The Address Type Invalid Error (1020) is displayed on the Address Field because 4244 is a Ship To Address only.
  8. If the user goes into Sales Order Entry (P4210 or P42101) and populates Ship To Address, Branch Plant and Item Number, leaving Address Number blank and clicks the Find button, the address 4242 is correct;y pulled in to the Sold To Address field and the error is not issued.

 

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