Monday 26 October 2015

Form Personalization (Purchase Order) : Show the Last Unit Price of the Item at PO Line Level.



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

1 comment:

  1. 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....
    Procurement Management Software
    Purchase Management Software
    e Procurement Management Software
    Best Procurement Software

    ReplyDelete

How to change Employee Number Generation from Manual to Automatic in Oracle HRMS (When attempting to apply for a job in iRecruitment)

When attempting to apply for a job in iRecruitment, the following error occurs: ERROR: You must enter an Application Number. Solution: How t...