Skip to main content
Solved

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


Forum|alt.badge.img
  • Jr Varsity III
  • 37 replies

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?

 

 

Best answer by amajors

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.

View original
Did this topic help you find an answer to your question?

7 replies

Forum|alt.badge.img+2
  • Semi-Pro I
  • 122 replies
  • May 12, 2022

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. 


Jeff96
Captain II
Forum|alt.badge.img+4
  • Captain II
  • 246 replies
  • May 12, 2022
amajors wrote:

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. 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 37 replies
  • May 13, 2022

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


Forum|alt.badge.img+2
  • Semi-Pro I
  • 122 replies
  • May 13, 2022
Jeff96 wrote:
amajors wrote:

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. 


Forum|alt.badge.img+2
  • Semi-Pro I
  • 122 replies
  • Answer
  • May 13, 2022

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.


Forum|alt.badge.img+11
  • Acumatica Support Team
  • 785 replies
  • May 13, 2022

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,


mvolshteyn
Acumatica Moderator
Forum|alt.badge.img+3
  • Technical Account Manager in the ISV Team
  • 109 replies
  • May 13, 2022

@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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings