Hi Cherylin,

You can't use BOM or Item Assembly to add costs to an existing item.  You have to use Inventory Adjustments.

<EDIT>  Item Assembly will let you add costs to an existing item, and so will Inventory Adjustments, as long as there is a quantity to assign the value to.

Or,

Are you using multiple Locations?   The 2 items may be at a different Location than where you're doing the Assembly.   If you have multiple warehouse locations A and B, and the items are in warehouse B, but you're trying to add them at warehouse A, you'll see that error message.

Or,

The item has to be in stock as of the latest transaction.  The quantity that you see when you look at the Inventory Item [Quantity] tab, is always the quantity at the 'bottom' of the 'inventory ledger card'.

Changing the date will have no effect.  Inventory transactions always happen at the 'end' of the ledger card, they aren't inserted between existing transactions.   So if you have none on hand as of the 'latest transaction' perhaps because there is a future transaction that has used them, you can't add cost to them because they aren't there.

Or,

There's a bug in Sage 50 that makes this not work in Item Assembly, but it should work in Inventory Adjustments.

Hi Cherylin,

You can't use BOM or Item Assembly to add costs to an existing item.  You have to use Inventory Adjustments.

<EDIT>  Item Assembly will let you add costs to an existing item, and so will Inventory Adjustments, as long as there is a quantity to assign the value to.

Or,

Are you using multiple Locations?   The 2 items may be at a different Location than where you're doing the Assembly.   If you have multiple warehouse locations A and B, and the items are in warehouse B, but you're trying to add them at warehouse A, you'll see that error message.

Or,

The item has to be in stock as of the latest transaction.  The quantity that you see when you look at the Inventory Item [Quantity] tab, is always the quantity at the 'bottom' of the 'inventory ledger card'.

Changing the date will have no effect.  Inventory transactions always happen at the 'end' of the ledger card, they aren't inserted between existing transactions.   So if you have none on hand as of the 'latest transaction' perhaps because there is a future transaction that has used them, you can't add cost to them because they aren't there.

Or,

There's a bug in Sage 50 that makes this not work in Item Assembly, but it should work in Inventory Adjustments.

The purpose of these entries is to factor in the landed costs of an item purchased in the USA & brought into Canada for selling purposes. This is how I've been instructed to do it:

Assembly Components (top screen)

Is the Inventory item with purchased quantities & purchase price in the unit cost

Assembled Items (lower screen)

Is the Inventory item with the landed costs added into the unit cost

The difference between the 2 costs (freight & exchange) is then entered in the Additional Costs area of the top screen.

Is this incorrect?