E1: 42: Invoice Print (R42565) Does Not Calculate Due Date Based on Advanced Payment Terms (Doc ID 2464987.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Sales Invoice Print (R42565)
Standard Invoice Entry (P03B2002)

When Sales Invoice Print (R42565) is run against a Sales Order where the Advanced Payment Terms (AP2) would calculate a due date two months later on the 15th, it instead prints a due date that is the same as the invoice date.

Advanced Payment Terms Setup:

1. Create Advanced Payment Term AP2 
2. Based on Date = 1 (Invoice Date)
3. Days to add = 0
4. Fixed Days = 15
5. Months to Add = 2
6. Calendar = AP2
7. Work Day Rule = 1 (Working Days)
8. Other fields blank or 0
9. Test Simulator: "Work Day Calendar Not-Defined Error" appears

Sales Order Invoice Test (P4210/R42565)

1. Create a Sales Order for a customer with the Payment Terms set to AP2
2. Run the Invoice Print (R42565)
3. In the Invoice Print (R42565) PDF report it shows a blank in the Due Date
4. The client expects the Invoice to be due on December 15, 2018 based on the advanced payment term

Standard Invoice Entry Test (P03B2002)

1. Add a Sales Invoice for the Customer with the Advanced Payment Term AP2
2. The program responds with the "Work Day Calendar Not-Defined" Error
3. Invoice cannot be saved.

Cause

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