i need to refer to files when i am doing this particular task.
the first file give me details
Item, Description, Balance Quantity, Quantity Order,Quantity to be ordered.
and the second file contains the write off item codes ie these items will
not be ordered again. both these list are generated from the system and
forwarded to me to work on. i used to do it manually before but now since the
count of the line items keeps increasing i want to simplify this process and
avoid doing it manually.
can anyone help.