Skip to main content

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!

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.

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

 

 

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


Terms & ConditionsCookie settings