ERPstuff - Oracle EBS Community

Hi there,
When we apply a receipt to any transaction in AR, we need to give a "apply date". The system will take the future date also even if we give. Can anyone suggest me how to avoid the system taking the future application date.

Regards

Hello.

Do you mean that you want to prevent users from entering a date in the future?
That can be done by using Forms Personalization. What is your version of APPS?

Octavio

The version of apps is 11.5.10.2....


Thanks

Hello.
Please try implementing this Form Personalization.
Open the Receipts Window and in the Menu choose Help/Diagnostics/Custom Code/Personalize
Enter the following information:
Seq=1
Description=Prevent future dates on receipt applications

Condition
Trigger Event=WHEN-VALIDATE-RECORD
Trigger Object= APP_FOLDER
Condition=:SYSTEM.RECORD_STATUS = 'INSERT' and :APP_FOLDER.APPLY_DATE > SYSDATE

Actions
Seq=1
Type=Message
Message Type=Error
Message Text=Enter a text of your choice, e.g. You cannot enter a date in the future.Please Re-enter.

Hope this helps
Octavio

I created that forms personalization, but I am not able to apply it as the "Apply now" button is inactive. Please suggest.

The Apply button only becomes active when you enter a Transaction number, a customer name or a customer number (in the main receipts window)

Octavio.

I am asking about the "apply now" button in forms personalization screen.


Thanks

Hello.
Forget about that button. Just save your work, close all forms, re-open the Receipts window and test if the personalization works. It is supposed the user to receive a message if he/she tries to save an application with Apply Date > today's date.

Octavio.

No luck. It is taking the future date.

Sorry sorry.. It is working perfectly. Thank you for your help.

Glad it worked!

Octavio