how to chage item costing account

Purchasing & Inventory forum can be used to discuss all features/issues related to Oracle Purchasing & Inventory.
Post Reply
imranhad
Posts: 56
Joined: Thu Apr 06, 2006 6:57 am
Location: Pakistan

how to chage item costing account

Post by imranhad »

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
Arshadimrany
Posts: 32
Joined: Thu Dec 21, 2006 2:20 am
Location: India

Post by Arshadimrany »

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
imranhad
Posts: 56
Joined: Thu Apr 06, 2006 6:57 am
Location: Pakistan

Post by imranhad »

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
sivasubbusn
Posts: 26
Joined: Fri Oct 05, 2007 3:58 am
Location: India

Post by sivasubbusn »

HI,

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

Column: COST_OF_SALES_ACCOUNT
Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests