This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I need to read 2 record types.. price update (start date) and price update detail (price level, quantity and unit price) and update the item prices

Probably want to use a map reduce script for this one

Start with a search to get the price update records you want to process

That should be the return object for the getInputData stage

For your map, you should do a search for the matching detail records of the price update and write each one to the reduce

During the reduce, you update the item with the information from the detail record ( and probably mark the detail as processed so it isnt processed again)

If you are clever, you can probably combine the price update and detail search into one and do the item updates in map instead

Wow.. thanks for the suggestion. I will try this