Mass addition with multiple asset books
Date: Sat, 17 Jul 1999 11:25:37 +0400
From: Chetan Banglorewala ChetanB@allied-medical.co.ae
Subject: FA - Mass Addition Create program
Hi FA Experts,
We are implementing GL, FA & AP on 10.7 SC.
We have a single set of books with 4 companies in General Ledger, with
Company as the balancing segment. However, we have 4 Asset Books in Oracle
Assets all pointing to the same GL Book. We have defined asset categories
and attached the books to the asset category. Each book has a different
clearing account, as each company is a balancing unit
We entered transactions in AP for different categories and also pointing to
clearing accounts for each of the company. When we run the Mass Addition
create program, it prompts for Book Name. In case we enter Book - Co 1, all
asset transactions, even for other companies are created in Book - Co 1.
I would like the system to pick up only transactions for book - Co 1. This
will enable me to run the program separately for each book/company.
Is this the standard functionality or a bug. Is there any patch to resolve
this issue. I assume that
I am posting this query again as I did not receive any response to my
previous mail. Any help shall be appreciated
Thanks in Advance.
Regards,
Chetan
Date: Sat, 17 Jul 1999 18:09:27 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
Subject: Reply: FA - Mass Addition Create program
Hi Chetan
Correct me if I am wrong. I understand your query thus:
1. You have one SOB with 4 balancing segment values representing companies.
2. You have created 4 Corporate Books in FA, one for each balancing segment
value. Ofcourse, all these 4 books point to the same SOB.
3. You need to segregate asset creation by Company and hence by Corporate
Book (in your setup).
4. The Mass Additions process picks up the distribution lines for ALL
balancing segment values (With Clearing Accounts) and populates the
FA_MASS_ADDITIONS table pointing to ONE Corporate Book (the one that you
selected while entering the parameters in the MAss ADDitions Create
Program).
FA is segmented by SOB, not by a balancing segment value of your AFF.
Considering this, your need to maintain assets by company (which are nothing
but values in the balancing segment) cannot be met effectively - atleast in
the manner in which you want it. For, when you run the MAss Additions Create
program in AP, it will pick up all those distribution lines which have the
"Track As Asset" flag set to "Yes" - irrespective of the balancing segment
value you may have entered in the code combination. Obviously therefore, AP
needs to populate ANY Corporate Book that you may have. And this is where
your problem begins.
The solution may lie in a judicious defenition of Asset Categories. Which
you seem to have done. What I am proposing here is just a thought. I haven't
tested it at all. However, if its gets you going in the right direction,
I'll be glad!
1. Have you defined ALL possible categories for EACH Corporate Book? For
example:
- Plant 1 (Corporate Book 1/Company 1)
- Plant 2 (Corporate Book 2/Company 2)...and so on.
This ensures that all categories are setup with account combinations
remaining the same, depreciation remaining the same but the nomenclature
differing.
2. When you prepare Mass Additions in FA, you DO NOT select a Book, but you
do select a category. Post the asset information as it comes.
3. Transfer the Asset to a different category (the one for the company in
question.) It should now point to a different book. I am not too sure about
this - but as I said - just an idea off the top of my head.
It does seem possible since all corporate books point to a single SOB. So
there will not be a different accounting impact.
Another solution, though tedious, could be:
1. When you enter invoices in AP for assets, belonging to different
corporate books/companies, ensure that you approve these invoices by
company, transfer to GL and create Mass Additions. Then get to the next set
of invoices and so on. This will ensure that you populate the
FA_Mass_Additions table Corporate Book-wise. And hence Mass Additions in FA
will become that much more easier and systematic.
Hope this helped. Do get back to me on the solution you have finally decided
upon. And I'll try to lay my hands on a Test instance and check it too.
Cheers
Ananth
Senior Applications Consultant
Date: Sun, 18 Jul 1999 08:35:44 +0400
From: Chetan Banglorewala ChetanB@allied-medical.co.ae
Subject: RE: Reply: FA - Mass Addition Create program
Hi Ananth,
I would like to thank you for such a detailed reply.
The first option you suggested will require too much efforts as we have
about 400 asset categories. Further, an asset created in one book can be
transferred to another category, but not a different book. Hence, I will
have to operate with 1 book only, which may be not possible in the existing
scenario..
Mot probably, we will have to go for option 2 i.e. entering invoices in
batch (by Companies) keeping in view the number of transactions we shall
have for new additions.
My intention was too double confirm, that the mass addition create program
is working normally and that there is no bug/patch. Your reply has
reconfirmed by position.
Thanks & regards,
Chetan.
From: ravi chandran [SMTP:johnny_ravi@hotmail.com]
Sent: Monday, July 19, 1999 6:59 AM
Subject: RE: Reply: FA - Mass Addition Create program
Hi chetan,
All ur steps are ok. But mass addition transfer from AP will
transfer
details of all companies. Hence, you give a responsibily for each
company in
AP and give security. When mass addition is done for each
responsibilty the
relevant companies addition will come to FA.
thanks,
Ravi
Date: Mon, 19 Jul 1999 11:10:36 +0400
From: Chetan Banglorewala ChetanB@allied-medical.co.ae
Subject: RE: Reply: FA - Mass Addition Create program
Hi Ravi,
I tried to use Security rules and different responsibility, but I observed
the following,
1. I defined security rule "Only Co 2" and assigned to a new
responsibility. When I enter invoices using this responsibility I could
still enter distribution account with Company 1 and approve the same. Hence,
it seems security rules do not apply in AP.
2. Further, I entered invoice for Co 1 using Responsibility A (without
any security rule) and invoice for CO 2 with Responsibility B (with security
rule). I then ran the Mass Addition Create program for Book Co 2 from
Responsibility B. However, it created asset lines for both companies.
Any other ideas.
Thanks
Chetan
Following is a mail sent to the list as reply to similar query of a different
person
Subject: Re: FA - Depreciation Books
From: William Platt wplatt@csac.csac.com
Date: Wed, 01 Dec 1999 09:38:23 -0600
I have never done this, but I have thought about it.
If you have three separate corp book, you will have to
setup your categories for each book. What I would do
is set up different clearing accounts in the categories for each
corp book. This way when you ran the mass additions create
and selected the book (choice of the three) then (in theory)
only those with the clearing accounts for that book would be picked up.
(this assumes that the correct clearing account is entered in AP/PO).
The only question I would have is how Oracle might flag those
that where not transferred. My gut feeling is that it should work.
Of course this does not address your security issues.
Just my thoughts