How to break consolidation into inidividual transaction.

Environment:

iVend Version 6.6 with SAPB1 9.2

Problem Statement:

How to break consolidation into individual transaction.

Symptoms:

Not Applicable

Resolution/Work Around:

Before performing Break Consolidation, please ensure the following points are checked:

• Verify in the A/R Credit Memo and A/R Invoice whether the data has already been integrated into SAP against the given consolidation key.
• If the data is already integrated into SAP:
  • Stop the Integration Service.
  • Cancel the respective A/R Credit Memo / A/R Invoice transactions.
  • Ensure that the inventory impact is ignored from SAP to iVend during this process.                         
    

Follow the below steps.

1. Take the SAP database backup

2. Stop the Replication on all stores and HO

3. Stop the Integration Service

4. Change the UseTransactionConsolidation to False in CfgEnterprise table

UPDATE CfgEnterprise

SET UseTransactionConsolidation = 0

WHERE UseTransactionConsolidation = 1

5. Change the IsConsolidated to False in ConTrxTransactionMapping table

UPDATE ConTrxTransactionMapping

SET IsConsolidated = 0

WHERE ConsolidatedTransactionKey = 'Put Consolidated Transactionkey'

AND IsConsolidated = 1

6. Mark the stuck event as success

UPDATE RepIntegrationLog

SET Flag = 1, Status = 0, ErrorMessage = 'Manual adjustment'

WHERE SourceType = 200 

AND SourceKey =  'Put Consolidated Transactionkey' 

AND Status = 1

7. Open the individual events

UPDATE RepIntegrationLog SET Flag = 0 

WHERE SourceType = 143 AND Flag = 1 

AND SourceKey IN 

(SELECT TransactionKey FROM ConTrxTransactionMapping 

WHERE     ConsolidatedTransactionKey =  'Put Consolidated Transactionkey')

8. Start the Integration Service

9. Once all the transactions are cleared from the integration monitor then reset the consolidation flag to true

UPDATE CfgEnterprise 

SET UseTransactionConsolidation = 1 

WHERE UseTransactionConsolidation = 0

10. Restart the Replication Service on all stores and HO

Recommendations /Suggestion:

The above activity must be done in non business hours and the integration/replication monitors must be cleared.

• Related Articles

• Quote's and Sales orders (Source Type 143) are ignored when transaction consolidation in on

  ********************* For Internal use for Citixsys *********************** Version 6.5 and not the version-specific Issue Quote's and Sales orders (Source Type 143) are ignored by the iVend API (GetQueueWithoutStatusUpdate()) when transaction ...

• Getting Error when configuring iVend to enable Transaction roll-up (Integration Consolidation)

  Issue: When configuring the iVend Enterprise to enable Transaction roll-up (Integration Consolidation) then getting the error "Could not save the business object". Below is the screenshot for the same: Resolution: One of the reasons for the above ...

• Transaction Rollup/Consolidation "Could not save the business Object"

  Environment: iVend Version 6.6 7747 with SAPB1 9.2 Problem Statement: While enabling transaction Roll-up in the iVend Enterprise. It displays the error message on screen “Could not save the business Object”. iVend Enterprise MC Log file displayed the ...

• Kit Item Break

  Product version: iVend 6.6 latest patch Problem statement: We have created items as Kit. These items in the Kit are individually selling items also. In some cases we just need to open the kit and sold these items individually In these cases how we ...

• Query used to found Sales Difference between iVend & SAP in Consolidation

  *******Internal to CXS Support*********** Environment : iVend 6.6 integrated With SAPB1 Problem Statement : Sales Difference between iVend & SAP against particular date transacation.Customer is using Transaction consolidation. Symptoms: NA ...