AR Adjustments : Details,setup, Flow, Accounting and API (Part -II)

Posted on September 5th, 2008 by Sanjit Anand | Print This Post | Email This Post

As mention in last post These adjustment API available in R11i and R12 with basic functionality via different API calls:

1. Creating an adjustment (R11i & R12)
2. Modifying an adjustment (R11i & R12)
3. Approving an adjustment (R11i & R12)
4. Reversing an adjustment (R11i & R12)
5. Create line level adjustment (This is only applicable in case of R12)

Details of Five Adjustment API's are herewith:

1. AR_ADJUST_PUB.CREATE_ADJUSTMENT : This routine can be used to create an adjustment for an invoice
2. AR_ADJUST_PUB.MODIFY_ADJUSTMENT : This routine can be used to modify an adjustment's status, comments and reason code .
3. AR_ADJUST_PUB.APPROVE_ADJUSTMENT : This routine can be used to approve an adjustment
4. AR_ADJUST_PUB.REVERSE_ADJUSTMENT: This routine can be used to reverse an adjustment
5. AR_ADJUST_PUB.CREATE_LINELEVEL_ADJUSTMENT: This Routine can be used to allow user to do line level adjustment. This is only specific to R12 .

While Choosing API..Do not get confused with Revenue Adjustment API's

There is difference between Revenue Adjustment API and Adjustment API, unless until you are not very familiar about the functional aspect of revenue recognition.

The Revenue Adjustment API provides an extension to the existing functionality of adjusting Revenue and Sales Credits through the standard AR (Accounting Receivables) Revenue Management form.

In Receivables, it is now possible to defer Revenue Recognition , and to earn the Revenue at a later date using the Revenue Adjustment. In this process, the API uses Auto Accounting to determine the accounts to be debited/credited with each operation. Sounds good...

What are those Revenue Adjustment API

The Revenue Adjustment API provides an extension to the existing functionality of adjusting Revenue and Sales Credits through the standard AR (Accounting Receivables) Revenue Management form.

As we know within receivables, it is possible to defer Revenue Recognition, and to earn the Revenue at a later date using the Revenue Adjustment. Therefore API uses Auto Accounting to determine the accounts to be debited/credited with each operation.

The Revenue Adjustment APIs are:

1. AR_REVENUEADJUST_PUB.UNEARN_REVENUE : This API used to move Revenue from the Earned Revenue Account to the Unearned Revenue Account using auto accounting.
2. AR_REVENUEADJUST_PUB.EARN_REVENUE : This API used to move Revenue from the Unearned Revenue Account to the Earned Revenue Account using auto accounting.
3. AR_REVENUEADJUST_PUB.TRANSFER_SALES_CREDITS : This API used to to transfer Sales Credits from any salesperson with Sales Credits on the transaction to any other salesperson.
4. AR_REVENUEADJUST_PUB.ADD_NON_REVENUE_SALES_CREDITS : This API used to add Non Revenue Sales Credits to any existing or new salesperson on a transaction .

Oracle Documentation

• 11i Oracle Receivables API User Notes - PDF format
• R12 Oracle Receivables API User Notes - PDF format

Similar Post

• The world of Oracle API
• API’s or Open Interface
• E-Business Suite Integration Repository
• AR Adjustments : Details,setup, Flow, Accounting and API
• AR Adjustments : Details,setup, Flow, Accounting and API (Part -II)