By using this website, you agree to our Terms of Use (click here)
I am trying to change vendor defaults on the stock items screen per item. Some of our items do not have a default vendor; however, they do have mulitple vendors. I tried to create an import scenario to accomplish this, but I keep getting an error.
Error: Updating 'Inventory Item Vendor Details' record raised at least one error. Please review the errors. Error: 'Purchase Unit' cannot be empty.
I just want to be able to give the vendors attached to items a default status because of having multiple vendors.
I think you're getting that error because the way you have the Import Scenario setup is telling Acumatica to add a new line to the VENDOR DETAILS tab on the Stock Items (IN202500) screen. It sounds like what you want to do is match an existing line, then update a field on that line.
Try this instead.
Excel file:
Import Scenarios (SM206025) screen:
@timrodman First of all thanks for providing this forum. It's been such a help to me as I learn how to leverage the system.
Regarding updating default vendor: I think I have followed your example exactly and I can't seem to make it work.
I'd appreciate any insight that you may have.
See attached screencaps:
Excel file:
Import Scenarios Screen:
Item I am testing the update with:
Result I get at import:
@emery-damon
1. In the import scenario, when you want to manually input value, you need to quote it such as ='True'
2. when you importing multiple vendors, I will suggest you put records in different rows in excel file then you can just use only one linenumber=-1
@fred-zhou
Thank you for your feedback, sir!
1) I modified the import scenario as you suggested. It did not work. See screenshot below
2) I don't understand what you mean. I think that I already do have records in different rows in excel file
@emery-damon
for the first screenshot, you haven't active the <Line Number>,
2 the excel format you are using is correct.
@mredamon hi mate, did you get this working at all? we're doing the same with updating the default supplier from the lowest price on the supplier price list which is a GI into a business event as the import.
have done the import scenario as where BAccount_accCD is the vendorID ID and InventoryItem_purchaseUnit is the purchase unit
This seems to work for me, but if i have already another vendor as Default its keeping now both vendors as default
I didn't have to mark Active on for mine to work, but sounds like that it works for @fred-zhou. Here's my screenshot again:
I did notice that your Inventory ID isn't mapped to the Excel file field which is probably causing an error:
I'm trying to do the above and struggling in 2023R2 update 12 as it's asking for the purchase unit when "searching" for the supplier, i've got to the point where i'm hardcoding the figures just to try and get it working but still no joy. if trying to search for two fields, does anyone know the syntax? below i have supplier and purchase unit to make sure i select the correct stock item supplier to set to default.
Thanks
for anyone looking, managed to fix this in the end after watching the video
the key thing was the "Native Field" still showing VendorID despite us have a dictionary for the UK of Vendor = Supplier. So ensure you match the native field of your criteria exactly! remove spaces etc......Had to also set "Active" flag in case any weren't, made the change and the below worked a treat for importing from a scheduled Business event that looked to a GI showing the cheapest supplier for a part from the supplier price list converted into base units and base currency (good times!)
