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

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Trade Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
Checked for relevance on 11-May-2013

Symptoms

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

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

2.
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 (ie 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

3.
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 : Crediot Memo On account
DO not enter tax code = QCPST (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



6.
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)

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

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

Effectively i get a 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
and
Amount Settled 260.00
Remaining Amount 0.00

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


Changes

Applied AR patch (not TM) 9201956

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms