Integration error for Transaction "G/L Account is missing"
Environment :
iVend 6.6 with SAPB1
Problem Statement :
Failed records in Integration monitor with below error:
"System.Exception DI [INV1.AcctCode][line 3] , 'G/L account is missing (3)' at ReplicationSBOIntegrationWinSer.IntegrationObjects"
Resolution/Work Around:
Please check the below settings in SAP:
Got to Administration >> Company Details >> Find the status of the "Enable Advanced G/L account determination" field
If the “Advanced G/L Account determination” is enabled then Revenue Account must be defined for the Warehouse and the Business Date. Please check below.
Open the G/L Account Determination. Select the Inventory Tab and Click Advanced.
Make sure that there is a Revenue account defined for:
Warehouse (Booking or Delivery Warehouse based on the highlighted setting in the “Retail Setting” screen)
Business Date must fall between “From Date” and “To Date”
If the “Advanced G/L Account determination” is NOT enabled then Revenue Account must be defined for the Warehouse in the Warehouse Screen.
Recommendations /Suggestion :
Once above settings are in place then retry the concerned failed records in Integration failure monitor in Enterprise Management Console to sync those failed records in SAP.
Related Articles
Integration failure : G/L account is missing
Version: Not the specific one Issue: Failed records in Integration monitor with below error: "System.Exception DI [INV1.AcctCode][line 3] , 'G/L account is missing (3)' at ReplicationSBOIntegrationWinSer.IntegrationObjects" Resolution: Please check ...Sale record stuck in integration :DI: [RIN1.AcctCode][line: 1] G/L account is missing (1)
Product Version: iVend 6.5 update 6 Patch 2, with SAP B1 Problem Statement: Sale Transaction with both, Sale and Sale return as line items, stuck in integration. Symptom: Integration record stuck with below error: System.Exception: DI: ...Integration Error "System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [SAP AG][LIBODBCHDB"
Environment: iVend 6.6 integrated with SAPB1 HANA Problem Statement: Integration was not working and its showing below message on Event Viewer Log “System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General ...Integration Error System.Exception: DI:10000492- Tax account is missing
Product Version: 6.5 Update6 Problem Statement: - INC0012338 Transaction Consolidation record Stuck on Integration Failure Monitor with below error message from iVend to SAP. System.Exception: DI:10000492- Tax account is missing (‘VN’) Proposed ...System.Exception: DI:Under/Overpayment account is missing
Problem: Getting an error message “System.Exception: DI:Under/Overpayment account is missing” in the iVend integration monitor. Cause: The error “System.Exception: DI:Under/Overpayment account is missing” occurs when the G/L Account Determination for ...