This chapter covers the following topics:
When you process and invoice an order, the selling organization records entries to accounts receivable, for revenue, tax, and freight. The shipping warehouse records entries to the inventory asset account and the cost of goods sold (COGS) account. When the above scenario involves a selling organization in one operating unit, and a shipping organization in another operating unit additional accounting must take place.
The shipping organization must bill the selling organization at the transfer price, and the selling organization must make the corresponding payment. The intercompany accounts receivable invoice is the transaction the system uses to record the intercompany receivable accounting for the shipping organization. It debits the intercompany accounts receivable at transfer price, charges tax, freight, and credits intercompany revenue.
The intercompany accounts payable invoice is the transaction the system uses to record the payable accounting for the selling organization. The system debits intercompany COGS and freight, and credits the intercompany payable account.
Intercompany invoicing provides the following benefits:
Reduce procurement costs.
Reduce the complexity of interactions with suppliers.
Centrally control the amount and timing of funds dedicated to procurement activities on behalf of subsidiaries.
Secure supply commitments on the basis of parent company credit ratings.
Expedite delivery by avoiding unnecessary intermediate delivery locations.
You can ship an order from a shipping warehouse that has a different operating unit other than the selling organization. The system generates an intercompany invoice to record an intercompany sale between the shipping organization and the selling organization.
You can define different accounts for trade, intercompany COGS, and sales revenue to eliminate intercompany profits. You can also use price lists to establish intercompany invoices.
Related Topics
Intercompany Invoicing Process Overview
Overview of Pricing, Oracle Advanced Pricing User's Guide
The following is the overall intercompany invoice business process:
The customer places an order with the selling operating unit.
The order ships to the customer from a shipping warehouse associated with an operating unit that differs from the selling operating unit.
The shipping operating unit issues an intercompany receivable invoice to the selling operating unit at the transfer price.
The selling operating unit issues an intercompany payable to the shipping operating unit.
If the customer is external then, the selling operating unit sends a separate invoice to the customer.
Related Topics
Defining Intercompany Relations
Intercompany AR Invoice Report
Intercompany Invoice AP Report
Bills Receivable Overview page , Oracle Receivables User's Guide
Accounting in Payables page , Oracle Payables User's Guide
Submitting a Request, Oracle Applications User's Guide
Representing Organizations, Using Oracle HRMS - The Fundamentals (US
Defining Item Cost Details, Oracle Cost Management User's Guide
Order Import, Oracle Order Management User's Guide
To perform intercompany invoicing verify the following:
Define intercompany relations between the selling and shipping operating units
Define intercompany transaction flows
Define price lists
Define Oracle Receivables system options
Define Oracle Payables system options
Define tax structures in Oracle Payables and Oracle Receivables
Set up the Account Generator for the Cost of Goods Sold accounts
Before checking the Intercompany AP invoice, ensure you have met the following conditions:
The Intercompany AR invoice was created
The create Intercompany AP Invoices program successfully ran for the selling operating unit
The Invoice import program completed for invoice source = intercompany
The Create Intercompany AR Invoices program examines the profile options values of all responsibilities of an operating unit. If you do not set a profile option for any responsibility the program uses the site value. If one responsibility has a particular profile option set, the program uses the set value. If you set identical values for two or more responsibilities, the AR Invoices program uses the set value. If the profile option values differ between responsibilities, the program produces an error.
INV:Intercompany Currency Conversion
Determines the conversion type for foreign currency invoices.
INV:Inter-company Invoice for Internal Orders
This profile option allows you to created intercompany invoices for internal orders of type in-transit shipments. Set this profile option at site level.
INV: Advanced Pricing for Inter-company Invoice
This profile option enables you to use advanced pricing for intercompany invoice. Set this profile option at site level. To use this profile, Oracle Advanced Pricing must be installed.
TAX:Allow Override of Tax Code
Determines if tax code information should be passed to AR for freight
Tax:Invoice Freight as Revenue
Indicates if freight lines should be invoiced as revenue lines.
Tax:Inventory Item for Freight
Use this inventory item when you invoice freight lines as revenue lines.
MO:Operating Unit
Set this profile option to the appropriate operating unit for each responsibility.
A ledger determines the ledger currency, account structure, and accounting calendar for each company or group of companies. Verify you created a ledger for your operating unit See: Defining Ledgers, Oracle General Ledger User's Guide.
Verify you defined the currencies used in relations between operating units. See: Defining Currency, Oracle General Ledger User's Guide.
You must define both internal and external customers before you can use intercompany invoicing. See: Creating Customers, Oracle Receivables User's Guide.
You must establish all organizations involved in the Intercompany Invoicing Process. See: Creating an Organization, Using Oracle HRMS the Fundamentals (US.
You must establish intercompany relations between the operating units you wish to use intercompany invoicing. See: Defining Intercompany Relations.
For each pair of selling and shipping operating units, define the following:
A customer and customer site combination, defined in the shipping organization operating unit to represent each operating unit that is capable of promising shipments from the shipping operating unit. This customer and customer site combination is used in intercompany receivables invoices.
An invoice transaction type defined in the shipping organization operating unit.
A supplier and supplier site combination, defined under the selling organization, to represent each shipping entity. This supplier and supplier site combination is used in Intercompany payable invoices.
An operating unit to each inventory organization for creating an intercompany Oracle Receivables invoice.
To enable intercompany invoicing, you must perform the following item setups.
Enable Item at the Master and Organization levels
Verify the following item attributes are enabled
Customer Ordered
Customer Order Enabled
Internal Ordered
Internal Order Enabled
Invoiceable Item
Invoice Enabled
Cost Enabled
Stockable
Transactable
Inventory Item
Related Topics
Assigning Items to Organizations
Order Management Attribute Group
Representing Organizations, Using Oracle HRMS the Fundamentals (US
Defining Sets of Books, Oracle General Ledger User's Guide
Transaction flows specify the operating units and inventory organizations involved in the financial transactions when goods move from a source operating unit to a destination operating unit. This may differ and be independent from the physical flow of goods.
Transaction flows map the financial path that indicates the participating operating units involved in the transfer of assets from the point of procurement to the final selling organization. The transaction flow between a source and a destination identifies the chain of operating units and associated inventory organizations involved in the costing, transfer of liability, and revenue when you ship material from a source to a destination. You transfer liability and revenue from one operating unit and organization to another operating unit and organization using logical transactions.
Logical Transaction- A Logical transaction is an accounting event that represents the financial transaction between two operating units without the physical movement of goods.
There are two transaction flow types, Shipping and Procuring. A shipping flow is setup between two operating units of type shipping. You use the shipping flow when the shipping operating unit differs from the selling operating unit on the shipping document. A procuring flow is set up between two operating units of type procuring when the receiving operating unit differs from the procuring operating unit on the receiving document. This type of flow indicates that the operating unit that created the PO differs from the operating unit that receives the PO.
To create a transaction flow
Navigate to the Intercompany Transactions Flow window.
Enter or select the start operating unit. In a shipping flow, the start operating unit is the operating that contains the shipping organization. In a procuring flow, the start operating unit is the operating unit that contains the procuring organization.
Enter or select the end operating unit. In a shipping flow, the end operating unit is the operating unit that contains the sales organization. In a procuring flow, the end operating unit is the operating that contains the receiving organization.
Select the transaction flow type from the drop down list. The available values are shipping or procuring.
Optionally enter the ship from / to organization. If you enter a ship from or to organization the system automatically uses the specified organization as the shipping or receiving organization.
Optionally select the Category qualifier. If you select a qualifier the system automatically selects items belonging to that category set. If you are creating a shipping flow, the system uses the inventory category set. If you are creating a purchasing flow, the system uses the purchasing category set.
If you selected the category qualifier, enter the appropriate category.
If you are creating a procuring flow, select the Asset price from the list of values. The available values are PO and Transfer.
If you are creating a procuring flow, select the Expense price from the list of values. The available choices are PO and Transfer
Enter the effect start date for the flow in the Start field.
Optionally, enter the effect end date in the End field
Select the Advanced Accounting check box if you plan to have intermediate operating units in the flow. If you use more than two operating units the system automatically checks this box. For transaction flows that contain two operating units, you can select this check box if you want to use advanced accounting.
In the Nodes alternative region modify the to operating unit if you have intermediate operating units. The to operating unit automatically defaults to the selling or purchasing organization depending on the flow type.
Enter any subsequent operating units in the alternative nodes region. Make sure the final operating unit is the operating unit specified in the Operating Unit alternative region.
Save your work.
Related Topics
Defining Intercompany Relations.
The following section contains the different accounting reports for intercompany invoicing:
Related Topics
Intercompany AR Invoices Report
Intercompany AP Invoices Report
Use this report to create intercompany accounts receivables invoices for product shipment and freight charges initiated from sales orders and internal orders another operating unit initiates. Oracle Inventory retrieves information such as customer, customer site, and transaction type from the intercompany relations definitions.
Related Topics
Intercompany AR Invoice Report
Use this report to copy intercompany account receivables invoices into Oracle Payables. This process creates invoices in the expense express tables with a unique import source name and is processed by the Oracle Payables Invoices Import Process.
Related Topics
Intercompany AP Invoice Report
The following section discusses the accounting practices for intercompany invoicing.
An invoice batch source indicates the source of invoices you transfer to Oracle Receivables. It also determines how auto invoice processes an invoice. All intercompany invoices the create intercompany AR invoice process generates use the predefined batch source intercompany. Modifying this invoice batch source may cause unexpected failures during auto invoice
Note: Auto accounting uses sales credit records to construct distribution accounts based on sales representative. If you use sales representative in one or more account segment assignments for a particular operating unit, set the Allow Sales Credit Flag to yes for the intercompany batch source in that operating unit.
The system record the transaction at transfer price, and uses the bill-to-site and the currency of the selling operating unit. For example, if the selling operating unit is located in the UK, and the shipping operating unit is located in the US, create the intercompany invoice in British Pounds, and convert to US dollars.
If the freight, handling, duty, and insurance charges are not in the same currency as the transfer price list, you must create another intercompany invoice.
The Currency Code field in the Intercompany Relations window is used to define which currency code is used in the Intercompany AR Invoice. The field is used if the profile option INV: Use Advanced Pricing is set to yes. For advanced accounting, and procuring, this is only applicable if the pricing options in the transaction flow are set to transfer price
Fl Type | Use Adv Pric | Curr Cde | Curr Cde in AR |
---|---|---|---|
Shipping | N | Does not matter | Price List Currency Code |
Shipping | Y | Shipping Operating Unit | Shipping Operating Unit Currency Code |
Shipping | Y | Selling Operating Unit | Selling Operating Unit Currency Code |
Shipping | Y | Order Currency Code | Sales Order Currency Code |
Fl Tpe | Pric Opt | Use Adv Pric | Curr Cde | Curr Cde in AR |
---|---|---|---|---|
Procuring | PO Price | N | Does not matter | Currency Code of Procuring / From Operating Unit |
Procuring | Transfer Price | N | Does not matter | Currency Code of Price List |
Procuring | Transfer Price | Y | Procuring / Shipping operating Unit | Currency Code of Procuring / From Operating Unit |
Procuring | Transfer Price | Y | Receiving / Selling Operating Unit | Currency Code Receiving / To Operating Unit |
Procuring | Transfer Price | Y | Order Currency Code | Currency Code in the Purchase Order |
Before checking the Intercompany AR invoice, ensure you have met the following conditions:
The transaction processor successfully completed the order issue.
Transaction is costed.
The auto invoice program completed without error for source = Intercompany.
The accounts for the intercompany accounts receivable invoice are built using AutoAccounting. The system uses an open interface to import records into Oracle Receivables. Individual account segments may come from different sources, and the combination must be allowed in the shipping organization ledger.
Salesperson Account Segment: The system derives the salesperson account segment from the accounts assigned to the no sales credit default.
Standard Lines Segment: The system derives the standards lines segments from the item master sales account for your items.
Standard Lines Freight Segment: You set the profile options Inv: Tax Invoice Item as Freight and Inv: Tax Invoice Freight as Revenue to yes obtain the freight account segments from the item.
However if freight is not an item, and it is a header-level charge on the invoice, the system derives the account segments from the standard memo line intercompany freight.
Invoice Type Segment: The system derives the invoice type segment from the invoice type you identified in the Intercompany Relations window for transactions between operating units.
If you need to apply tax to intercompany invoices, you must set up identical tax structures (tax codes and rates) in Oracle Payables and Oracle Receivables. This allows Oracle Receivables Invoices to mirror correctly into intercompany Oracle Payables invoices.
Before closing accounting periods in Oracle Inventory, Oracle Receivables and Oracle Payables, process all outstanding intercompany shipments including, but not limited to, posting to Oracle General Ledger.
Related Topics
Intercompany AR Invoices Report
The system records the transaction in the currency of the intercompany accounts receivable invoice. If AR invoice currency differs from the ledger currency of the selling operating unit, then the system converts the currency to the ledger currency of the selling operating unit and uses the exchange rate that corresponds to the invoice line general ledger date.
COGS Account: The Account Generator builds the COGS account for the selling organization ledger. Typically segments are sourced from a combination of constant values and the cost of goods sold from the selling unit.
Freight Account: Oracle Inventory uses the freight account you defined on the Intercompany Relations window for the corresponding selling and shipping organizations.
Intercompany Payable Invoice: The intercompany payable comes from the liability account associated with the shipping organization created in the selling organization payables system. Because more than one payable site can exist for a supplier, the system uses the site you defined on the Intercompany Relations window.
The Created Intercompany Accounts Payable (AP) invoices process uses the Account Generator process Inventory Cost of Goods Sold Account to construct the expense account for regular invoice lines. You must set up this process before you can user the Create Intercompany AP Invoice process.
Related Topics
Intercompany AR Invoices Report
Intercompany AP Invoices Report
The intercompany invoicing program uses the advanced pricing engine to derive the invoice price for an item. The advanced pricing setup enables you to define which rules, based on price list, the system uses to derive invoice price for an item.
To use this feature you must set the following profile option. Otherwise, the system uses the static price from the selling operating unit price list.
INV: Advanced Pricing for Inter-company Invoice
You set this profile option at site level. When you set this profile option to Yes, you can use the Advance Pricing engine for intercompany invoicing.
Note: You must purchase a separate license for Advanced Pricing. If you set this profile without a license, you are not able to use advanced pricing.
The following figure depicts the intercompany invoicing process with or without Oracle Advanced Pricing.
Before using the pricing logic, the intercompany invoicing program looks for an external API to return a price for the items on the order. If the API does not return a value, and if you set the Advanced Pricing profile option to yet, the pricing logic attempts derive the price from the price list using the Advanced pricing engine. If the advanced pricing engine finds the price for the item in one of the price lists, the intercompany invoicing program processes the record and moves on to the next record. If Oracle Advanced Pricing cannot find a correct price for the item, the intercompany invoicing program logs an error message for that records, and moves to the next record.
You can uses order management to create a static price list. See: Overview of Price Lists, Oracle Order Management User's Guide.
Oracle Inventory has the ability to call an external API to support custom-specific complex pricing logic written by the customer or a third party.
Note: The name of the API is MTL_INTERCOMPANY_INVOICES.get_transfer_price. The name of the file is INVICIVB.pls it is located in $INV_TOP/patch/115/sql.
You must set up pricing rules to use the advanced pricing engine for intercompany invoicing. If you do not setup rules, the system picks the invoice price from a static price list. See: Creating a Qualifier Group, Oracle Advance Pricing User's Guide.
Related Topics
Overview of Pricing Qualifiers, Oracle Advanced Pricing User's Guide
Overview of Price Lists page: , Oracle Advance Pricing User's Guide
Creating a Price List, Oracle Advanced Pricing User's Guide
There are two seeded relationships between request type and source codes. The first one is between request type intercompany and source system inventory. The second relationship is between request type intercompany and source system advanced pricing. These mappings enable you to create price lists that are common to intercompany invoicing and sales order invoicing. For sales orders, you create price lists with the source code of QP <Advanced Pricing> and the system uses the mapping between Oracle Order Management and Oracle Advanced Pricing to pick price lists for sales order invoices. Similarly, you may decide to create separate price lists for intercompany invoicing. You do this by using the system source code of inventory. To do this, set the profile option QP: Source system code to INV. See Profile Options, Oracle Advanced Pricing Implementation Manual. If you want to use separate price lists for intercompany invoicing, disable the mapping between intercompany and Advanced Pricing, otherwise if the pricing engine finds a better fit for the price list defined under Advanced Pricing, it returns that price list.
You can use the defined global structure to define mapping rules for qualifier attributes and pricing attributes for price lists. The global structure is based on the information that is captured and available in a sales order or an internal sales order record. All seeded default rules are defined using this global structure.
Qualifier Context Context |
Qualifier Attribute | Data Source | Table Validated Value Set |
---|---|---|---|
Intercompany_invoicing | Shipping Organization | Qualifier_attribute1 | HR_OPERATING_UNITS |
Selling Organization | Qualifier_attribute2 | HR_OPERATING_UNITS | |
Customer ID | Qualifier_attribute3 | HZ_CUST_ACCOUNTS, Hz_parties | |
Customer Site ID | Qualifier_attribute4 | ra_addresses_all, ra_site_uses_all, fnd_territories_vl ft |
Context | Pricing Attribute | Source Package | Source Function | Default Condition Template |
---|---|---|---|---|
Intercompany_Invoicing | Qualifier attribute1 | INV_IC_ORDER_PUB | G_LINE, SHIPPING_ORG_ID | INV Intercompany Pricing |
Intercompany_Invoicing | Qualifier attribute2 | INV_IC_ORDER_PUB | G_LINE, IC_SELLING_ORG_ID | INV Intercompany Pricing |
Intercompany_Invoicing | Qualifier attribute3 | INV_IC_ORDER_PUB | G_LINE, IC_CUSTOMER_ID | INV, Intercompany Pricing |
Intercompany_Invoicing | Qualifier attribute4 | INV_IC_ORDER_PUB | G_LINE, IC_CUSTOMER__SITE_ID | INV, Order Volume Context |
Intercompany_Invoicing | Qualifier attribute1 | INV_IC_ORDER_PUB | G_LINE, ORDERED DATE | INV, Order Context |
Intercompany_Invoicing | Qualifier attribute14 | INV_IC_ORDER_PUB | G_LINE, ORDERED QUANTITY | INV, Order Volume Context |
Context | Pricing Attribute | Source Package | Source Function | Default Condition Template |
---|---|---|---|---|
Item | Pricing attribute1 | INV_IC_ORDER_PUB | G_Line, inventory_item _id | INV Intercompany Pricing |
Context | Qualifier Attribute | Data Source | Table Validated Value Set |
---|---|---|---|
Global_Procurement | Procuring Operating Unit | Qualifer_attribute1 | NA |
Global_Procurement | Receiving Operating Unit | Qualifier_Attribute2 | NA |
Global_Procurement | Vendor ID | Qualifier_Attribute3 | NA |
Global_Procurement | Vendor Site ID | Qualifier_Attribute4 | NA |
Context | Pricing Attribute | Source Package | Source Function | Default Condition Template |
---|---|---|---|---|
Global_procurement | qualifier attribute1 | INV_IC_ORDER_PUB | G_PROC_LINE, IC_PROCURING | INV Intercompany Invoicing |
Global_procurement | qualifier attribute2 | INV_IC_ORDER_PUB | ORG_ID, G_PROC,LINE, IC_RECEIVING_ORG_ID | INV Intercompany Invoicing |
Global_procurement | qualifier attribute3 | INV_IC_ORDER_PUB | G_PROC_LINE, IC_VEND0R_ID | INV Intercompany Invoicing |
Global_procurment | qualifier attribute4 | INV_IC_ORDER_PUB | G_PROC_LINE, IC_VENDOR_SITE_ID | INV Intercompany Invoicing |
A customer located in the UK purchases computers from a sales division in the United Kingdom. The shipping warehouse located in an operating unit in the United States ships the computers from a US warehouse to the customer in the UK, and records the cost in US dollars. The US operating unit invoices the UK operating unit at transfer price in British pounds which is then converted to US dollars. The following figure describes the steps you use in intercompany invoicing for a sales order.
A sales office in the UK operating unit sells products to a customer. The products are then shipped from a shipping organization under the US operating unit. When the order shipment is confirmed, inventory transactions record the material movements. These inventory transactions generate the accounting distributions shown in the following table, which are recorded in the US operating unit's Oracle Inventory accounting distribution table MTL_TRANSACTION_ACCOUNTS.
Account | Debit | Credit |
---|---|---|
Intercompany Cost of Goods Sold (via Account Generator | US Unit Cost x Qty | - |
Inventory Valuation | - | US Unit Cost x Qty |
The Oracle Receivables Interface process in Oracle Order Management and Oracle Shipping Execution creates the invoice distributions shown in the following table, in Oracle Receivables (applicable taxes excluded) for the UK operating unit:
Account | Debit | Credit |
---|---|---|
Trade Receivables | (Selling Price x Qty) | - |
Trade Revenue | - | (Selling Price x Qty) |
The Create Intercompany AR Invoice process uses the AutoInvoice mechanism to generate an intercompany receivable invoice from the US legal entity to the UK legal entity. The transaction date stamp on the inventory shipment transaction is the transaction date in the invoice lines. The transfer price of the product is extracted from the appropriate price list.
The following table shows the intercompany receivable accounting in the US shipping organization.
Account | Debit | Credit |
---|---|---|
Intercompany Receivables | Transfer Price x Qty | - |
Intercompany Revenue | - | Transfer Price x Qty |
After the system invokes AutoInvoice to process the intercompany Oracle Receivables invoices, the Create Intercompany AP Invoices concurrent program can be run followed by the AP Invoice Import Program to create the intercompany payable invoices from the UK legal entity to the US legal entity.
The following table shows intercompany payables that would be created in the UK selling organization.
Account | Debit | Credit |
---|---|---|
Trade COGS (via Account Generator) | Transfer Price x Qty | - |
Intercompany Payables | - | (Transfer Price x Qty) |
Steps | Process | Program | Description |
---|---|---|---|
1 | Enter Order | UK Order Management | Enter order information. See: Overview of Sales Orders, Oracle Order Management User's Guide |
2 | Schedule order and issue demand | UK Order Management | The Demand and or reservation is placed in the UK, and communicated to US manufacturing. UK order management maintains the schedule date. See: Sales Orders Scheduling, Oracle Order Management User's Guide and Availability and Reservations, Oracle Order Management User's Guide |
3 | Perform pick release and print picking documents | UK Order Management | Select lines that need to be picked out of the warehouse and staged for shipping. Generate the appropriate picking documents. See: Releasing Sales Orders for Picking, Oracle Shipping Execution User's Guide Before performing pick release, you may need to provide additional information regarding the product location. You must choose the subinventory location for the item. The picking documents need to print at the US distribution center. See: Defining Sales Order Main and Other Header Information, Oracle Order Management User's Guide. |
4 | Run update shipping information | UK Shipping Execution | This programs updates the Order Management tables to reflect the order lines shipped status. |
5 | Run Inventory interface and Order Management Interface | UK Shipping | You can run the inventory interface program automatically after you ship confirm each order or defer the process. See: Defining Shipping Transaction Parameters, Oracle Shipping Execution User's Guide You can run the Interface Trip Stop-SRS program to run the Inventory and Order Management SRS Interfaces at the same time. The Transaction Manager processes the material issue out of Inventory. |
6 | The Transaction Manager processes the material issue out of inventory | US Inventory | The transaction manager periodically sweeps the Inventory interface tables, after which the on-hand balance is reduced that accounting distributions are made. See Launching Transaction Manager |
7 | Costing | US Costing | The sales order issue transaction needs to be costed. |
8 | Run receivables interface | UK Order Management | After you perform shipment confirmation, run the receivables interface program to populate the receivables interfaces tables. See: Invoice Processing, Oracle Order Management User's Guide |
9 | Run AutoInvoice master program | UK Receivables | After you run the receivables interface from UK order Management, you can import the customer invoice information in to Oracle Receivables. See: Importing Invoice Information Using AutoInvoice, Oracle Receivables User's Guide. |
10 | Print Invoice | UK Receivables | Print and mail the customer invoice See: Printing Transactions, Oracle Receivables User's Guide |
11 | Run Create Intercompany AR Invoices | US Inventory | This program creates the intercompany receivable invoices. |
12 | Run AutoInvoice master program | US Receivables | After you create the intercompany invoice in US inventory, you can import it in to Oracle Receivables. Run Auto Invoice Master program. See: Importing Invoice Information Using Auto Invoice, Oracle Receivables User's Guide. |
13 | Print the invoice | US Receivables | Review the intercompany invoice, print and send to the UK office. The create Intercompany AR invoices program populates the AR interface with those shipment lines that have successfully passed through inventory. Therefore, the shipping division's intercompany AR invoice may not have the same number of lines as the corresponding packing slip. See: Printing Transactions, Oracle Receivables User's Guide |
14 | Run Create Intercompany AP Invoices | UK Inventory | Creates records in the AP interface table. Only those records which successfully imported in to the US AR system will populate the AP interface |
15 | Run Invoice Import | UK Accounts Payable | Generates the intercompany AP invoice The Vendor is the shipping operating unit. Choose the site to use for intercompany payables you set up in the Define Intercompany Relations Screen. See: Payables Open Interface Program, Oracle Payables User's Guide |
Intercompany invoicing for an internal order differs from intercompany invoicing for sales orders. The customer is not an outside customer, but is instead an internal organization. Consider the following scenario: A manufacturing division located in Japan purchases computers chips from the UK operating unit. A shipping division in the UK ships the computer chips from a UK warehouse to the Japanese manufacturing division unit, and records the cost in British Pounds. The following figure describes the steps you use for intercompany invoicing for an internal order.
Note: You can only have two operating units for internal orders. Advanced accounting is not supported for internal orders.
Step | Process | Program | Description |
---|---|---|---|
1 | Generate Internal Requisition | Japan Purchasing | The Japanese operating unit generates an internal requisition to the orderOverview of Internal Requisitions, Oracle Purchasing User's Guide |
2 | Create an Internal Sales Order | Japan Purchasing | Create the internal Sales Order see:Creation of internal Sales Order , Oracle Purchasing User's Guide |
3 | Order Import | UK Order Management | Import internal order information see:Order Import, Oracle Order Management User's Guide |
4 | Schedule Order and Issue Demand | UK Order Management | The Demand and or reservations is placed in the UK. UK order management maintains the schedule date: See: Sales Order Scheduling, Oracle Order Management User's Guide andAvailability and Reservations, Oracle Order Management User's Guide |
5 | Perform pick release and print picking documents | UK Order Management | Select lines that need to be picked out of the warehouse and staged for shipping. Generate the appropriate picking documents. See: Releasing Sales Orders for Picking, Oracle Shipping Execution User's Guide Before performing pick release, you may need to provide additional information regarding the product location. You must choose the subinventory location for the item. See: Defining Sales order Main and Other Header Information, Oracle Order Management User's Guide |
6 | Print Invoice | UK Receivables | Print and mail the customer invoice. See: Printing Transactions, Oracle Receivables User' Guide |
7 | Run Inventory Interface and Order Management Interface | UK Shipping | you can run the inventory interface program automatically after you ship confirm each order, or you may defer the process. See:Defining Shipping Transaction Parameters, Oracle Shipping Execution User's Guide You can run the Interface Trip Stop-SRS program to run the Inventory and Order Management SRS Interfaces at the same time. |
8 | The transaction manager processes the material issue out of inventory | UK Inventory | The transaction manager periodically sweeps the Inventory interface tables, after while the on-hand balance is reduced and accounting distributions are made. See:Launching Transaction Manager |
9 | Run Create Intercompany AR Invoices | UK Inventory | This program creates the intercompany receivable invoices. See: Intercompany Invoicing AR Report |
10 | Run AutoInvoice Master Program | UK Receivables | After you create the intercompany invoice in UK inventory, you can import it into Oracle Receivables. Run the AutoInvoice Master program. See: Importing Invoice Information using AutoInvoice, Oracle Receivables User's Guide. |
11 | Print the Invoice | UK Receivables | Review the intercompany invoice, print and send to the Japan office. The Create Intercompany AR Invoices program populates the AR interface with the shipment lines that successfully passed through inventory. Therefore, the shipping division's intercompany AR invoice may not have the same number of lines as the corresponding packing slip. |
12 | Run Create Intercompany AP Invoices | Japan Inventory | Create records in the AP interface table. Only those records which successfully imported into the UK AR system populate in the AP interface. See:Intercompany AP Report |
13 | Run Invoice Report | Japan Accounts Payable | Generate the intercompany AP invoice. The vendor is the shipping operating unit. Choose the site to use for intercompany payables that you set up in the Define Intercompany Relations window. See: Payables Open Interface, Oracle Payables User's Guide |
This section depicts the transaction flows and accounting entries for intercompany invoicing, and global procurement flows. The tables contain the following information
Time: The event sequence
Transaction: Physical event.
Description: Depicts the underlying transactions, both physical and logical. Logical transactions are in italics.
Accounting: These columns depict the accounting entries for each operating unit. The process responsible for the accounting entries is also indicated for example cost processor, intercompany invoicing, or receiving processor.
Note: The AP accrual account defaults from the organization parameter you set.
The following image and table depict the transaction flow for an external drop shipment from a supplier to a customer.
Time | Txn | Desc | OU1 acct | OU2 acct |
---|---|---|---|---|
T1 | Receipt in RC through Desktop | Receive in RC R1 | Receiving Processor (Dr OU1 Clearing 10 Cr Accrual 10 | |
T2 | Delivering into RC through receiving desktop window | Deliver in RC | ||
PO Receipt in RC Accounting Transaction | (Cost Processor) DR Inventory RC 10 CR OU1 Clearing 10 |
|||
RC > DC (Accounting Transaction) (Logical I/C Shipment Logical I/C Receipt) | (I/C Invoicing) DR I/C Receivable 15 CR I/C Revenue 15 |
(Cost Processor) DR Inventory DC 15 CR I/C Accrual 15 | ||
(Cost Processor) DR I/C COGS 10 CR Inventory RC 10 | (I/C Invoicing) DR I/C Accrual 15 CR I/C Payable 15 | |||
DC > C1 Accounting Transaction (Logical Sales Order Issue) | (Cost Processor) DR COGS DC 15 CR Inventory DC 15 | |||
(AR Invoice) DR Receivable DC 20 CR Revenue DC 20 |
The following image and table depict the external drop shipment from supplier to customer with intermediate financial nodes process.
Time | Txn | Desc | OU1 Acct | OU2 Acct | OU3 Acct |
---|---|---|---|---|---|
T1 | Receipt in PC through Desktop Receiving window | Receive in PC | (Receiving Processor) DR OU1 Clearing 10 CR Accrual 10 | ||
T2 | Deliver into PC through Desktop window | Deliver in PC | |||
PO receipt in PC (Accounting Transaction (Logical PO receipt) | (Cost Processor) DR Inventory PC 10 CR OU1 Clearing 10 | ||||
PC > RC (Accounting Transaction) (Logical I/C Shipment) (Logical I/C Receipt) | (I/C Invoicing) DR I/C Receivable 15 CR I/C Revenue 15 | (Cost Processor) DR Inventory RC 15 CR I/C Accrual 15 | |||
(Cost Processor) DR I/C COG 10 CR Inventory PC 10 | (I/C Invoicing) DR I/C Accrual 15 CR I/C Payable 15 | ||||
RC > DC (Accounting Transactions (Logical I/C Shipment) Logical I/C Receipt) | (I/C Invoicing) DR I/C Receivable 20 CR I/C Revenue 20 | (Cost Processor) DR Inventory DC 20 CR I/C Accrual | |||
(Cost Processor) DR I/C COGS 15 CR Inventory RC 15 | (I/C Invoicing DR I/C Accrual 20 CR I/C Payable 20 | ||||
DC > C1 Accounting Transaction (Logical Sales Order Issue) | (Cost Processor) DR COGS DC 20 CR Inventory DC 20 | ||||
(AR Invoice DR Receivable DC 25 CR Revenue DC 25 |
The following image and table depict the external drop shipment from supplier with shipment and financial flow process.
Time | Txn | Desc | OU1 Acct | OU2 Acct | OU3 Acct |
---|---|---|---|---|---|
T1 | Receipt in RC | Receive in RC | (Receiving Processor) DR OU1 Clearing 10 CR Accrual 10 | (Receiving Processor) DR OU2 Clearing 15 Cr I/C Accrual 15 | |
PO Receipt in PC (Accounting Transaction) (Logical PO receipt) | (Cost Processor) DR Inventory PC 10 CR OU1 Clearing 10 | ||||
PC > RC RI | (I/C Invoicing DR I/C Receiving 15 CR I/C Revenue | I/C Invoicing) DR I/C Accrual 15 CR I/C Payable 15 | |||
Logical Receipt in RC | (Cost Processor) DR Inventory RC 15 CR OU2 Clearing 16 | ||||
RC > DC (Accounting Transaction (Logical I/C Shipment) (Logical I/C Receipt | (I/C Invoicing) DR I/C Receivable 20 CR I/C Revenue 20 | (Cost Processor) DR Inventory DC 20 CR I/C Accrual | |||
(Cost Processor) DR I/C COGS 15 CR Inventory RC 15 | I/C Invoicing) DR I/C Accrual 20 CR I/C Payable 20 | ||||
(Cost Processor) DR COGS DC 20 CR Inventory DC 20 | |||||
(AR Invoice) DR Receivable DC 25 CR Revenue DC 25 |
The following image and flow depict the internal drop shipment from supplier process.
Time | Txn | Desc | OU1 Acct | OU2 Acct |
---|---|---|---|---|
T1 | Receipt in DC | Receive in DC | (Receiving Processor) DR OU1 Clearing 10 CR Accrual 10 | (Receiving Processor) DR RI DC 15 CR I/C Accrual 15 |
PO Receipt in RC (Accounting Transaction (Logical PO Receipt) | (Cost Processor) DR Inventory RC 10 CR OU1 Clearing 10 | |||
RC > DC (Accounting Transaction (Logical I/C Shipment) | (I/C Invoicing) DR I/C Receivable 15 CR I/C Revenue 15 | (I/C Invoicing) DR I/C Accrual 15 CR I/C Payable 15 | ||
(Cost Processor) DR I/C COGS 10 CR Inventory RC 10 | ||||
T2 | Deliver into DC | Deliver in DC | ||
PO Receipt in DC (Regular Transaction) | (Cost Processor) DR Inventory DC 15 CR RI DC 15 | |||
T3 | Ship from DC | DC > Regular Transaction) | (Cost Processor) DR DC 15 CR Inventory DC 15 | |
(AR Invoice) DR Receivable DC 20 CR Revenue DC 20 |
The following image and table depict the global procurement with intermediate financial nodes process.
Time | Txn | Desc | OU1 Acct | OU2 Acct | OU3 Acct |
---|---|---|---|---|---|
T1 | Receipt in DC | Receive in DC | (Receiving Processor) DR OU1 Clearing 10 CR Accrual 10 | (Receiving Processor) DC OU2 Clearing 15 CR I/C Accrual 15 | (Receiving Processor) DR RI DC 20 CR I/C Accrual 20 |
PO receipt in PC (Accounting Transaction) (Logical PO Receipt) | I/C Invoicing) DR I/C Receivable 15 (CR I/C Revenue 15 | (Cost Processor) DR Inventory RC 15 CR OU2 Clearing 15 | |||
(Cost Processor) DR I/C COGS 10 CR Inventory RC 10 | (I/C Invoicing) DR I/C Accrual 15 CR I/C Payable 15 | ||||
RC > DC Accounting Transaction (Logical I/C Shipment) | (I/C Invoicing) DR I/C Receivable 20 CR I/C Revenue 20 | (I/C Invoicing) DR I/C Accrual 20 CR I/C Payable 20 | |||
(Cost Processor) DR I/C COGS 15 CR Inventory RC 15 | |||||
T2 | Deliver into DC | Deliver in DC | |||
T2 >=T1 | PO Receipt in DC (Regular Transaction) | (Cost Processor) DR Inventory DC 20 CR RI DC 20 | |||
T3 | Ship from DC to C1 | DC > C1 (Regular Transaction) | (Cost Processor) DR COGS DC 20 CR Inventory DC 20 | ||
(AR Invoice) DR Receivable DC 25 CR Revenue DC 25 |