Skip to main content
Answer

Import Help - Stock Item Vendors

  • November 13, 2023
  • 3 replies
  • 108 views
craig2
Pro I
Forum|alt.badge.img+3

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.

 

 

    3 replies

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

    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.

    Acumatica Functional Consultant & Customer Experience Supervisor
    craig2
    Chris Hackett
    Naveen Boga
    Captain II
    Forum|alt.badge.img+19
    • Naveen Boga
    • Captain II
    • Answer
    • November 13, 2023

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

     

     

    Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    craig2
    Chris Hackett
    craig2
    Pro I
    Forum|alt.badge.img+3
    • craig2
    • Author
    • Pro I
    • 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!

    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility statement
    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