Import into a vendor price worksheet when only some items are valid items - Everything Else

RE: Import into a vendor price worksheet when only some items are valid items

Tim Rodman — Wed, 06 Nov 2019 02:29:38 +0000

I was thinking the same thing as Ahmed, but I just tried in my Acumatica 2019 R2 (build 19.201.0070) Instance and unfortunately the entire upload fails when there is an invalid Item.

VLOOKUP seems like a good option or you could connect to your Item list in Excel using OData, then use Power Query within Excel to also connect to the Vendor Pricing and do the VLOOKUP technique in Power Query. That way you'd simply have to hit the Refresh button to get rid of any bad Items any time you get a new file from the Vendor.

RE: Import into a vendor price worksheet when only some items are valid items

AhmedBahar — Wed, 02 Oct 2019 16:16:15 +0000

Have you tried the Load Records button directly on the worksheet?

As a last resort, you could just validate and remove the lines in the data prior to attempting an import. Just need to export the stock items and do some VLookups in Excel.

RE: Import into a vendor price worksheet when only some items are valid items

William Filipiak — Wed, 02 Oct 2019 13:43:01 +0000

I have tried that.

My Import scenario & import error /results are attached. The first itme is a valid item, the second is not. If I only activate the first item, the import works.

RE: Import into a vendor price worksheet when only some items are valid items

Wyatt.ERP — Fri, 27 Sep 2019 21:36:11 +0000

Have you tried turning the Break On Error off for your import?

Import By Scenario -> Pick your Import Scenario -> Prepare -> Details Tab -> Uncheck "Break on Error" (resets each time)

https://help-2019r1.acumatica.com/(W(2))/Help?ScreenId=ShowWiki&pageid=88ac7166-2cc0-4201-ab3e-659ada2d74f2

Import into a vendor price worksheet when only some items are valid items

William Filipiak — Thu, 26 Sep 2019 20:21:26 +0000

I am trying to import into a vendor price worksheet from a spreadsheet. It the item I am trying to import exists, then all is ok.

If the item does not exist in Acumatica, The import fails.

How can this be accomplished?

The problem is a client receiving a price change from a vendor that has 16,000 items but they only carry 2,000 items. What is the best way to import the vendor price changes for only the 2,000 items?