Accounting of Issue

 We have physical Inventory handler department and accounting section, two section are the working we have old system where quantity and accounting handeld seperatly in these two section.

We have requirement that user create move order with some clearing account and physical section issue it and quantity should update than accounting section correct the account and corrected accounting entry transfer in the system.

One way is entering Journal entry passing in the gl that clear the clearing account and correction is made but they not like this. is there any way to resolve this issue.

We developed a custom process by which if after transact we provide accounting section a interface by which he can change account in MTL_MATERIAL_TRANSACTION table column distribution_account_id before running costing (we are using batch process of costing) than it will take all entries correct in all tables and reports. We need to correct distribution_account_id in Move order table as well.