How to can i update transaction_date in MMT
How to can i update transaction_date in MMT
i did manually update in inventory interface with wrong date in different period and ran Inventory Interface, so the data recorded with wrong transaction date. How can i correct it?
Hi aboul3ela
If Oracle reply with update statement to MTL_MATERIAL_TRANSACTION, why it is not acceptable for you?
Also you can make a reverse transaction with the same wrong date then re-enter the right transaction with the right date.
Ex. You make a misc receipt for some items in date 2-Jan-2011 so you make misc issue with the same items in date 2-Jan-2011 then enter the misc receipt for the same items with right date.
Thanks
Hisham
If Oracle reply with update statement to MTL_MATERIAL_TRANSACTION, why it is not acceptable for you?
Also you can make a reverse transaction with the same wrong date then re-enter the right transaction with the right date.
Ex. You make a misc receipt for some items in date 2-Jan-2011 so you make misc issue with the same items in date 2-Jan-2011 then enter the misc receipt for the same items with right date.
Thanks
Hisham
Who is online
Users browsing this forum: No registered users and 14 guests