Oracle FA Mass Additions process

[@jagannathan1706]

This video really cleared my doubts on mass additions 😊 Thanks a ton sir !! great job. Will go thru the FA videos to understand the complete process .

[@OracleEbizandFusionVideos]

Thanks for your feedback

[@koushikghosh5113]

Your videos have been really helpful. Pls keep up your good work!

[@OracleEbizandFusionVideos]

Thanks a lot for your feedback

[@neelpadhy]

Very Nicely Explained . Keep helping people.

[@OracleEbizandFusionVideos]

Thanks for your feedback

[@moheebmerchant2542]

Excellent explanation 👌, thanks sir.

[@OracleEbizandFusionVideos]

Thanks for your feedback

[@jobombeo4570]

Which actions can be performed if you forget to track assets and you also forget to use the asset clearing account in oracle R12 is it possible to rectify or amend the invoice after its creation?

[@OracleEbizandFusionVideos]

You can cancel the invoice (If payment is already created, then you need to cancel the Payment as well) and then re-create a new invoice with proper details

[@jobombeo4570]

@@OracleEbizandFusionVideos thank you Sir

[@swarapanchal6368]

Can we transfer location of CIP asset to another location before capitalisation

[@OracleEbizandFusionVideos]

I believe it should be possible... Take a example, you are building a machinery (which is a CIP Asset) and you might have a business requirement to move it to a different city before it gets capitalized...

[@raziasultana2928]

beautifully shown thanks

[@OracleEbizandFusionVideos]

Thanks

[@amarena2000]

Hi Arvind, Thanks for the video!!! Your videos have been really helpful I add one Fix Asset Invoice in AP and pay it with Discount. Then we start in FA Create Mass Additions Request. Request generate correct Fix Asset in FA with discount line. Then I start Create Accounting - Assets Request for Primary and Secondary Books. in Primary book post a correct Account for Discount Taken in GL as soon as in AP/Finances Options (see a Screen Shot) in secondary book post a false account. Do you know, how can i set up it, so that it will be post the same account as soon as in Primary book??? Thanks in advance.

[@OracleEbizandFusionVideos]

Can you let me know whats your GL Primary to GL Secondary ledger mapping as far as Natural Account segment is concerned?

[@MohamedKamal-io5gn]

I have ebs modules working ap, ar, from 5 years then recently setupped the assets module, and uploaded all the assets which includes old and new assets using webadi, without creating invoices offcourse, how can I make sure that every thing is going well with no errors.?

[@OracleEbizandFusionVideos]

After your asset is added, run Asset Additions report to check your asset details, run depreciation, run create accounting and check your journal entries to ensure that every thing is fine...

[@MohamedKamal-io5gn]

@@OracleEbizandFusionVideos thanks a lot, very helpful

[@ghodighosh9050]

Great video!!!

[@OracleEbizandFusionVideos]

Thanks

[@NitishKumar-ly5ke]

Hello Arvind thanks for uploading videos and knowledge sharing can you please add more related to FA how to add cip through payable Nd How to transfer cip to capitalize and mass copy, periodical mass copy, Initial mass copy and how to copy in tax book through corporate FA book.

[@OracleEbizandFusionVideos]

Sure Nitish.. Stay tuned to my channel

[@OracleEbizandFusionVideos]

Hi Nitish, Based on your request, today, i had uploaded a video on how to add CIP Asset through AP:- kzbin.info/www/bejne/p6ebmaFtZ92KZ5I

[@OracleEbizandFusionVideos]

Based on your request, created a video on Initial and Periodic Mass Copy:- kzbin.info/www/bejne/bYS3nHyqmqhra7c

[@pixelangle7488]

Dear Sir, If we had posted mass addition already and then we realize that the particular invoice does not that posted asset and we want to change it. How can we do that?

[@OracleEbizandFusionVideos]

You need to update the Invoice distribution account (after reversing the existing invoice distribution line) and then rerun Mass additions process

[@pixelangle7488]

@@OracleEbizandFusionVideos Thanks Sir. Your Guidance helps to resolve so many problems. Please let me know how I can post a fixed asset from Journal voucher using mass addition. If we cannot, what is the other way to post it in Fixed asset module.

[@OracleEbizandFusionVideos]

@@pixelangle7488 are you saying you want to push FA assets via Mass Addition from GL?

[@pixelangle7488]

@@OracleEbizandFusionVideos Yes Sir. Is there any way doing that or i have to do manually.

[@OracleEbizandFusionVideos]

There is no Mass Additions process from GL... But you can upload Assets via Web ADI

[@ninadkulkarni3358]

Nice video Arvind! One doubt : once asset is created for a perticular Ap invoice, how does payables knows asset is created? How system make sure, same invoice is not picked next time we run mass addition create process?

[@OracleEbizandFusionVideos]

Hi Kulkarni, once FA Mass Additions process is ran and the data is pushed to FA, behind the scenes, it will already flagged in the tables as transferred to FA and hence next run of FA Mass Additions process will not pick this invoice.

[@ajitkumarsamendla5464]

Hi Aravind i have one doubt If you enter the asset with in FA module how will asset clearing account get knocked off.

[@OracleEbizandFusionVideos]

In general, when you purchase a asset, its entered via AP where FA Clearing Account is debited and after Mass Additions in FA, FA Clearing account is credited and thats how FA Clearing account is knocked off. But if you manually add asset in FA, FA Clearing account needs to be manually knocked off by passing a manual journal entry in GL

[@PavanVasireddy-tl2qr]

Hi Sir, (1)My question is I don't want move tax line to FA work bench (move only asset actual cost) through mass addition, how can we control? (2) Can we treat tax line also asset in FA work bench

[@OracleEbizandFusionVideos]

1. If you do not want to send Tax line to FA, then Probably try to uncheck "Track as an Asset" check box for the Tax line in AP Invoice Line Distributions and then run FA Mass additions process and check that the Tax line will not be pushed to FA 2. If you want to push Tax line as well to FA, then ensure that "Track as an Asset" checkbox is checked for that line in AP Invoice Line distributions and then run FA Mass Additions process to push this tax line to FA... With this approach, both Actual cost and Tax line both are capitalized and system will start calculating depreciation on entire Cost + Tax amount

[@zohnbon]

Capitalization in 1Jan2018 how?

[@OracleEbizandFusionVideos]

Nice observation... This being a test environment, Jan-2018 period was still not closed in FA and hence capitalized the asset in current open period which is Jan-2018....but in real world and live environment, AP and FA Periods are closed on time and you will not see this kind of scenario

[@r.ptechnologies2052]

Thanks

[@OracleEbizandFusionVideos]

Welcome

[@azadsable2527]

Hello , Profound one. Could you please upload the videos to show how amortization and Expense worked in Assets in Oracle in details

[@OracleEbizandFusionVideos]

Hi Azad, Based on your request, i had created video on FA Amortization vs Expensed Adjustment. See below:- kzbin.info/www/bejne/a3TLXmerns6BY6s

[@PawanKumar-ez8lt]

Hi Arvind, Thanks for the video. 1.Is it mandatory to select Asset book at AP lines/distributions level even though Track as Asset is enabled ? 2. In my current client we have two assets books which are appearing in LOV how we can default one book ? 3. If already invoices is accounted and transferred to GL still can we add asset book to that particular invoice to transfer it to FA? Thanks in advance.

[@OracleEbizandFusionVideos]

Hi Pavan, please see below my responses to your questions:- 1. Its not mandatory to select Asset book at AP Lines/distributions... Entering of Asset clearing account is enough 2. Unfortunately, as a standard functionality, its not possible to default particular Asset book... User need to manually enter the same 3. I never tried that... but i think system may not allow...

[@PawanKumar-mg1bz]

thank you

[@OracleEbizandFusionVideos]

You are welcome

[@cajoncoverjammings]

Hello.. can we do mass upload from project? From Queue: NEW to POST

[@OracleEbizandFusionVideos]

Do you mean you want to know if you can perform mass update of all the records in FA Mass additions from Queue "NEW" to "POST"?

[@cajoncoverjammings]

@@OracleEbizandFusionVideos Yes can you do that in mass upload?

[@azadsable2527]

How YTD Balance calculated in FA?

[@OracleEbizandFusionVideos]

YTD balance is calculated based on FA calendar assigned to FA Book

[@azadsable2527]

@@OracleEbizandFusionVideos It will be total depreciation charged for the asset in that fiscal year. When new fiscal year starts YTD resets to 0. If you Fiscal year is from Apr-Mar and you are taking cut off date as Jan then You should provide YTD if you are uploading the deprn reserve(accumulated depreciation ), right?

[@OracleEbizandFusionVideos]

@@azadsable2527 yes, you are right

[@sandeepkamble495]

Sir, when I am trying to run post mass addition program. I am not getting my corporate book in parameter. Could you please help me with this

[@OracleEbizandFusionVideos]

Was your create mass additions successfully in AP. Also, check if the data exists in FA_MASS_ADDITIONS table from backend for your corp book. Also, check if corp book is coming in LOV when you navigate to asset workbench

[@Raj-xw1lv]

Sir m waiting for your amortization of assets video ?

[@OracleEbizandFusionVideos]

Sure. I will let you know once i create the same

[@ismailrajiwate9565]

The explanation could be better if Included P2P cycle that is Asset item Definition, PO booking, defaulting the FA clearing A/c, PO matching with Invoice and then mass addition...

[@OracleEbizandFusionVideos]

Thanks for the feedback.... My focus in this video is only for AP to FA cycle.... But i will try to upload another video in future to include P2P cycle as well

[@zohnbon]

Create mass addition in 22jun2018

[@OracleEbizandFusionVideos]

Refer my response to your other post