Skip to main content
Solved

Import Stock Item Location Update

  • 17 February 2021
  • 2 replies
  • 602 views

Forum|alt.badge.img+2

I’m still new to Acumatica and am making headway with getting our data the way we need it. When we did our initial setup, our bin locations did not get imported as the In & Out default location for items. Because of this, we have to do a lot of manual entry of stock locations. I have run an import scenario to update this information but it’s not updating. Does anyone have a setup they can share with me so I can see what I’m doing wrong. The Source field / Values below are from an already setup import. I modified and used columns in Excel that already existed.

 

Best answer by wfilipiak67

Hi Abe, 
These fields need to be updated either from the Item Warehouse Details form (IN204500) & not the stock  Items form. Or you can update the Warehouse Defaults on the GENERAL SETTINGS Tab. This would update just the default warehouse settings. 

A rule of thumb I use is, if I cannot change the data manually, the import scenario will have issues.

 

 

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

2 replies

wfilipiak67
Captain II
Forum|alt.badge.img+3
  • Captain II
  • 98 replies
  • Answer
  • February 18, 2021

Hi Abe, 
These fields need to be updated either from the Item Warehouse Details form (IN204500) & not the stock  Items form. Or you can update the Warehouse Defaults on the GENERAL SETTINGS Tab. This would update just the default warehouse settings. 

A rule of thumb I use is, if I cannot change the data manually, the import scenario will have issues.

 

 


Forum|alt.badge.img+2
  • Author
  • Semi-Pro I
  • 122 replies
  • February 19, 2021

Thanks @wfilipiak67. I started fresh with the import and was able to update both the stock item information and the warehouse information. 


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