Destination record:
The number of records consolidated from all the other records will be added to the destination record at the destination records current cost.
Consolidated records:
All existing records will be removed from the record at that record’s current cost. Journal entries will be created for these adjustments.
|
Records Before |
Record Type |
Adjustments |
Result |
|
25 @ .11 each |
Destination |
+ 24 @ .11 |
49 @ .11 |
|
7 @ .10 |
Consolidated |
-7 @ .10 |
0 |
|
12 @ .11 |
Consolidated |
-12 @ .11 |
0 |
|
5 @ .12 |
Consolidated |
-5 @ .12 |
0 |
These adjustment records will be treated as any other adjustments made to inventory.
History
A consolidation history record will be created on each of the records. Below are the fields relevant to consolidation.
|
Trans Type |
Qty |
Unit Cost |
Supplier
|
PO # |
Qty Available |
Current Value |
|
Destination Record (Will have 1 history record for each consolidated record.) |
||||||
|
Consolidate |
Amount from 1 consolidation record |
Cost of Destination |
*Consolidation To |
PO from Consolidated record |
Original amt + amt of 1 Consolidated record |
Qty Available X Unit Cost |
|
Consolidated Records |
||||||
|
Consolidate |
Amount moved to Destination |
Cost of Consolidated |
*Consolidation From |
|
0 |
0 |
If a record from one of the old consolidated records is un-job costed, then the original record will be recreated. The location will be the location of the destination record.
Comments
Please sign in to leave a comment.