Transaction Date Validation
You can configure transaction date validation when you create inventory transactions.
Configure these profile options to enable transaction date validation:
- Set the Transaction Date Validation Enabled
(INV_TRANSACTION_DATE) profile options to one of these values:
- No validation: (Default) specifies no transaction date validation.
- Allow current date only: Transaction date must be the same as current date.
- Validate transaction date: Transaction date must be within an open cost accounting period.
- If you select No Validation for the Transaction
Date Validation Enabled (INV_TRANSACTION_DATE) profile option, you
must also enter a value for the Maximum Number of Days Prior to Current
Date (ORA_INV_TRANSACTION_CREATION_DATE_VALIDATION) profile option.
These two profile options work together.
For example, let's assume that the Maximum Number of Days Prior to Current Date ORA_INV_TRANSACTION_CREATION_DATE_VALIDATION profile option is set to 5 days and the current date is June 15th. If a transaction is entered with the transaction date as 1st June, the user will receive this error message:
You can't create the transaction because the transaction date is before 2023-06-10. Use Manage Inventory Profile Options setup task to update profile value.
Validation is supported for transactions created via FBDI and REST API.