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 |