One of the key features introduced with the new Advanced Global Intercompany (AGIS) in R12 of Oracle E-Business Suite is the ability to create documentation for Intercompany transactions. The correct documentation is required in many countries for Intercompany trading, this essentially means I need to provide a Receivables Invoice for the Legal Entity Providing the goods or service and a payables invoice for the receiving Legal Entity. These invoices should have any taxes that are applicable in the jurisdictions, for that type of service.
We do not firce you to create invoices for all Intercompany Activity, you can still create just a GL Journal entry if you prefer. The AGIS transactions flow is illustrated in the diagram below.
You can see that we check if invoices are required and there are two places that we look for that. First is the AGIS transaction type flag, seen on the AGIS Transaction Page in the Set Up Tab.
<click image to see full size>
You can also create a rule in the Legal Entity setup, we create that rule at the registration level. This is set by selecting the Legal Function ‘Create Intercompany Invoice’ when entering the Legal Entity Registration. If the this rule is set for one of the Legal Entity involved in an AGIS transaction it will take precedence over the Transaction Type rule and the invoice will be created.
We create an AR invoice (via an Invoice API or the Open Interface tables) at that point the eTax module will kick in and calculate the tax for you and add that to the invoice. When the AR invoice has been created we create the AP invoice (via the AP Invoice Interface) using the invoice number from the AR invoice – so should be easy to match those invoices. We also ensure that the same information required by eTax is on the AP invoice so the tax calculation will be the same on the AR and AP invoices.
On of the key aspects of AGIS is that we will not create an AR or AP invoice or a GL journal until both sides of the transactions have approved it and we checked that the appropriate periods are open in GL, AP or AR. This means that there is no possibility of one side of the transaction going through and then the other side rejecting or changing the Accounting Date so they hit different periods or anything else that will make reconciliation and elimination of Intercompany cumbersome.
Enterprise Applications by David Haimes 
David,
It may look like a weird question, but does AGIS also offer intracompany invoicing?
To be honest, I doubt that it is possible because the invoicing part is contradictory to the term intracompany. But I came across the requirement to generate invoices for transactions between operating units of the same legal entity. I guess that I will have to create a legal entity for every one of those operating units if I want to have the invoicing.
Best regards,
Steven.
LikeLike
you can do inter or intra company transactions in AGIS. Just create 2 intercompany organizations and assign them to the same LE. Then you can create transactions with invoicing if desired. We deliberatly allow this functionality as it is a requirement we have heard.
LikeLike
Hello,
I use Oebs 11.5.10. I have simple inter company set-up( Oracle Inventory User’s Guide – intercompany Invoicing). I do not use GIS. Now I am preparing to upgrade to 12i. That I have question. Do I have to set-up AGIS to use my present functionality?
Regards,
Łukasz
LikeLike
There’s two options on the Intercompany Transaction types, they are Allow Invoicing and VAT taxable. Can you please let me know what happens wif these options are enabled??
LikeLike
Waht are the Basic setups for intercompany in AR and AP and How it will generate invoice in both of module (Simple steps required with Chart)
LikeLike
My clinet requirement is exactly matching to AGIS Functionality. So I started setting up the whole thing in the system. I initiated a batch and the ststus fo which from the Initiator is “Submitted”…
But the same is not appearing in the Inbound for the recipient…
Do i need to run any concurrent program so as to appear this in the Inbound.
LikeLike
You need to make sure your workflow background processes are running. The workflowpicks up the transactions and processes them, changing the status.
LikeLike
David;
We process shared services transactions whereby entities from separate ledgers are processed by one entity in behalf of others. This occurs with AP and Customer invoices and their liquidation. Besides the problem of applying the receipt to the customer invoice – which can only be done where the invoice applied to is in the same operating unit in which the receipt is being applied. We plan to populate I/C segment to identify transactions done “in behalf” of other BSVs/Comapnies within the family of companies.
I was thinking of extracting all transactions with distributions where the BSV is to a different value than that in the I/C segment (where I/C segment is not zero’s). Then using this with some code to get a file in the right format to import into AGIS for processing the due to / due from portion of the entry.
Is this viable? Have you heard of something similar?
Thanks, David
LikeLike
Can AGIS be used to capture AP trade invoices at the Shared Service entitiy and used to record the corresponding expense (example: utilities) in the seperate ledger for one of the other companies. So Shared service pays expense and creates AP Liab in ES ledger and IC clearing Account to the appropriate Company in ES ledger can this IC be “pushed to the appropriate comapny using AGIS. Or is AGIS only to capture the due to due from which looses the ability to tie this to the priginal AP expense.
LikeLike
Hi Bill, I have similar situation. By now do you know if AGIS can help here?
Thank You
LikeLike
Follow up to last post on shared services: I know that AGIS will generate more than the due to due from pieces. AGIS posts to all intercompany organizations defined in any ledger.
LikeLike
Hello David:
Is it possible within standard R12.1.3 functionality to create an intercompany or intracompany invoice based on a manual GL JE that is booked to a designated interco/intraco clearing account?
Thanks,
Beth
LikeLike
Dear David, Please help with this misery.
The Payables Open Interface Import program is generating additional tax line for every additional line if transaction.
Below are the scenarios:
scenario #1:Single line item
AR Invoice {single line trx)
Dr. Receivables 180
Cr. Revenue 150
Cr. Tax 30 [20% tax rate]
AP Invoice {single line trx)
Dr. Purchases 150
DR. Tax 30 [20% tax rate]
Cr. Payables 180
————————
scenario #2:Multiple line item
AR Invoice {multi 2 line trx)
Dr. Receivables 180
Cr. Revenue 100
Cr. Revenue 50
Cr. Tax 30 [20% tax rate]
AP Invoice {multi 2 line trx)
Dr. Purchases 100
Dr. Purchases 50
Dr. Tax 30 [20% tax rate]correct
Dr. Tax 30 [20% tax rate]
Cr. Payables 210
Extra tax line added [error]
————————
scenario #3:Multiple line item
AR Invoice {multi 3 line trx)
Dr. Receivables 180
Cr. Revenue 100
Cr. Revenue 30
Cr. Revenue 20
Cr. Tax 30 [20% tax rate]
AP Invoice {multi 3 line trx)
Dr. Purchases 100
Dr. Purchases 30
Dr. Purchases 20
Dr. Tax 30 [20% tax rate] correct
Dr. Tax 30 [20% tax rate]
Dr. Tax 30 [20% tax rate]
Cr. Payables 240
Extra 2 tax line added [error]
————————
Problem:
Payables Open Interface program creates extra tax line for each additional line item inherited from Receivables.
————————
scenario #4: Multiple line item
AR Invoice {multi 4 line trx)
Dr. Receivables 180
Cr. Revenue 60
Cr. Revenue 40
Cr. Revenue 30
Cr. Revenue 20
Cr. Tax 30 [20% tax rate]
AP Invoice [multi 4 line trx)
Dr. Purchases 60
Dr. Purchases 40
Dr. Purchases 30
Dr. Purchases 20
Dr. Tax 30 [20% tax rate]correct
Dr. Tax 30 [20% tax rate]
Dr. Tax 30 [20% tax rate]
Dr. Tax 30 [20% tax rate]
Cr. Payables 270
Extra 3 tax line added [error]
———————–
The Total AR Invoice amount is constant at 180, while Total AP Invoice is incremental with additional tax line for each additional intercompany line transaction.
Please, what could be the cause?
Please I would appreciate your quick assistance. Thanking you in anticipation of your help.
LikeLike
Is it possible for us to create an AGIS invocie with Zero Amount?
LikeLike
From memory i would say yes. As long as you don’t set a minimum transaction amount in the system options I think this should work.
However, I am not sure what the business need is, why do you need a zero invoice?
LikeLike
Hey David,
How would an entry at the subledger level or at the General Ledger level interact with AGIS?
Would AGIS still pick up these transactions?
Thanks,
Paul
LikeLike
Hey David,
I have done the set up of transaction type, In invoice option could you please show me how to create the GIS of i’m the customer and I have contact with supplier or opposite.
Thanks,
LikeLike
Hi David,
I was hoping you can help me answer a question on AGIS in relation to the AR invoice created. My issue is i have multiple lines ie 3 lines on my AGIS, when I import to AR from the AGIS module, AR is creating 3 individual invoices for each line rather then one invoice with the 3 lines, is there a way in the setup in AR to change this or is this not possible?
LikeLike
I think there is a way in AR to control the grouping of the lines that come in through the AR Interface. I am not an expert in AR so could not tell you exactly step by step.
LikeLike
AR Setup>System Options and select the grouping rule.
LikeLike
Hi….can you use AGIS for inventory (i.e., direct shipments from Mfg to Sales branches)? Have other customers chosen AGIS over Create Interco AR/AP? If so…..any issues? We are exploring this because we want to support only one method of interco invoicing…..not multiple.
LikeLike
Hi….how hard is it to do cross-instance AGIS transactions? Would we have to build our own integration? Both instances are running 12.1.
LikeLike
You would need to build some integration, but the architecture is such that you can do it with non invasive customizations. Without getting into too much details, you just use the Workflows and Business Events to trigger moving it to the remote instance.
LikeLike
Hi David,
Have you dealt with instances where the intercompany transaction (Loan) from one LE to another LE but the flow of the transaction goes through a number of companies and holding company. So the flow of the loan is between 2 entities but the flow of the legal is through 5 LEs.
Thanks,
Saheed
LikeLike
David, I have an AGIS question: can we use AGIS via AR/AP when we have 1 LE, 1 OU, 1 Ledger with multiple BSV’s? I am looking for the confirmation whether it works or not.
LikeLike
Hi David,
Your Blog seems to be very interesting.
I have a query- How can we process an intracompany transaction across two OU’s that falls under different ledgers and different Business groups. It is a shipping transaction, basically Order is booked in an OU but the shipping is done from another OU directly to the customer.
Now we have done the setup, but the intracompany Invoicing programing is failing or ending up with Warning, and no records are being fetch by the program.
Thanks,
Shailesh
LikeLike
If the program is not picking anything up, you need to file an SR with Oracle Support.
LikeLike
Hi David,
Thanks for your prompt revert.
We surely are working with Oracle.
Need a small confirmation from your side, is it feasible to carry out intercompany transaction across BG’s with Invoicing ??
Thanks,
Shailesh
LikeLike
yes it is.
LikeLike
Sorry its not intracompany its inter-company.
LikeLike
Hi David…
Problem Summary : Can AP invoices be entered with distributions to company codes in other ledgers?
Problem Description:
I have intercompany accounting set up so I can enter a manual intercompany journal in AGIS with company codes in multiple ledgers that are automatically balanced and posted to the relevant ledgers.
Is there a way to use this in AP? I would like the AP user to be able to enter an invoice with a line distribution to a company code that is in a different ledger. Then intercompany balancing rules would be applied so that the accounting for the invoice would automatically be balanced by company and journal entries created in multiple ledgers, in the same way as is done for the manual intercompany journal entry.
I do not need invoicing between the companies. I only need the accounting for an external AP invoice to be distributed to multiple companies and multiple ledgers.
I have succeeded in entering invoices with other company codes in the *same* ledger, but company codes in other ledgers are not available for selection.
LikeLiked by 1 person
Hi Raghu,
This is not possible, an AP invoice distribution can only be entered for the same ledger that the Invoice is entered into.
Rather than manually create AGIS Manual transactions for these, a lot of people write a simple custom program to take the external invoice details (you might use a dff or other method to mark which ledger/company code the distribution or invoice line needs to go to, or derive it programmatically from information already on the invoice liens/distributions) and inset them into the AGIS open interface to generate an AGIS Manual transaction that will generate GL journals for the different ledgers involved. If you use auto-approval, this can be a straight through automated process that users do not need to do manually.
Hope this helps, David
LikeLiked by 1 person
Thanks David…So approach would be try achieving it by custom solution. We shall look into that approach. –Regards Raghu
LikeLike
Hi David,
Just wanted to ask a couple of quick questions;
1. Can AGIS send transactions to other ERP systems other than Oracle APPS?
2. Can AGIS deal with Receipts ? Can we upload and apply receipts via AGIS.
Any help and guidance would be great.
Thank you
S
LikeLike
Hi,
1. The architecture is open and uses the workflow business event system, so you could do this with some safe non invasive custom integration work.
2. We do not deal with receipts, the invoice is not held in AGIS, you would apply the receipt to the invoice in the AR module.
LikeLike
Thank you David, Regards
LikeLike
Quick question on AGIS process:
1. Intercompany transactions between 2 OU’s needed such that GL entries are eliminated
2. I assume we can use AGIS but once the AR and AP is created, how do we close them? Obviously, you wouldn’t want to create dummy payments for the Interco AR and AP Invoices. How do we handle this?
To simplify:
1. For Intercompany transactions between 2 OU’s/LE’s, how to minimize work such that we don’t process AR/AP payments because both organizations belong to the same Corporate and how do we handle in GL?
LikeLike
You have two options to close the AR and AP invoices.
1 – Use Netting feature, net off the invoices against each other. However, this will only work if they are in the same OU as netting does not work across OU in EBS R12
2 – Create dummy bank accounts and do a payment run to close them out. This is what a lot of people do today, you can create the jobs/jobsets and schedule so it is all handled automatically, so should not be a big amount of work.
LikeLike
Hello david,
We have 1 LE with multiple OU. Question:
Is it possible to have multiple Inventory OU and OM yet only 1 AR … all Sales order under all OM will be consolidated in 1 AR during AR invoice interface.
Thanks :)
LikeLike
I have never personally set this up, but as far as I understand it you should be able to have multiple LE in OM feeding a single AR OU. I would recommend a test to verify.
LikeLike
Hi David. I was hoping I can ask you about the Description in the Account and Initiator lines. Currently the balancing account automatically copies the previous line’s Description. Is it possible to use the Description from the header. Any input or guidance you have is appreciated.
LikeLike
I thought the balancing lines had a description along the lines of “Automatically Added by Intercompany Balancing.
LikeLike
Buenos días.
Para Transferir a GL desde el super user Entre Compañias, deben estar cerrados los periodos que voy a transferir ahi mismo?
LikeLike