Creating new SAP B1 database

Creating new SAP B1 database

Query :

The customer has decided to create a new SAP database. They will go through some data cleansing but all in all it will be a new SAP database. Then the question is do they need to run the Retail Initialization in SAP and create a new HO database?

Answer:

 If Customer is changing data in SAPB1 database as  creation of new SAPB1 database, they will require to initialize iVend again with new SAPB1 database as CXSIntegration database will contains the SAPB1-iVend Objects mapping and used to integrate the documents between iVend and SAPB1. If anything gets disturbed in SAPB1 and CXSIntegration, Integration may not work.
​
So with this situation, our suggestion will be to re-initialize iVend completely with the newly created SAPB1 database to avoid any future issues such as integration failures .

    • Related Articles

    • ISSUES WHEN INTIALIZING MASTER TABLES FROM SAP: "iVend 6.*.*.* add-on failed to update the database"

      Product version 6.5 Update 6 Problem statement Getting Error "iVend 6.*.*.* add-on failed to update the database" when initializing master tables from SAP Reason CXSINTEGRATION DATABASE IS DELETED SAP database, already initialized with iVend database ...

    • 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 ...

    • Error in Integration Monitor (SAP to iVend) in version 6.6 for event type "Customer"

      *****************For Internal purpose********************* Product Version: iVend 6.6 Issue: Error in Integration Monitor (SAP to iVend) in version 6.6 for event type "Customer": Integration Error: System.Data.SqlClient.SqlException (0x80131904): ...

    • Cannot open database 'CXSIntegration' login failed

      Environment: iVend 6.6 Problem Statement: Cannot open database 'CXSIntegration' login failed Symptoms: Environment Specific Resolution/Work Around: It seems wrong SQL password is entered for user "sa". So need to check correct password for SQL login ...

    • SAP Business One Integration

      Introduction iVend Retail-SAP Business One Integration Extensibility is used for writing add-on application to customize integration logic. Integration extensibility Add-on allows to write business logic for orchestration of scenarios for new objects ...