Three Step Transfer Cost Tiers

2 minute read time.

Cost tier information is created and used differently in transit warehouses. When the transfer of goods from one warehouse to another occurs, the shipped inventory’s associated lot number, serial number and cost information are transferred to the receiving warehouse.

In the case of inventory with an ‘actual’ valuation method, the cost tiers are moved over to the receiving warehouse individually. In other cases, the entire costs for the shipped inventory are averaged, with a weighted average, and one averaged cost tier is created for the transit warehouse.  The receiving warehouse will have new cost tiers created upon three step transfer receipt according to the normal inventory valuation rules for the inventory in the receiving warehouse.

When the cost tiers for the stock being moved into the transit warehouse are built, the prior non-direct costs (freight, sales tax, other) are loaded into the direct cost component (material) of the new transit cost tier and removed from the non-direct cost components of the new cost tier. So, the tax, freight and other costs incurred originally by the shipping warehouse are all added to the direct cost of the new tier for the receiving warehouse. The old original other component costs (tax, freight, other) are cleared and loaded with new direct costs incurred as a consequence of transferring the inventory. The surcharges the shipping warehouse charges the receiving warehouse for the transferred goods are loaded into the transit cost tier ‘Other’ cost component.  The freight cost for the shipment line for the transfer shipment (entered in Edit Shipment) is loaded into the ‘Freight’ cost component of the transit cost tier.

Below is an example for one transfer order line inventory transactions where $11 freight was charged for the shipping and 3% surcharge ($7.5) was added. The data is coming from timInvtTranCost table which contains the quantities and amounts distributed from from inventory transactions to cost tiers.

Shipment

Transfer out from shipping warehouse

InvtTranKey

CostTierKey

DistQty

FreightAmt

MaterialAmt

OtherAmt

OtherMfgAmt

OutsideAmt

RunFixAmt

RunVarAmt

SetFixAmt

SetVarAmt

STaxAmt

TranType=812

3036

1186

10

2

250

3

9

4

5

6

7

8

1

Transfer in to transit warehouse

InvtTranKey

CostTierKey

DistQty

FreightAmt

MaterialAmt

OtherAmt

OtherMfgAmt

OutsideAmt

RunFixAmt

RunVarAmt

SetFixAmt

SetVarAmt

STaxAmt

TranType=813

3038

1286

10

11

256

7.5

9

4

5

6

7

8

0

Receiver

Transfer out from transit warehouse

InvtTranKey

CostTierKey

DistQty

FreightAmt

MaterialAmt

OtherAmt

OtherMfgAmt

OutsideAmt

RunFixAmt

RunVarAmt

SetFixAmt

SetVarAmt

STaxAmt

TranType=1113

3039

1287

10

11

256

7.5

9

4

5

6

7

8

0

Transfer into receiving warehouse

InvtTranKey

CostTierKey

DistQty

FreightAmt

MaterialAmt

OtherAmt

OtherMfgAmt

OutsideAmt

RunFixAmt

RunVarAmt

SetFixAmt

SetVarAmt

STaxAmt

TranType=1112

3041

1286

10

11

256

7.5

9

4

5

6

7

8

0

  • I'd like to have my cake, and eat it too.  Is there any way to preserve the original Cost Tiers with a 3-step transfer?  An unintended consequence of this is when Balancing Inventory Levels, a 3-step Transfer combined with Update Replacement Cost then inflates the destination warehouse's Replacement Cost.