Sale Items Marked with Fulfillment and Transaction not integrated with SAP B1

Sale Items Marked with Fulfillment and Transaction not integrated with SAP B1

This KB is for Internal Purpose Only for CitiXsys

Environment :

iVend 6.6 with SAPB1 9.2

Problem Statement :

We have noticed that Sale Items Marked with Fulfillment and Transaction not integrated with SAP B1. Verified that sale transaction stuck in integration failure monitor from iVend to SAP B1 without any error message.

Symptoms :

Not Applicable

Resolution/Work Around :


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'

Recommendations /Suggestion :

Once made above changes sale transaction will be integrated as reserve invoice in SAP B1. Suggest to use such queries with Support team .

    • Related Articles

    • General Settings in SAP Business One

      Introduction The iVend Add-on helps in setting up some configurations required for integrating iVend with SAP Business One. The following sections of this document capture the functionality of the new screens created and new fields added to the SAP ...

    • SAP Business One - iVend Retail Integration Points

      Introduction SAP Business One software is created specifically for small and midsized businesses. It is a powerful application and iVend Retail seamlessly integrates with it to help retailers better manage every aspect of their daily retail ...

    • Sale completed at POS does not show all items in AR Invoice in SAP

      Query A Sale was completed at iVend POS with 2 items (In one transaction) but when Checked in SAP, only one item available in SAP A/R invoice. Cause Need to verify the nature POS transaction. The transaction might consist of one or more items with ...

    • Sale Transactions Integrated into SAP B1 with missing Payments

      Environment: iVend Version 6.6_7635 with SAP B1 Problem Statement: Sale Transactions Integrated into SAP B1 with Missing Payments. Symptoms: Service Configuration Issue. Resolution/Work Around: We have checked that transactions are integrated with ...

    • Automatic fulfillment

      Automatic Fulfillment Fulfillment plans defined in the Management Console, can be attached to a Sale, a Special Order and a Layaway transaction at the POS. Now with the introduction of iVend Retail version 6.5, this process is now automated. What ...