PAXINRVW: Unable To Change Invoice Date To System Date When Releasing Invoice: Invalid invoice date. Please check the exception and enter a valid invoice date
(Doc ID 420077.1)
Last updated on OCTOBER 01, 2024
Applies to:
Oracle Project Billing - Version 11.5.10.2 and laterInformation in this document applies to any platform.
FORM:PAXINRVW.FMB - Invoices
Symptoms
Unable to place an invoice date as system date that is outside of the current open Projects (PA) and General Ledger (GL) periods. This error is retrieved:
ERROR
Invalid invoice date. Please check the exception and enter a valid invoice date.
The exception contains: "Could not create a valid GL date for provider"
STEPS TO REPRODUCE
System Date is outside the current PA and GL periods:
Example: SYSTEM DATE = 27-FEB-23
PA Periods:
STATUS PA Period Effective Date From Effective Date To
------ --------- ------------------ -----------------
Open FEB-WK4-23 18-DEC-2023 27-FEB-2023
GL Periods:
Status Period Name Start date End date
------ -------------- ---------- -----------
Open FEB-23 28-JAN-2023 24-FEB-2023
A draft invoice is approved. It is created with bill-through set to 27-JAN-23. Under Invoice Review for the transaction, click 'Release' which has:
Invoice Date = 27-JAN-2023
GL Date = 28-JAN-2023
GL period Name = FEB-23
GL Period Status = Open
Change the invoice date to 27-FEB-23 (today’s date) and click 'OK'. This results in error.
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 |