Solved

Inventory Transfer of an item from One Warehouse to a specific Warehouse converts it to a new item (different SKU)


Userlevel 2
Badge

Hi everybody,

We are looking for a solution on how to convert a stock item to another new item when inventory was moved to a certain Warehouse.

Example: Warehouse 1 is the main warehouse where we sell Product having SKU AAA for it’s original price. Now, there is a Warehouse 2 where we move items that are still usable but has quite damage and sold for lesser price. We need that Product AAA converted to a separate product, like SKU AAA-2, since we don’t want to track the inventory of items already moved to Warehouse 2 on the original item AAA. 

Will that be possible? That transferring an item from one warehouse to another will also move the quantity from original item SKU to new (or another) SKU?

 

 

icon

Best answer by amajors 13 May 2022, 04:56

View original

7 replies

Userlevel 5
Badge +2

Sounds like you would need to do an inventory adjustment, negative of the item from Main Warehouse and on the same adjustment do a positive of the new part number at the Second Warehouse. 

Userlevel 6
Badge +4

Sounds like you would need to do an inventory adjustment, negative of the item from Main Warehouse and on the same adjustment do a positive of the new part number at the Second Warehouse. 

That wouldn’t transfer the cogs from the original item to the new one. 

Userlevel 2
Badge

Thanks for the response @amajors . But @Jeff96 is correct. We need to move also the inventory from the original item to a new one.

Userlevel 5
Badge +2

Sounds like you would need to do an inventory adjustment, negative of the item from Main Warehouse and on the same adjustment do a positive of the new part number at the Second Warehouse. 

That wouldn’t transfer the cogs from the original item to the new one. 

It depends on where you post the adjustment to. 

Userlevel 5
Badge +2

Create a reason code for the adjustment.

Create a new Inventory adjustment

You are removing one item in the Main and adding back in the Job as a different item with costs the same. It may be more difficult if you are tracking cost differently. We use estimated unit costs.

 

Maybe other option is to make a kit assembly for the damaged part and the actual number as the stock component. Then you could build the kit number and transfer it to the new warehouse.

Userlevel 7
Badge +11

Hi @jib87 

The solution suggested by @amajors should work fine. 

There is no option available to move actual cost to new item. However, creating an inventory adjustment with negative quantity for old item issues existing item with actual cost.

Adding new item with positive quantity with exact cost at which old item was issued, ensures the item is in a way transferred to new item at same cost. 

The COGs ( or any other expense account used ) acts more like an intermediary account during the transaction. Net impact on release of adjustment on that account will be zero.

Creating an assembly may not work well since the cost of the new item is lesser than the old item used to build the assembly. 

Regards,

Userlevel 5
Badge +3

@jib87 , consider doing ‘kit asssembly’ on a destination warehouse to turn the item to the ‘damaged’ one

To do this, you can set up a kit specification having the ‘damaged’ item as a Kit Inventory Id and ‘normal’ item as a kit component (with a quantity of 1). Unit Cost of the ‘damaged’ item can be entered explicitly

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved