Import into a vendor price worksheet when only some items are valid items
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?
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)