Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to sum PO lines' quantity in form personalization

HarikanthKonetiDec 12 2024 — edited Dec 12 2024

Hi Folks,

Hope you're doing well…

I need your help regarding one requirement in form personalization.

Scenario is: While creating a receipt for a PO (which has multiple lines) at header level we have DFF and one of the fields(let say attribtue2) is to enter net quantity we received and then when we choose a single PO line or multiple PO lines. Total quantity of lines should match with the net quantity we have entered at header level. if not matching we should show message and do not proceed on receipt creation.

EG: Let say PO has 4 lines.

  1st line has 100 quantity

  2nd line has 200 quantity

  3rd line has 300 quantity

  4th line has 400 quantity

Now i want to create receipt for first two lines. so if i enter total quantity at header level dff field i.e. attribtue2 as 150 and selected(check box) first two lines and click on save button to create receipt then an error message should populate as total quantity 150 is not matching with lines quantity 300.

Kindly help me regarding this.

Thanks,

Hari

Comments
Post Details
Added on Dec 12 2024
0 comments
137 views