Has anyone had experience importing data into Sales Order Entry for a credit card order that has already been pre-authorized outside of Sage 100 ERP? In particular, we're working with Sage 100 ERP Advanced 2013 PU3 and an online store that uses a third-party add-on to process credit card transactions using Sage Payment Solutions and the same merchant key & virtual terminal ID that is used within Sage 100 ERP.
The pre-auth needs to happen from the online store so that if the credit card information is bad, the customer has the opportunity to correct it (otherwise the order won't come into Sage 100 ERP.) After good credit card information is entered and the pre-authorization is processed, we need to import this order into Sage 100 ERP, along with the details on the credit card transaction for the pre-auth. We've setup a VI import for the order itself with no problems, but getting the credit card data to import is another story. We've tried importing the authorization number & transaction ID from the pre-auth (per Sage's directive) but the credit card data failed to import because there wasn't a transaction amount. We added that in then the import failed because there wasn't a credit card GUID. We added that in then it failed because the GUID was not on file.
Any help, recommendations, and/or advice on this subject would be greatly appreciated.