Hi,
We often have repeated line items on our opportunity records, due to regularly using NetSuite item groups which repeat the same lines on opportunities. We calculate the sell price of our items from the cost price, adding a percentage mark up. NetSuite seems to hate the fact that we do both of these things. It seems to want us to use the sell price levels/groups and never repeat the same line item on an opportunity.
For some of our larger opportunities (100 line items plus), sales are currently spending hours going down the item list line by line, calculating the mark up (off netsuite because netsuite can't do it for them), then manually re-inputting the sell price back into NetSuite. All quoting/estimating is done off NetSuite so this seems like a futile exercise.
I tried a simple transaction import (update) with the Item Name/Number, the sell price type and the new sell price rate as follows:
but it returned the error as follows:
This seems to loop me back to NetSuite not liking me having duplicates of the same line item on the transaction, it doesn't know which one to update and wants me to use the unique "line ID" rather than the item name, but I can't see the unique "line ID" on the item list so don't know where to start to map that.
Is there a quicker way of exporting the item list from an opportunity, calculating the sell prices with a formula in excel (or manual price entry) as we did pre NetSuite, and re-importing the sell prices back in to the opportunity?