TransactionKeys for Sales/Invoices (Source Type 143) are not integrating from iVend to SAP

TransactionKeys for Sales/Invoices (Source Type 143) are not integrating from iVend to SAP

Version

Not the version-specific

Issue

TransactionKeys for Sales/Invoices (Source Type 143) are not integrating from the iVend to the SAP and there are no failed or un-processed records in the integration monitor as well.

Resolution

 Transaction Rollup (consolidation) is configured in this case. While taking into consideration Sales for eg “SOCON0011845” (Transaction Key – 4000000000045255), if you check the table named ConTrxTransactionMapping and run SQL query “Select * from ConTrxTransactionMapping where TransactionKey = 4000000000045255” this will return the record and will show IsConsolidated flag = 0 that clearly specifies transaction is a not part of any consolidation but it will be integrated with ERP not with TransactionKey=4000000000045255 but with ConsolidatedTransactionKey=900000000000000016

Select * from ConTrxTransactionMapping where TransactionKey = 4000000000045255
If we check the database we could see ConsolidatedTransactionKey has already been integrated into the ERP:

SQL Query 

Select * from RepIntegrationLog where SourceKey = 900000000000000016

So when searching for this transaction in ERP then look for the ConsolidatedTransactionKey "900000000000000016" not for the TransactionKey 4000000000045255.

This means Consolidation Key = 900000000000000016 will be used as TransactonKey in ERP, not the actual transaction key 4000000000045255 (which is in iVend).

Note: This is true in the case of Consolidation (Transaction Roll-up) is enabled in the landscape, if Consolidation is not enabled then transaction key 4000000000045255 itself will be used.
This article concludes here.