FORM PERSONALIZATION (PURCHASE ORDER).
Show the Last Unit Price of the Item at PO
Line Level.
Step : 1
Create From Personalization Name and Sequence.
Then chose Condition Tab
Trigger Event: WHEN-NEW-ITEM-INSTANCE
Trigger
Object: PO_LINES.UNIT_PRICE
Step : 2
Step : 3
= 'Last Unit Price' || ' Rs. ' || (select
to_char(unit_price)
from po_lines_all
where creation_date=(select max(creation_date)from
po_lines_all) and rownum=1
and item_id= (select distinct inventory_item_id from
mtl_system_items where segment1
=:PO_LINES.ITEM_NUMBER ))
Step :4
There are many interesting information included and i can easily understand all given information.I post something on my blog to post something, or wait to post something worth saying. Keep update more information....
ReplyDeleteProcurement Management Software
Purchase Management Software
e Procurement Management Software
Best Procurement Software