11i: Financial Tax Register With Modified Total Column Has Missing Decimal Places
(Doc ID 344682.1)
Last updated on JUNE 05, 2018
Applies to:Oracle Receivables - Version: 11.5.10 to 22.214.171.124 - Release: 11.5 to 11.5
Have created a new attribute set for the Financial Tax Register.
Have added 3 total columns for :-
-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
-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
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!