I have 500 Item Receipt transactions that must be ...
# suitescript
l
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.
p
Probably quickest to just CSV it
l
There is no Item Receipt option for CSV import. If there is, I'll be the happiest person today! Lol
p
Damn :)
p
Check celigo integrator. I believe they give you 1 free flow and this may help you. There is a small learning curve but their help section is pretty good. When you do the free trial use data loader as your option.
👍 1
c
@Luis Celigo’s CloudExtend Excel for NetSuite can help here. Item Receipts are supported. Should be piece of cake.
👍 1