Payables and Cash Management - EBS (MOSC)

MOSC Banner

warning meaaage if supplier having invoice in same date

edited Mar 8, 2018 9:15AM in Payables and Cash Management - EBS (MOSC) 11 commentsAnswered ✓

Hi Team,

User wants a notification or warning message while entering invoice if the supplier having invoice in same date.

I tried with form personalization.

Condition:-

exists(

select 'X'

from ap_Invoices_all

inv where ${Item.inv_sum_folder.invoice_id.value} is null

and inv.INVOICE_DATE=: INV_SUM_FOLDER.INVOICE_DATE

and inv.Vendor_id=${item.inv_sum_Folder.VENDOR_ID.Value})

Thanks in Advance,

Regards,

Ramesh

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center