11i: Financial Tax Register With Modified Total Column Has Missing Decimal Places (Doc ID 344682.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version: 11.5.10 to 11.5.10.3 - Release: 11.5 to 11.5

Symptoms

Have created a new attribute set for the Financial Tax Register.
Have added 3 total columns for :-
-taxable amount
-tax amount
-total amount accounted

The format of the amount in the total amount accounted column, does not show the correct formatting.
There are no comma's to separate thousands and the decimal places do not show correctly, some amounts have no decimal places, some have 1 decimal place and others have 2 decimal places.
The other 2 total columns show the amounts correct.

STEPS TO REPRODUCE THE PROBLEM:
-------------------------------
log on as report exchange designer
navigate setup rxi
query back report name RX-only: Financial Tax Register
copy the default attribute set LAN Class, Tax Code, Supplier/Client, Date, Transaction to LAN Class,Code,Client,Date<Trx
Make sure that the copied attribute set is now displayed on the screen.
Change breaks and fields displayed, as follows :-
1 - Company
2 - Tax Class
3 - Tax Code
-billing partner name
-tax registration number
-transaction date
-transaction number
-transaction class
-taxable amount
-tax amount
-total amount accounted
-tax line effective tax rate

After changing breaks, delete Taxable Amount and Tax Amount and add back so proper subtotals will be available in next window

Click on column details
change columns as follows:-
Company attribute name change to Office and length 6
Tax class length 9
Tax code length 15
Billing partner attribute change to Supplier/Client
Change Total Amount Accounted attribute name to Total length 18
Change Tax Line Effective Tax Rate to Effective tax rate length 10
Check the sum boxes for taxable amount, tax amount and total
Change transaction number to ascending
save changes

For Taxable and Tax Amounts, add Report Total and change Prompts
click on column details
highlight taxable amount line
click on sum details
change Total to Office Total
Change Total to Tax Class Total
Change Total to Tax Code total
Repeat above for Tax amount and Total columns

Change attribute set Page Setup as follows :-
Report Title is Financial Tax Register (Class, Tax Code, Supplier/Client, Date, Transaction)
Group display type = Group left
page height = 45

Log in as receivables
Navigate reports, tax
Run the report and select the new attribute set Lan Class,Code,Client,Date,Trx

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