Synchronize Two SAP Business One Database

[Former Member]

Dear All,

     Good Day !!

               I need a solution for the following scenario:

• One of our client have operation in two different country like India and Dubai, 
• Both the place they are doing the same operation and they need to update the transaction in one Common Database (Sap Business One)
• But they need to use two different server for India Separate and in Dubai Separate
• End of the day, both data should be synchronize and they have to see the both location transaction from Dubai and also India.

Ex : India they will create PO in SAP Business One DB (India) and  the same PO can be able to see in SAP Business One DB ( Dubai ) 

Note : "Two different server" is a main requirement of the Client . They don't want to depend on the single server ( It should be like Banking Operations )

Please let me know if there is any solution....

Thanks in Advance,

Sudhir.J

[Former Member · Accepted solution]

Dear Sudhir,

I can see your requirement is a bit confusing. I need clarification on below question so that i can suggest you the way forward.

Q1. Do you have 2 databases (India and Dubai) and you want to synchronize data to 3rd database i.e. Group (Common) Database ?

Q2. Do you have only 2 databases (India and Dubai) and whatever you transact in India will go to Dubai database and vise versa.

Regards

Ashish Ranjan

[Former Member · Accepted solution]

Dear Mr.Ashish Ranjan,

          Greetings for the day!!!

     Thank you for your reply ..... Actually we haven't yet started the immplementation . We are planning within this year.

My scenario is as per your Question 2 ( Q2 ) -- let me know the solution

Please suggest us if you have any other new idea .....

Regards,

Sudhir.J

[Former Member · Accepted solution]

Hi Sudhir,

I guess you can setup B1i Integration Solution to pass the transaction from one DB to other which called intercompany.

You can also do it for the consolidation so the transactions from both DBs will synchronize in third DB.

Thanks,

Rahul

[Former Member · Accepted solution]

Dear Mr.Rahul Moundekar,

     Thank you for your Reply!!!

     Your guess is wrong i know about the B1i Integration Solution. It is like transaction between the branch to HO . Like HO Sales Order placed as a PO in Branch.

     But my scenario is different . Both DB should be update automatically In A if u create PO it should be update in B, vis versa...

Regards,

Sudhir.J

[Former Member · Accepted solution]

Hi Sudhir,

You can use B1iF (Business One Integration Framework) tool to sync the data.

This can be a bit hectic as you need to find out what are the transaction (SAP Objects) you need to sync between the database.

There are very few standard scenarios which are available for B1iF.

see below link:

Regards

Ashish Ranjan

[Former Member · Accepted solution]

Dear Mr.Ashish Ranjan,

          Thank you for your valuable Suggestion:

          Can you please help me further ? And I have checked your above mentioned link it is going to the common page "" . where i can able to find exact documentation ,  if  i suppose going with B1iF.

Regards,

Sudhir.J

[Former Member · Accepted solution]

Hi Sudhir,

My guess is correct. It can be done using B1i.

Thanks,

Rahul

[Former Member · Accepted solution]

Dear Mr.Rahul Moundekar,

     Yes i do agree your guess is correct!! But the question is not for Inter company . I need to know the option for synchronize two DB .

A    ( DB)                                          B (DB)

PO------------------------------------------>      PO

GRPO ------------------------------------>     GRPO

A/P Invoice ----------------------------->     A/P Invoice

SO------------------------------------------>     SO

Delivery ---------------------------------->     Delivery

A/R Invoice ----------------------------->    A/R Invoice

Like all the transactions..... ( Marketing ,Payments,Master,ext...)

I think you know very well about inter company transaction. ( Inter Company Integration will not suitable )

Regards,

Sudhir.J

[Former Member · Accepted solution]

Hi Sudhir,

Check below link:

http://www.compnetgmbh.de/downloads/1-b1if-overview.pdf

Regards

Ashish

[Former Member · Accepted solution]

Dear Mr. SUdhir,

B1i Integration Framework (B1iF) has an ability to do intercompany transactions like PO2So or SO2PO as well as PO2PO, AP2AP etc.

So basically you can use B1i to get this done. Hope this is sufficient to get an idea what it does.

Thanks,

Rahul

[Former Member · Accepted solution]

Dear Mr.Rahul Moundekar,

Thank you,

      I am very Happy to receive immediate reply from you people !! Thank you once again i will do as per your  suggestion . Please provide me if you have any specific documentation.

Thanks& Regards,

Sudhir.J

[Former Member · Accepted solution]

You can visit SAP Portal to check the documentation for B1iF or SCN community for Integration components.

Thanks,

Rahul

[Former Member]

Hi Sudhir,

I am having the exact same scenario as yours. can you please assist in case you got a solution to your question? I will really appreciate.

[Former Member]

Hi Sudhir,

You may create these documents manully but getting the details using formatted searches so that the user does not have to enter items, quantities prices etc. manually.

You may create these documents via dtw on a daily basis else, you may opt for development.

Thanks,

Joseph

[Former Member]

Dear Mr.Joseph Antony,

     Please explain me in detail if i want to post all the transaction through DTW. How can i able to send the document to approval from one location to another location.

Regards,

Sudhir.J

[Former Member]

Hello,

DTW is a tool to import documents, OB etc and not for admin related processes like approval.

You can import only the approved Purchase orders from one db to another else you may opt for development and create a solution that fits your requiremment.

Thanks,

Joseph

[Former Member]

Hi Sudhir,

Check this link

http://stackoverflow.com/questions/20819947/ssrs-report-builder-2-0-how-to-link-2-servers-and-run-in...

Regards,

SP Samy

[Former Member]

Dear Mr.SP Samy,

     Are you explaining about generating report wia SSRS ?? i need a solution to map two different B1 need to integrate A to B and B to A finally both should show same transaction in Data Base.

Regards,

Sudhir.J