Online stock update in third party tables from OIC

Hi Team,

We are using OIC3 instance.

Issue: Online stock update in third party tables from OIC

Process we are following :

   1) We have a third party database (Mssql) in which the Sales data is being updated.
   2) We have an OIC integration through which we get the stock details from the third party table in first invoke
   3) in Second invoke, Stock will be calculated according to the transactions done for transfer-in / Transfer-out
   4) Through another invoke stock details will be updated back through table-to-table mapping.

   The Tables which we are dealing with are the main tables which are getting updated frequently.
   We are calculating the stock based on the details fetched in the first invoke and updating back through third invoke, during this process before we update back the stock details, Sales are being carried out and stock is getting updated in the third party tables which are being ignored, hence impacting the accuracy of the stock details.