I have 500 Item Receipt transactions that must be updated. There is a custom field sourcing its value from the Project list. In those 500 IRs, there are 65 unique projects that must be replaced with another projects (correct one). There is a one-to-one relationship between the wrong project and the correct project.
Project A will always be replaced by Project AA, Project B by Project BB and so on.
Can someone suggest what is the best approach to achieve this through script? Or maybe a helpful documentation? I am not yet that familiar with arrays in NS if it needs it, so a sample or an article would be very helpful. Thank you.