USA

How to Transfer Invoice Tax Variances in Average Costing Organization

Oracle Payables will calculate Invoice Tax Variances when there is a non-recoverable tax that has been calculated at AP invoice entry that was not included on the Purchase Order.    In an average costing organization this tax variance should be transferred to the inventory valuation to ensure that the correct item cost is calculated.     Please see attached video for a demonstration of this functionality in Oracle R12.

Oracle R12 and Fusion Tax – US Sales and Use Tax, automating Over/Under Taxation

Some Third Party products automate the over/under handling of sales tax, if you have been charged too much or too little then an adjustment is made automatically. But why?

How often does this actually happen and would you not want to be in control of how the tax is handled instead of leaving it to be done automatically?

What if one of the lines was exempt from tax but that was somehow not captured on the invoice line as it was entered. An over/under solution would in fact deal with this incorrectly, making an adjustment on a transaction that was actually incorrectly entered thus ultimately costing you more in tax!

I am trying to get a feel for how important this requirement is so please respond to this blog posting with your views and opinions.

Oracle R12 Paches requried for eBiz Answers US Rates data file load

Patches for eBTax Upload Process Comments
Patch Number Description Category
Patch 9173819 VANITY CHANGES FOR TAX PARTNERS Upload Process
Patch 9724954 DATAFIX TO CORRECT THE DATA UPLOADED USING DATA UPLOAD Upload Process
Patch 9676886 ERROR IN ZXUPPROCESSDATA MODULE: E-BUSINESS TAX CONTENT UPLOAD PROCESS DATA PROG Upload Process
Patch 7623657 INCORRECT RECORDS ARE INSERTED INTO ZX_ACCOUNTS EBTax Tax Engine Tax Accounting Defaulting Logic
Patch 14544974 Patch to support CCH Tax Partner Data Upload Upload Process Latest version of the Upload Process
Patch 8747425 TAX NOT CALCULATING AFTER UPGRADING TO 12.1.1 FROM 11.5.9 DUE TO MISSING SETUPS eBTax Required for upgraded environments

Oracle R12 – US Geography data clean up

This is not an approved Oracle approach but if you need to clean up bad data from an 11i upgrade where you have all sorts of States, Counties or Cities then the flowing SQL could help you.

 

DELETE

hz_relationships

where subject_id IN (

select geography_id

from hz_geographies where created_by_module = ‘EBTAX_MIGRATION’

)

and subject_table_name = ‘HZ_GEOGRAPHIES’

;

 

DELETE

hz_relationships

where object_id IN (

select geography_id

from hz_geographies where created_by_module = ‘EBTAX_MIGRATION’

)

and object_table_name = ‘HZ_GEOGRAPHIES’

;

 

The last step must be the delete of the HZ_GEOGRAPHIES as it is used in the queries above

 

DELETE hz_geographies where created_by_module = ‘EBTAX_MIGRATION’

;

Oracle R12 US Geographies data cleanse before new load

If you have upgraded from 11i to R12 and have the misfortune to have brought across all the bad geographies for states through to Zip Code then the following SQL will allow you to remove this bad data to clear the way for a 3rd party data file such as one from TTR

 

 

DELETE

hz_relationships

where object_id IN (

select geography_id

from hz_geographies where created_by_module = ‘EBTAX_MIGRATION’)

and object_table_name = ‘HZ_GEOGRAPHIES’;

 

The last step must be the delete of the HZ_GEOGRAPHIES as it is used in the queries above

 

DELETE hz_geographies where created_by_module = ‘EBTAX_MIGRATION’;

is there an alternative to vertex, taxware for a data file to load geographies and selected rates?

We have now built a database that will allow you to choose what rates you want to load into your Oracle R12 and Fusion application. It will contain all the geography structure that is loaded into  the TCA from State to Zip-code and then you can choose the rates.

What we have done is provide the raw data so we don’t maintain all the rates on an on-going basis. So if you are running a 2 year project and need the geographies for tax validation and are happy with a blank tax rate of 1% so you can test then we have the solution for a fraction of the cost. When you then decide to go to a 3rd party, you simply end date our tax solution and load theirs but all the geography will already be in place ready for you.

Or if you are an entity that has few on no customers but wants to use a managed tax solution then we can provide you with the data so that tax is only calculated on the locations you want.

get in touch with us www.ebizanswers.net

Sales and Use Taxes: Exemptions and Exclusions California Revenue and Taxation Code Part 1, Division 2

Sales and
Use Taxes:
Exemptions and
Exclusions
California Revenue and Taxation Code
Part 1, Division 2
year – 2012

http://www.boe.ca.gov/pdf/pub61.pdf