My Oracle Support Banner

Invoice API Does Not Decrease Line Amount of Inclusive Tax for On-Account Credit Memo (Doc ID 2342996.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Receivables - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE API is used to create On-Account Credit Memo and pass AMOUNT_INCLUDES_TAX_FLAG := 'Y' at line level.
API is not able to create Line amount as inclusive tax, it is created as exclusive tax.
Line amount is not decreasing.

Example:
* In case of Tax Rate is 8% and Inclusive Tax

1. Set parameters for API as for Line Amount -1080 with inclusive tax
- QUANTITY_INVOICED = -1
- UNIT_SELLING_PRICE = 1080
- TAX_RATE = 8
- AMOUNT_INCLUDES_TAX_FLAG = 'Y' <-----Inclusive Tax

2. API has created On-Account Credit Memo with Incorrect Amounts.
- Line Amount: -1080    <--------- Tax Amount has not been decreased.
- Tax Amount : -80      <--------- Tax Amount has been calculated as Inclusive Tax
- Total balance : -1160

NOTE: these should be below:
- Line Amount: -1000    <--------- Tax Amount should be decreased.
- Tax Amount : -80      <--------- Tax Amount has been calculated as Inclusive Tax
- Total balance : -1080 <--------- Total balance should be same as the amount passed to API.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.