Compiere Synchronization Customizations

Synchronize Accounting, Customer, Inventory, Invoice, Product, Price List, Sales, Sales man. Extract, Transform, Load and Transfer the data.

Synchronize Accounting
No Accounting Posting at Branches. Transactions (Non Trade invoice) and GL Extracted will be Synchronized back in HQ and the same will be posted in HQ Database.

Synchronize Customer
Synchronization of Customer Data, mapping ID’s, Timestamp, moving one row data into appropriate relational structure. Ensure all Dependent attributes are updated. For Eg., Sales Data should update the Business partner overall Revenue field.

Synchronize Inventory
Synchronization of Inventory Data, mapping ID’s, Timestamp, moving one row data into appropriate relational structure. Ensure all Dependent attributes are updated. For Eg., Sales Data should update the Business partner overall Revenue field.

Synchronize Invoice
Synchronization of Invoie Data, mapping ID’s, Timestamp, moving one row data into appropriate relational structure. Ensure all Dependent attributes are updated. For Eg., Sales Data should update the Business partner overall Revenue field.

Synchronize Price List
Synchronization of Pricelist Information. Data Extracted from HQ Database will be loaded in all branches. All Product Information will be Synchronized in all Branches

Synchronize Product
Synchronization of Product Information. Data Extracted from HQ Database will be loaded in all branches. All Product Information will be Synchronized in all Branches.

Synchronize Sales
Synchronization of Sales Data, mapping ID’s, Timestamp, moving one row data into appropriate relational structure. Ensure all Dependent attributes are updated. For Eg., Sales Data should update the Business partner overall Revenue field.

Synchronize Sales man
Synchronization of Sales men Information. Data Extracted from HQ Database will be loaded in all branches. Salesmen Related to that branch alone will be synchronized.

Extract
Extract transaction files from SFTP server.

Transfer
Transfer the Data file into File Server via SFTP.

Transform
Transform all the Column values according to end point structure needs (if any) and transform the extracted data into a Comma Seperated Values.

Load
Load the data from files to staging table and finally to the primary tables as different transactions.

compiere_upgrade

Leave a Reply

Your email address will not be published. Required fields are marked *