Invoice number 00107 with invoice date 20180423 is not tally with finance figure. We checked the tblmvt table if the qty and row count is the same. Then try to zero out the unit cost column in tblshipment and run the  call sp_update_cost_accounting('00107','64.073','20180423'). The figures are now tallied.This is only in MYSQL database. We are still waiting in JDA database. 