Oracle FA Initial and Periodic Mass Copy process

[@ayatelnabawy6696]

Hi Arvind, What is the accounting impact & calculation of running the (Deferred Depreciation) program for the tax book and its posted GL Journal with (Deferred Depreciation) category?

[@OracleEbizandFusionVideos]

In general, we set Post to GL as "No" for Tax book and hence in this case, this should not have any accounting impact as, this information is not passed to GL for financial reporting

[@PradhanSambit]

What are the reference numbers generated during asset creation?

[@OracleEbizandFusionVideos]

They are just system generated numbers

[@anshcx5]

Thanks, One question - how to transfer Tax book data to GL to keep it separate from primary ledger (as it will be double entry then) ? Or does system allow to attach secondary ledger with tax book?

[@OracleEbizandFusionVideos]

Ideally tax book is only for reporting and hence in general tax book data is not transferred to Primary ledger. But if there is a real requirement, you can attach a secondary ledger to tax book and then when you run Create Accounting for tax book, data gets pushed to GL Secondary ledger

[@anshcx5]

@@OracleEbizandFusionVideos Thanks a lot and really appreciate it !!

[@km0p]

Thank you, If Tax book and Corporate book are not in synch for some period, would running a periodic mass copy process work to bring back books to synch each other? Do we need to do anything else like data fix before running the process?

[@OracleEbizandFusionVideos]

Yes, running of Periodic Mass copy should bring both the books in sync

[@shaileshverma4354]

Very well explained..

[@OracleEbizandFusionVideos]

Thanks

[@barinismile4087]

Can we create Corp Book for one Ledger and Tax book for another ledger and link those two Corp and Tax Book ?? is this possible ?

[@OracleEbizandFusionVideos]

Yes, for one of our client, we have done the below... Corp Book is associated with Primary Ledger A... All Corp book entries are transferred to GL Primary Ledger A Tax Book is associated with Secondary Ledger A... All Tax Book entries are transferred to GL Secondary Ledger A Note:- in GL, Secondary Ledger A is set up under Primary Ledger A

[@revoltofficial7606]

While I'm doing mass copy for the month of April 20 I'm getting warnings as Amortization adjustment can't be copy tax books ( if there is a life change I'm not interested but there is a change in cost as well ) , why we r not copying any specific rules , any idea on this 🔥?

[@OracleEbizandFusionVideos]

Ideally in order for the cost to be copied from corporate book to Tax book, always the cost should be in sync... If there are any additional Cost adjustments in Tax book, then Periodic mass copy will not be able to copy the cost adjustments from Corp book to Tax book

[@sumitwani1906]

Thanks for such a informative video..Could you please post some videos on cash management and oracle FAH as well.

[@OracleEbizandFusionVideos]

Hi Sumit, I will try to post some videos on Cash Management in future. Unfortunately i did not work on FAH and hence i may not be able to post videos on FAH

[@OracleEbizandFusionVideos]

As requested, please see below video on Oracle Cash Mgmt:- kzbin.info/www/bejne/ooCWnWqQiayWrck

[@ssingh18]

Could you please clarify If initial mass copy copies accumulated depreciation from corp to tax book? I ran initial mass copy and can see there is some adjustment done in tax book post depreciation run in the tax book

[@OracleEbizandFusionVideos]

Initial mass copy copies only Cost. It do not copy accumulated dep. Reason being, you can have different depreciation methods in Tax book compared to that of Corp Book

[@ssingh18]

@@OracleEbizandFusionVideos thank you so much for your response. Could you please let me know what approach i can follow during conversion of tax book as I am unable to do the same using webAdI in case of tax book

[@OracleEbizandFusionVideos]

i hope assets already exists in corporate book. If so, run the initial mass copy and then if required update the cost in Tax book using cost adjustment API and then run depreciation in tax book

[@ssingh18]

@@OracleEbizandFusionVideos ok but there is no other way to copy assets in tax book from legacy system?

[@OracleEbizandFusionVideos]

@@ssingh18 No. As far as Ebs is concerned, there is no way you can upload the assets directly in Tax Book. Refer Oracle Support Doc id:-1411505.1 for further details