Wednesday, February 13, 2008

Intercompany Invoicing in AGIS

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.


Steven said...


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,


David Haimes said...

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.

Łukasz said...


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?


Gareth Donegan said...

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??


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)

Vasanth said...

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.

Sridevi K said...

Sridevi Koduru (Senior Oracle Apps Trainer
LinkedIn profile -
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.