We have checked found that table 'TrxTransactionFulfillment' does not have any data for sale transaction while in table 'TrxTransactionSaleItem' marked as 'HasFulfillment=1'. We have checked header data as well in table 'TrxTransaction' and found 'HasFulFillments=0' and does not have Fulfillment. We also checked that sale transaction stuck in integration failure monitor from iVend to SAP B1 without any error message.

So verified that header data did not marked with fulfillment while sale items marked with fulfillment. We have made sale transaction as normal sale and marked the sale item as 'HasFulFillments=0' in the table 'TrxTransactionSaleItem' with the help of sql statements. Later we have reprocessed the sale transaction again and sale transaction got integrated successfully and showing in SAP B1.

Please execute below queries on iVend HO Database :

select HasFulFillments,* from TrxTransaction where TransactionKey = 'Put Transaction Key'

select HasFulFillment,* from TrxTransactionSaleItem where TransactionKey = 'Put Transaction Key'

select * from TrxTransactionFulfillment where TransactionKey = 'Put Transaction Key'

update TrxTransactionSaleItem set HasFulFillment=0 where TransactionKey = 'Put Transaction Key'