FormerMember

Error creating record in SO_SalesOrderPayment table, "you must enter payment information, Sage Exchange Vault Payment Identifier"

Posted By FormerMember

Hello Everyone,

I am trying to figure out how to know what is the cause of an error that will not let my software create a payment record for an incoming Sales Order. The error I got from the business object is:

"Error Creating record from table to SO_SalesOrder_Bus -> You must enter payment information in the following fields to accept the transaction. Sage Exchange Vault Payment Indentifier (This looks like a typo however this is how the system prints out the error).

The SO_SalesOrderPayment table shows that the Sage Exchange Vault Payment Indentifier is the CreditCardGUID:

During the SalesOrder integration I am bringing in the Header, Detail and Payment records, the Sales Order is created with the Header and Detail but not the Payment record. I have the integration software working on another end-user's Sage 100 system and it works, so I made sure to have all the same settings:

1) Sage 100 2018 Advanced.

2) Company is setup to Enable Credit Card payments in Company maintenance.

3) Payment Type in the AT Customer->Setup->Payment Type Maintenance is setup.

4) Here are the fields with the data in order that they are brought in:

SalesOrderNo (string)
PaymentSeqNo (string)
PaymentType (string)
CreditCardGUID (string)
CreditCardAuthorizationNo (string)
TransactionAmt (numeric)
CreditCardTransactionID (string)
ExpirationDateYear (string)
ExpirationDateMonth (string)
Last4UnencryptedCreditCardNos (string)
PaymentTypeCategory (string)
*The fields require this order to create the Payment Record.
5) The payment comes in as pre-authorized. 
I tried to find the debug log and debugging display for the Processing Debug option in the Company Maintenance-> Payment tab. I can't find the log file or do not know how the Debugging Display works. 
If anyone has an idea on how I can debug or troubleshoot the CreditCardGUID issue please let me know. 

Thank you,

Cosme