Skip to Main Content
Forums

Oracle Database Discussions

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!

API to split AR Invoice Distribution to multiple lines

BommiJun 4 2021

Hi Team,

Is there any API to split AR Invoice Distribution Line to Multiple lines?
Let me explain the requirement with example:
Created Manual AR Invoice for $100 (Single Line which has having Single Distribution) and say distribution account is 10100. Now, we want to split this Distribution line to 2 lines. Where first line is for same 10100 account with amount as 80% and other line is for 10200 account with amount as remaining 20%.

So, is there any API available to achieve this.

Thanks in Advance,
Bommi

Comments

SURFThru
You could make all the columns as parameters in the update stored procedure.

Then on your table adapter add the call to the update stored proc. Name the update prc_your_update_name. Then in your code you can just run ta.prc_your_update_name(field1,field2,....). Not sure if this is what you are looking for and maybe you want to avoid typing all the colunms as paramters.

Edited by: SURFThru on Jun 22, 2011 1:45 PM
1 - 1

Post Details

Added on Jun 4 2021
#general-database-discussions
7 comments
422 views