ERPstuff - Oracle EBS Community

Dear Guru's

i what to know, is there any back end methor, which update ITEM Cost of good sold account. we have to change more then 2000 ITEMS costing account and it is very time consuming to change account one by one if it can be done from back end, please let me know

regards

imran hyder

Hi,

Just run a query (update comand ) with correct script to update cogs account in Mtl_Transactions ( Table ) and again run import programs from Inventory to update the cogs accounts.

Remember if you are using differnt orgs, you have to change the account code combinations .

Thanks,

Arshad

actually i want to know the name of all tables on which i have update item code id. yes have have multi org

regards

imran hyder

HI,

Update the Cost of goods sold account CCID in MTL_SYSTEM_ITEMS_B Table.

Column: COST_OF_SALES_ACCOUNT