restrict to receive material on back date

​@OWAIS.SARDAR ,

Option 1: Custom Validation (Best Practice)

Implement a validation in:

 Register Arrival / Receipt process

Logic:

IF arrival_date < po_release_date THEN
raise error;
END IF;

This can be done via:

• Custom event (Database Event Action)
• Custom validation in receiving logic

 This is the most reliable and commonly used approach

 Option 2: Database Event (No code change)

You can create a Custom Event on the receipt table (e.g., PURCHASE_RECEIPT / ARRIVAL related tables)

• Trigger: BEFORE INSERT / UPDATE

• Condition:

  :new.arrival_date < po_release_date

• Action:
  • Raise error message

 Option 3: Limited workaround (not strict)

• Use:
  • User permissions
  • Manual controls / process discipline

 But this does NOT enforce system restriction

 Why standard IFS allows this

IFS allows backdating because:

• Late registrations happen in real operations
• Sometimes goods are received physically earlier but registered later

 So system is flexible by design

 Best Practice Recommendation

✔️ Use Event-based validation
✔️ Show clear error message to user

Example:

“Arrival date cannot be earlier than PO release date”

Thank you for your appreciated reply. I sincerely thank you,Once we’ve implemented it, I’ll update you on the results