how to populate class field on historical transactions the f

Question

how to populate class field on historical transactions the field was hidden before so wasnt getting populated it exists on the Items but was not populated on the Sales Order due to the field not being shown

AK47 · Answer

you had to first add the field and then you can do a mass update to populate the correct class

AK47 · Answer

there are other options like csv import and scheduled workflow task all would work

Amtoj · Answer

< AK47> we have about 100 different Classes would I need to do a vlookup to match each line with the correct class how can I do this via mass update or workflow

AK47 · Answer

< Amtoj> I would make a saved search of sales order lines that are missing the class and then a scheduled workflow to set the transaction line class = item class

AK47 · Answer

i mean there are plenty of ways to do this

AK47 · Answer

you can make a saved search of the missing so lines and include the item class in the results and then csv import that file back in although that s limited to 25k lines per import

Amtoj · Answer

thanks < AK47> i will start with the workflow

Amtoj · Answer

will let you know

AK47 · Answer

limit your search to one transaction to test it

AK47 · Answer

or a few transactions

Amtoj · Answer

< AK47> dont think I can do this via workflow just scripting it

Amtoj · Answer

2000k+ line so csv not a option

AK47 · Answer

i ve done it with a mass update I don t see anything preventing this from happening in a scheduled workflow Scripting works too though

Netsuite Tragic · Answer

last time i did it was just a case of copying over the item class to each line which I did in a workflow and just let it run