My Oracle Support Banner

Credit Memo On Account Settlement Create Tax Line as Write-off (Doc ID 1062728.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Oracle Trade Management - Version and later
Information in this document applies to any platform.


After having applied AR patch after AR patch (not TM) 9201956 had been applied customer was able to create credit memo on account by using interface with right amount , this was done without entering tax code at line level : which was request of customer

But one more issue persists :

Remaining point is that the tax amount is still displayed in claim settlement screen as adjusted by using write-off method which is not correct (it should be a tax line)

By the same way when doing :

Receivables > Collection > Account Details > Enter initial invoice number > retrieve invoice data
> activities button > the tax line is referenced as :
Class = Adjustment
Type = Line Adjustment

Note that the created credit memo looks ok.

Testcase is :

Test without populating Tax code

Receivable Manager > Transactions > Enter a transaction # 12382 > Amount = 860 with
taxes : (800 + 60) and with an item : AS18947
> Complete

Receivable Manager > Receipts > Create receipt : XX22122009002 > amount = 600
> Apply to transaction and (amount is set automatically to 860 in transaction application line)
> Update amount at value : 600 (i.e receipt amount)
> enter as Application Reference Type : Trade Management Claim and enter also an Application
Reference Reason : Unknown or Promotional
> Save > A claim number : DED12291 is defaulted

Receivable Manager > Transactions Summary > Select a folder with Dispute amount field
> Retrieve invoice with # 12382
> Dispute amount is set at value 260 which is coherent (860 - 600).

4. Oracle Trade Management User > Claims > Retrieve Claims with number DED12291

Line left link > the line amount = 260 = Claim amount and field : Type = Invoice and
Name = 12381 so the invoice is referenced

Do not enter any product as it lakes no sense

Select Settlement method : Credit Memo On account
DO not enter tax code = <Tax Code> (the one of initial invoice)
Select action"Calculate Tax and Adjust Line Amount".
Select "GO" button
Line amount is now : 241.86 which will sum up to 260 when VAT at 7.5 rate will be associated
Line tax code filed is now populated with the original invoice tax code : OK
Claim amount is 241.86 = accounted amount = 241.86
at claim line level

at header level :

Claim amount is 260 = accounted amount = 260

260 260

Do not associate Associate earning
Save > Request Approval
Status is Pending Close

At Header level

Currency US dollar US dollar
Amount 260.00 260.00
Amount Adjusted 0.00 0.00
Amount Settled 241.86 241.86
Remaining Amount 18.14 18.14

5. System Administrator > Concurrent Request > Run Workflow Backgroud process with Type =
OZF: Claims Settlement

Run SQL :

select *
from ra_interface_lines_all
WHERE interface_line_attribute1 like DED12291%'

to check that rows created in ra_interface_lines_all table (AR Invoice interface)

Receivable Manager > Interface > Auto invoice > Run import with selection including
the credit memo

Receivable Manager > Transactions > Retrieve transaction by using reference =
'Claim_Number' = DED12291
Credit Memo is created and completed

credit memo with amount = 260 = 241,86 + 18,14 of Tax

And in claim :
Amonut = 260

Amount Settled 241.86
Remaining Amount 18.14

9. Oracle Trade Management Administrator > Concurrent Request > run OZF-TM: Claims
Settlement Fetcher

10. Oracle Trade Management User > Claims > Open Claim with number DED12291

Status is closed
Amount Settled 260.00
Remaining Amount 0.00

So tax amount is passed as Write-Off it still works internally as it did before patch application


Applied AR patch (not TM) 9201956


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

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