Skip to main content
Solved

Import Help - Stock Item Vendors


craig2
Pro I
Forum|alt.badge.img+2

Greetings all,

I’m struggling with this Import scenario and hoping for some help.  I’m trying to create records in Stock Items > Vendors for every unique Vendor/Location/Item/Subitem combination that has been used on Purchase Orders.

I can get everything working except for the Vendor Location field.  If you don’t define it in the import, it will pull in the Default Location.  When I try to populate it though, it’s just blank.

I’ve tried both Location and Location -> Location ID, and POOrder.VendorLocationID, Location.LocationID, and Location.LocationCD.

 

Thanks for looking!

Best answer by Naveen Boga

@craig2  I just tried like below and working as expected. Please find the screenshots for reference and hope this helps.

 

 

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

3 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

Hi @craig2 

Based on the vendor selection it will pull the vendor location automatically,

Could you please update the mapping fields and update the mapping like ( TO update other locations which is not default)

lOCATION>lOCATION ID to get the needed location based on the given value in the data sheet.

Please clarify if you are looking on additional information.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • Answer
  • November 13, 2023

@craig2  I just tried like below and working as expected. Please find the screenshots for reference and hope this helps.

 

 


craig2
Pro I
Forum|alt.badge.img+2
  • Author
  • Pro I
  • 89 replies
  • November 13, 2023

Thanks @manikantad18 for the help!  @Naveen Boga  that pretty much did the trick, I did a CStr(Location.LocationCD) on the source GI, and that played nicely with the regular Location field like you showed up.

 

Hooray!


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