tag:blogger.com,1999:blog-6484465525647257447.post661253650331662305..comments2024-01-17T05:41:50.098-08:00Comments on Oracle Intercompany Financials: New Intercompany features in R12David Haimeshttp://www.blogger.com/profile/08553294104727744220noreply@blogger.comBlogger32125tag:blogger.com,1999:blog-6484465525647257447.post-11854863678213158932007-12-04T11:53:40.000-08:002007-12-04T11:53:40.000-08:00We create 'real' invoices in the receivabl...We create 'real' invoices in the receivables payables applications of the sender and receiver.<br><br>So the receiver who needs a hard copy can do an invoice print form their own payables - which should satisfy the legal requirement as it will have all the appropriate tax registration numbers on it etc. I would imagine this is the best solution.<br><br>If they want they can ask the sender to print the invoice from their receivables system, or they could use iReceivables to print the invoice off themselves form there.davidhaimeshttp://davidhaimes.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-41376818012459121712007-12-04T07:06:58.000-08:002007-12-04T07:06:58.000-08:00Hi David,I have a question on your first bullet po...Hi David,<br><br>I have a question on your first bullet point (Creation of Documentation (ie. Payables and Receivables Invoices) for AGIS transactions).<br><br>In R12, can these invoices be printed when we enter an I/C transaction in AGIS as physical back-up (as some countries require this)? Is this what you mean my "documentation"?<br><br>If so, what is this invoice/report called in R12 and where would it be available (e.g. AGIS)?<br><br>Thank you for your help! <br>LeslieLeslienoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-31571251362674227982007-12-05T03:02:59.000-08:002007-12-05T03:02:59.000-08:00Hi David,Let me make sure I understand. So an in...Hi David,<br><br>Let me make sure I understand. So an invoice is created in the receiver's AP and sender's AR? A hard copy would need to be printed from sender's AR then as there's no invoice print in AP. Isn't that right? If this is the case, then wouldn't you be double-booking your journal entries (one from AGIS to GL and another from AP/AR to GL)?<br><br>Thanks again!<br>LeslieLeslienoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-23496939408506014002007-12-05T03:04:38.000-08:002007-12-05T03:04:38.000-08:00Hi David,Another question on R12 AGIS..There's...Hi David,<br><br>Another question on R12 AGIS..<br><br>There's an enhancement request (bug #4260174) which basically requests that users be able to manually enter a foreign currency exchange rate (ie, "User" rate type) in intercompany transactions in GIS. I see a note in the R12 AGIS documentation that user rate is still not possible.<br><br>What is the reason behind not allowing users to manually enter rates in GIS? Any future direction on this?<br><br>Thanks!<br>LeslieLeslienoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-44678438969803040952007-12-05T03:19:54.000-08:002007-12-05T03:19:54.000-08:00This is a good idea for a future post/posts.It is ...This is a good idea for a future post/posts.<br><br>It is a contentious issue, there could be a compliance issue there - am I trying to keep more profits in my LE as it is low tax, so I use the correct transfer price but inflate the profit with the exchange rate. You also will give yourself problems when you consolidate balances as the rates don't triangulate. The other problem is I put a rate on that you don't like so you reject it and that slows the whole process down.<br><br>I would like some detailed business cases for doing this - contact me directly if you prefer. We can discuss with some of our domain experts as so far our feeling has been it is not something we want to open up, but no final decision has been made.davidhaimeshttp://davidhaimes.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-82033406548997233602007-12-05T03:29:32.000-08:002007-12-05T03:29:32.000-08:00I wasn't aware there was no invoice print in A...I wasn't aware there was no invoice print in AR, but you may find a screen print is sufficient as long as contains all the items requires, tax ID, invoice number etc. Or yes you may need to do an AR invoice print.<br><br>Maybe invoice print is an ER for AP :)<br><br>regarding double booking this does not happen. It goes from AGIS either to GL or to AR/AP, but never both.<br><br>Thanks<br>Daviddavidhaimeshttp://davidhaimes.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-53894777932655236822007-12-05T05:03:18.000-08:002007-12-05T05:03:18.000-08:00Hi David,Thanks.In terms of currency, the scenario...Hi David,<br><br>Thanks.<br><br>In terms of currency, the scenario could be that one company funds another company resulting in IC transactions. These transactions should be entered in the exchange rate that was used to fund the other company to accurately reflect the rate that was used to clear the bank. So users would need to enter this transaction in GIS using the exchange rate that was used for funding..<br><br>Any idea how this can be handled?<br>Thanks again!!Leslienoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-190589945018451922007-12-05T07:40:35.000-08:002007-12-05T07:40:35.000-08:00To clarify your example are you saying - I loan th...To clarify your example are you saying - I loan them 1,000 EUR from my USD bank account and so have a cleared rate from the bank on that ? I send an IC trx to them in EUR and want to add the bank rate on that?<br><br>What if my ledger currency is say CAD, what rate do I use then?davidhaimeshttp://davidhaimes.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-19739198344455674722007-12-05T10:03:52.000-08:002007-12-05T10:03:52.000-08:00Ledger currency = USDSend 1,000 EUR from my USD ba...Ledger currency = USD<br>Send 1,000 EUR from my USD bank account to an entity that's in EUR ledger currency<br><br>I want to enter this IC trx in GIS in EUR and manually enter the exchange rate that was used for this transfer (the rate that was used to clear the bank account).Leslienoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-34946192075525174852007-12-05T13:04:08.000-08:002007-12-05T13:04:08.000-08:00For your example - I would create the AGIS transac...For your example - I would create the AGIS transaction in USD for whatever USD cost I incurred.<br><br>Doing it in EUR with a user rate raises tough questions:<br><br>So I am the recipient in the UK and my ledger currency is GBP, what rate do I use?<br><br>Consolidation will become a problem, my GBP is consolidated first to EUR with all of EMEA and then that EUR is consolidated to USD for group reporting. How do I get the rates to make sure when my GBP amount finally gets to USD it equals your USD amount?davidhaimeshttp://davidhaimes.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-80374236856053359992007-12-06T14:00:07.000-08:002007-12-06T14:00:07.000-08:00[...] Rate to use for Intercompany Posted on Dece...[...] Rate to use for Intercompany Posted on December 6, 2007 by davidhaimes Leslie posted some excellent comments, which touched on the exchange rates to use on intercompany transactions, a very interesting and [...]What Exchange Rate to use for Intercompany « David Haimes Oracle Intercompany Financials Bloghttp://davidhaimes.wordpress.com/2007/12/06/what-exchange-rate-to-use-for-intercompany/noreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-26311391690435783652007-12-11T00:41:36.000-08:002007-12-11T00:41:36.000-08:00Hi David,What if you only have two currencies invo...Hi David,<br><br>What if you only have two currencies involved in the transaction? <br><br>Also, I read that in R12 Cash Management, you can do bank account transfers between legal entities (IC transaction) which would then create a payment request in AP. How would the system handle currency rates if there are three currencies involved in this scenario? <br><br>I also read that you can create legal entity exceptions in R12 since the system assumes that a legal entity has a relationship with all other entities. With this exception, does that mean I won't be able to enter an IC transaction with a legal entity listed as an exception? In other words, there's a system restriction on who I can enter IC transactions with? This would be nice since there is no such functionality in 11.5.9.<br><br>Thanks!Leslienoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-90206891005302683832007-12-18T23:18:52.000-08:002007-12-18T23:18:52.000-08:00Hi David,Do you know the differences between the r...Hi David,<br><br>Do you know the differences between the reconciliation process between Oracle GIS and Cartesis Intercompany Server (now Business Objects Finance)?<br><br>Is it possible to use Oracle GIS as a standalone solution to enhance the intercompany reconciliation process in order to achieve a fast closing process?<br><br>Thanks,<br>AlessandroAlessandrohttp://www.ineum.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-40514813544682508052007-12-19T01:57:27.000-08:002007-12-19T01:57:27.000-08:00Alessandro,I have seen GIS used as a central Inter...Alessandro,<br><br>I have seen GIS used as a central Intercompay 'hub' and AGIS is R12 could also be used in that way.<br><br>GIS has been set up on it's own instance and the journal lines it pushes to GL_INTERFACE are then routed to the appropriate Oracle or potentially non-Oracle system.<br><br>AGIS uses a workflow and business event architecture, which makes implementing is as an Interompany hub should be much easier as the integration points are increased.davidhaimeshttp://davidhaimes.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-17827181767309288162008-01-21T03:27:43.000-08:002008-01-21T03:27:43.000-08:00Can you give some insights on how Tax will be hand...Can you give some insights on how Tax will be handled in case of AGIS Invoicing. For example if there is an AGIS transaction between two LE's following different Tax - US and Canada.Anjananoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-4668026055244088292008-01-21T11:43:28.000-08:002008-01-21T11:43:28.000-08:00The new eTax product is used for tax calculation o...The new eTax product is used for tax calculation on the invoices. It can easily handle goods or services provided in the US to a trading partner in Canada.David Haimeshttp://davidhaimes.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-22500195682500248702008-02-13T08:28:56.000-08:002008-02-13T08:28:56.000-08:00[...] stamped with an owning (first party) Legal E...[...] stamped with an owning (first party) Legal Entity and that will be used to drive tax, accounting, intercompany and Legal [...]How do I define my Legal Entities? « David Haimes Oracle Intercompany Financials Bloghttp://davidhaimes.wordpress.com/2007/11/21/how-do-i-define-my-legal-entities/noreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-51166137733306742412008-09-12T00:33:42.000-07:002008-09-12T00:33:42.000-07:00Hi David,Great topic! Here is my question: I have...Hi David,<br><br>Great topic! Here is my question: I have found that if i assign any balancing segment values to either the ledger or to an LE, that those values no longer auto-balance for Intercompany EXCEPT with other BSV values assigned to the same ledger or LE, AND you can never remove the BSV to correct the issue if you didn't mean to do this. This seems perilous!<br><br>What are you recomending as to the Assignment of BSV's to still have autobalancing intercompany as a feature! I personally am not assigning them to either Ledger or LE to avoid this issue.<br><br>I look forward to your comments :)Dan Chttp://Googlenoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-48957829446377898882008-03-24T05:05:54.000-07:002008-03-24T05:05:54.000-07:00[...] designing AGIS for R12 we tried to minimize ...[...] designing AGIS for R12 we tried to minimize the time it would take to get started entering transactions in an initiative [...]AGIS Out of the Box « David Haimes Oracle Intercompany Financials Bloghttp://davidhaimes.wordpress.com/2008/03/24/agis-out-of-the-box/noreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-65463843926184668332008-11-07T01:50:00.000-08:002008-11-07T01:50:00.000-08:00@NEELYou should post this question on the OTN Foru...@NEEL<br><br>You should post this question on the OTN Forums, there are more eyes of cash management experts there.David Haimeshttp://davidhaimes.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-44445433385895248052008-11-03T15:05:29.000-08:002008-11-03T15:05:29.000-08:00HI ALL,WHEN I GO TO THE PAGE BANK ACCOUNTS TRANSFE...HI ALL,<br>WHEN I GO TO THE PAGE BANK ACCOUNTS TRANSFER FROM FOLLOWING NAVIGATION<br><br>CASH MANAGMENT RESO>BANK ACOUNTS TRANSFER<br><br>AND WHEN I CLICK ON SOURCE BANK ACCOUNTS AND DESTINATION BANK ACCOUNTS <br><br>HERE I AM NOT GET ANY VALUE<br><br>I ALSO DONE FOLLOWING SETUP.........<br><br>1. In System Administrator responsibility assign the CE: Bank Account Transfers system profile to your responsibility in Cash management. <br><br>2. <br>I ALSO CREATE THE SUBTYPE <br><br><br>3. Login as sysadmin and go to User Management responsibility and setup the UMX<br>Security for Bank Account Transfer module for your specific Legal Entity, this can be<br>Done using the UMX wizard for Cash Management, this wizard can be launched by<br>querying the relevant responsibility you are using from Roles and Responsibilities<br>module. <br><br>4. In the Search region enter the following information:<br>· Type: Roles & Responsibilities<br>· Category: Miscellaneous<br>· Code: Enter the code assigned to the Cash Management responsibility (e.g. FND_RESP|CE|CASH_MANAGEMENT_OPERATIONS|STANDARD)<br>· Application: Cash Management.<br><br>5. Click in the Update icon, then you will see a new form called “Update Role” click in the<br>security wizard button save and proceed.<br><br>6. Run the CE UMX Security Wizard, then you will see a new form called “bank Account<br>Security Management, enter the bank account grants for USE, MAINTENANCE and BANK ACCOUNT TRANSFER and clink in the APPLY button. <br><br>7. i also define the intra company setup also.NEELnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-72756407428191827152008-09-18T07:44:10.000-07:002008-09-18T07:44:10.000-07:00DanSorry to be so late replying. You make a good ...Dan<br><br>Sorry to be so late replying. You make a good observation and I probably should blog about this topic in a little more detail.<br><br>This is not really a balancing feature, it is a GL feature. If you start to assign BSV to a ledger you need to assign all the BSV you plan to use for that ledger. If you decide to do no assignment of BSV then they are all available for use.<br><br>The reason you cannot undo and assignment is that once you start creating accounting for that BSV in the ledger you don't want to unassign it and then move to another ledger and create accounting there - that would cause problems in your GL.David Haimeshttp://davidhaimes.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-81705907750765733772009-03-17T15:32:22.000-07:002009-03-17T15:32:22.000-07:00Hi David, I am doing GL intercompany Transfer mi...Hi David,<br> I am doing GL intercompany Transfer migration from 11i to R12 . Please help me if you (any one) is Having the migration code or the Details of the required datas to be imported from 11i Instance.<br><br>Please help me its an urgent requirement.Dinesh SVnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-89100875012619652232009-03-19T06:22:34.000-07:002009-03-19T06:22:34.000-07:00Dinesh,You should refer to the R12 upgrade guides ...Dinesh,<br><br>You should refer to the R12 upgrade guides and documentation available on metalink.David Haimeshttp://davidhaimes.wordpress.comnoreply@blogger.comtag:blogger.com,1999:blog-6484465525647257447.post-48110774308454756472009-10-07T05:30:40.000-07:002009-10-07T05:30:40.000-07:00thanks for the info. I will for sure look into th...thanks for the info. I will for sure look into that!<br><br>Regards<br>corneliaCornelianoreply@blogger.com