Merge Mass Additions

In this example, you merge separate mass addition lines into a single mass addition line with a single cost.

Scenario

Transaction Details

Prior to the merge, the mass addition lines have a queue name of New. These are details for the two lines:

Line 1:

Line	Invoice	Amount	Units	Queue	Description
1	100	5,000 USD	2	New	Personal Computer

Line 1 contains these assignments:

Units	Expense Account	Location
2	01-110-7360-0000-000	USA-SAN FRANCISCO

Line 2:

Line	Invoice	Amount	Units	Queue	Description
2	220	67 USD	1	New	Tax on PC

Line 2 contains these assignments:

Units	Expense Account	Location
1	01-120-7360-0000-000	USA-SAN FRANCISCO

You can choose whether to sum the units:

Sum Units Check Box	Description
Checked	Oracle Assets uses both the merged parent and child distributions for the new asset created from the merged mass addition line. Note: Ensure that you include the distribution information for both the child line and the parent line when Sum Units is checked while merging the line.
Unchecked	Assets uses the distribution of the merged parent for the new asset created from the merged mass addition line.

After the merge:

• The invoice 100 line is in the On Hold queue and is ready to become as asset.

• The invoice 220 line is in the Merged queue and can't become an asset.

The original cost of the invoice line distribution remains on the line as an audit trail after the merge. The cost of the parent line isn't altered and remains the same. When you post the merged line, the asset cost is the total merged cost.

Transaction Results

Here are the details for the two lines after the merge when Sum Units is checked:

Line 1:

Line	Invoice	Amount	Units	Queue	Description	Merged Cost	Merged Units
1	100	5,000 USD	2	On Hold	Personal Computer	5,067 USD	3

Line 1 contains these distributions:

Units	Expense Account	Location
2	01-110-7360-0000-000	USA-SAN FRANCISCO

Line 2:

Line	Invoice	Amount	Units	Queue	Description
2	220	67 USD	1	Merged	Tax on PC

Line 2 contains these distributions:

Units	Expense Account	Location
1	01-120-7360-0000-000	USA-SAN FRANCISCO

Here are the details for the two lines after the merge when Sum Units isn't checked:

Line 1:

Line	Invoice	Amount	Units	Queue	Description	Merged Cost	Merged Units
1	100	5,000 USD	2	On Hold	Personal Computer	5,067 USD	2

Line 1 contains these distributions:

Units	Expense Account	Location
2	01-110-7360-0000-000	USA-SAN FRANCISCO

Line 2:

Line	Invoice	Amount	Units	Queue	Description
2	220	67 USD	1	Merged	Tax on PC

Line 2 contains these distributions:

Units	Expense Account	Location
1	01-120-7360-0000-000	USA-SAN FRANCISCO

The asset is created from invoice 100 with this information when Sum Units is checked.

Description	Cost	Units
Personal Computer	5067 USD	3

The asset contains these distributions:

Units	Expense Account	Location
2	01-110-7360-0000-000	USA-SAN FRANCISCO
1	01-120-7360-0000-000	USA-SAN FRANCISCO

The asset is created from invoice 100 with this information when Sum Units isn't checked.

Description	Cost	Units
Personal Computer	5067 USD	2

The asset contains these distributions:

Units	Expense Account	Location
2	01-110-7360-0000-000	USA-SAN FRANCISCO