Need to get some advises which component should be use regarding the following scenario:
Scenario 1: New transaction added
Source A have 10 transactions and Source B have only 9 transactions. I need to copy and update the transaction #10 from Source A to Source B without copy other transaction.
Scenario 2: existing transactions have been updated
Source A have 10 transactions and someone make changes in transaction #3 let said change the quantity from 10 to 12. In Source B transaction #3, the quantity is still 10 and I need to copy only the updated transaction #3 over from Source A to Source B.
Scenario 3: Transaction deletion
Someone delete one of the transaction from Source A from 10 to 9, while in Source B, the transactions are still remain 10. If I need to update Source B regarding one of the transaction has been deleted, how can I get that work?
Please kindly advise.