Skip to content
+1-888-319-3663

COMMUNITY FORUM

Import into sales order even if one inventory item does not exist

Lewis asked 5 years ago
I have a simple Sales Invoice transaction import that will fail if one inventory item is not in inventory.  Most of these transactions have over 200 line items to import and if one is not correct the whole transaction fails.  Is there a way to allow all other 199 line items to pull in without failing the whole transaction?
 
I have the import working from an excel spreadsheet that executes the import (see below code as example), so the user does not get any error log.  the user is  frustrated when no transaction go into GP, and has no idea why.  So having the successful line items import would be a better result than none at all.
eOne.SmartConnect.RunMapConsole.exe INVOICE
thank you Lewis
 
 
Answers
Patrick Roth Staff answered 5 years ago
“Is there a way to allow all other 199 line items to pull in without failing the whole transaction?”
No. the eConnect business logic will fail and roll back the entire document.  That is the functionality of eConnect.
“eOne.SmartConnect.RunMapConsole.exe INVOICE”
If you are in excel you shouldn’t be using this commandline tool.  it wasn’t meant to give feedback to the user as you are using it for.
You should instead be using the eOne Excel Addin which would return the eConnect error back to the end user so they could fix the issue.
 
Lewis answered 5 years ago
I’ve tried the eOne Excel Addin and it is not flexible enough for our needs….I have data that is imported into excel and that was not possible to do with the addin.  I need another way to get the eConnect error back to the end user

If you would like to submit an answer or comment, please sign in to the eOne portal.