Thank you @Dominica Sevilla-Oracle this is very helpful! Regards

Hello @Pauline Joy Cac-Oracle It works perfectly! thank you for the good idea! Regards Hakam

Hello @Pauline Joy Cac-Oracle this is sound promising, I will try it this weekend and let you know the outcome. Sorry for the late reply, the note dropped from my list by mistake. Regards Hakam

Hi @Michelle Jabanes-Oracle , This could be a good idea, but I wonder how this will be reflected on the transaction ? if I'll create a quotation to the wholesaler, how can I link it to the sub-customer ? the sales order and activities need to be done under the name of the wholesaler not the Subcustomer. what do you think ?

Hi @Jeff Pineda-Oracle this makes more sense now, I will try it on the item record and I will use the internal ID for category, what if I keep the category filed in the CSV file empty will this remove the item from the category if it has one category or two ? I promise this will be my last question :) Regards Hakam

Hi @Jeff Pineda-Oracle , sorry to bother you, I just need a clarification about your sentence: If you want to remove all the items under that category, you can just upload a blank CSV file. what would be the CSV look like, totally empty ? no columns or values ? plus I don't know how to get the external ID for the site…

Hi @Tafara excuse my lack of knowledge here, I thought import will take maximum of 2k not 20K, I just checked and it worked as 2 files as you said, thank you very much for Ponting this to me. Regards Hakam

Hello @Joy Noreen Magoling-Oracle and @Tafara I have more than 40K items, which will be a large CSV file, if I need to split it to small files it will take a long time, hence I was trying to avoid this option, Mass update option looks promising, I would appreciate any guidance in this matter. Regards Hakam

Thank you @Patrick Fresnosa-Oracle for the update. much appreciated. Regards Osama

Thank you @Micah Timbol-Oracle this saved my day. much appreciated. Regards Hakam

Thank you @Jeff Pineda-Oracle , this is very helpful. Regards Hakam

This is very helpful !! great support! thank you very much @Ivy Lopez-Oracle

This is very helpful Pauline! thank you very much. Regards Hakam

Hello Micah! This is very good news ! I wonder if those Gurus can guide me on how to make this workflow :) Regards Hakam

thank Emilia, I found the fix for this, I created a middle state for the delay and the workflow worked :) here are the screenshots before and after for the records.

Thank you Michelle for your help. have a great day ahead! Regards Hakam

Wow! thank you Micah! this really sounds a brilliant idea, I am gonna share it with the management and hope we close this issue. thank you very much, I marked your reply as a helpful answer. much appreciated, Hakam

Thank you Micah for the link but as I mentioned this is the headquarter and all other subs are under it, in the link they said : If the subsidiary that was inactivated was a parent of another subsidiary, child subsidiaries will automatically be inactive as well! this is what I am afraid of! inactivating the HQ will close…

Thank you Jack! very helpful indeed. Regards Hakam

Thank you Erick for the great support, I will follow your instructions. Regards Hakam

Than Camille and Herts for looking on this, I hope there will be a fix soon for this issue. have a good day ahead. Regards Hakam

thank you Guys for your input, have a good day. Regards Hakam

thank you Chris and Cali for the update, If I created a new employee record, it will be as if its a new Employee, all history records financial and lead and opportunities will be related to the old record, this is rather confusing for work process. any idea how to deal with this ? can I assign these historical records to…

Yessssssss ! silly me I didn't notice that! :) thank you very much for help in this issue! much appreciated. Regards Hakam

Hello Camille! Thank you very much for the detailed reply, I used the same steps and I was able to update the customers records. I found out that updating the customer records will update all leads and prospects associated with this customer. (I hope this is correct !) one last question, is there a way to rollback an…

Hello again! I found the fix for this issue: Setup -> Accounting -> Preferences -> Accounting preferences -> SubTab : General - under classifications - untick MAKE DIVISIONS MANDATORY :) save ! Regards Hakam

Hi Camille, I created the Divisions from Setup -> Company -> Classification -> Divisions (screen shot attached) We created these Divions last year, and for every transaction we used to created we used to attach the division to it as part of the process. now that we have OneWorld upgrade and we have access to create multi…

Thanks @Emilia Ironov-Oracle , I just got the fix for this, it was on the hosting provider not form netsuite. sorry for the disturbance, I tried to delete this question but I couldn't, Regards Hakam

Thank you @Jack Daryl O Espiel-Oracle , this is very helpful. much appreciated.

Hi Jack, Thank you for your reply, to answer your questions: the fields will be set in the item record. the item type will be custom field with drop down menu (correct me if this is a wrong approach), I will set up the values for this dropdown menu, once the user select one of them, the new fields will be populated. If…