Odoo Functional Documentation-DB Integration

This module helps to connect Remote DB using XMLRPC. Using this module we Push Purchase order from a Sale order to Remote DB. It also shows Stock of products in present DB and Remote DBs configured in the present DB.

Database Integration

Provided a menu ‘Database Integration’ under Settings menu to configure Remote  Database details.

Settings -> Database Integration. There you we could see create button. Click on the button to get a form view as shown below:

Enter the IP User name, Password, Port and name of the Remote Database. Click on  the Save button.

Company

From the location Settings -> Users &Companies -> Company. Select the company. A new tab created in the Company form view as shown in the below screenshot.

Select the Remote Database name configured. Also select the partner in the Current DB to communicate with Remote DB.

Sale

In the sale order form view, a new button has been provided with name ‘Push as PO’. This button is visible in ‘sale’ and ‘done’ states and to those customers who has entry in Connected DB One to many present in the Logged in user’s company.

Create a sale order from the location Sales -> Orders. Click  on the ‘Confirm Sale’ Button. Click on  the ‘PUSH AS PO’ button as shown in the below screenshot.

This will create Purchase Order in Databases Configured under the Database Integration menu.

If no Partner set in Remote DB Connected DB onetomany for current DB, then a warning will pop up as shown below:

Product

In product Tree view, Kanban view and Form view, A new button is added as ‘Check Stock’ as shown in the below screenshot.

On clicking the button, will pop up a wizard as shown below, with quantity available in current as well as Remote DBs for the selected product in every Internal Locations.