Import into sales order even if one inventory item does not exist
Lewis asked 6 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
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 6 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.
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.