How Payables Source Lines Are Imported

Use the Create Mass Additions process to send valid invoice line distributions and associated discounts from Oracle Payables to an interface table in Oracle Assets. You then review the lines in Assets and decide whether to create assets from the lines.

Settings That Affect the Import Process

For the Create Mass Additions process to import an invoice line distribution to Assets, the following specific conditions must be met:

• The invoice line must be charged to an asset account or to an expense account if it's an expensed asset.

• The asset account must be set up for an existing asset category as either the asset clearing account or the CIP clearing account.

• The line amount can be either positive or negative. The invoice line description will be the mass addition or source line description.

• Discount line distributions imported to Assets automatically have a description of Discount.

• Track as Asset must be enabled for the invoice line charged to an expense account.

• If you have multiple corporate books in Assets, Payables must be tied to the same ledger as the corporate book in which you want to create mass additions.

• The invoice must be approved.

• The invoice line distribution must be posted to Oracle General Ledger from Payables.

• The general ledger date on the invoice line distribution must be on or before the date you specify for the Create Mass Additions process.

• If you use the multiple organization feature, your Payables business unit must be tied to the same ledger as the corporate book for which you want to create mass additions.

To default the asset category when creating mass additions:

• Define a default asset category for items in Oracle Purchasing or Oracle Inventory.

• Create purchase orders for those items.

• Receive the items in Purchasing or Inventory.

• Enter invoices in Payables, match them to the outstanding purchase orders, and approve the invoices.

• Post the invoices to General Ledger.

• After you run the Create Mass Additions process, the mass addition line appears with the asset category you specified for the item.

How Invoice Line Distributions Are Imported

The Create Mass Additions process in Payables:

• Sends potential asset invoice line distributions and any associated discount lines to Assets.

• Doesn't import the same line twice. Payables ensures a line is imported only once even if you run the process multiple times during a period.

Note: If you have multiple corporate books:

The Post Accounting process assignment definitions in Oracle Subledger Accounting identify the line types that should be interfaced to Assets by the Create Mass Additions process.

Payables sends line amounts entered in foreign currencies to Assets in the converted ledger currency. Assets creates journal entries for the ledger currency amount.

Review the Create Mass Additions report to see both foreign and ledger currency amounts:

Conversion Rate: 1 EUR = 1.25 USD

In Payables, the amounts are converted to dollars, the ledger currency, and sent to Assets by the Create Mass Additions process. The conversion rate is: 1 EUR = 1.25 USD

Journal Entry in Entered Currency:

Account	Debit Amount	Credit Amount
Asset Clearing	4,000.00 EUR	None
Accounts Payable Liability	None	4,000.00 EUR

Journal Entry in Accounted Currency:

Account	Debit Amount	Credit Amount
Asset Clearing	5,000.00 USD	None
Accounts Payable Liability	None	5,000.00 USD

Assets creates a journal entry for the asset addition in dollars. The conversion rate is: 1 EUR = 1.25 USD

Account	Debit Amount	Credit Amount
Asset Cost	5,000.00 USD	None
Depreciation Expense	312.50 USD	None
Asset Clearing	None	5,000.00 USD
Accumulated Depreciation	None	312.50 USD

In General Ledger, the journal is in the ledger currency:

Account	Debit Amount	Credit Amount
Asset Cost	5,000.00 USD	None
Asset Clearing	None	5,000.00 USD