When setting lines in an item sublist, how can I get the amount to populate from the rate? On the first line I set an item, quantity, amount. For my 2nd item, I need to set like -20% in the rate. When I do it in the UI, netsuite automatically calculates what the amount is. Doing it through a standard or dynamic record never seems to populate it, always saying I need to set the amount.

have you set a quantity? amount is rate * quantity

These are discounts so quantity isn't allowed for these items. When I fill it out manually in netsuite, I can just type in -20% in the rate and it'll autopopulate the amount to be -20% of the item above

if i had to guess, i'd think that in the webface, it goes like this: • set rate and quantity • amount gets calculated • set discount • amount gets changed so, you'd have to either use dynamic mode and reproduce the "steps you would take in the ui", or just do the math yourself (which, when involving currency calculations, may warrant some care)

I am also trying it in dynamic mode but it always errors on the commitLine because there's no amount. Im fairly confident I can just calculate the math myself, percent * amount, because I don't see anything currency related on the line level. It's just really odd, I expected this to at least function the same as the UI

i hear you 😅 i find this whole process incredibly frustrating

Thanks for helping still. I tried a lot of things anyways and nothing got the amount to automatically update so far, so at this point I'll just end up doing the math. For the time being at least it's just percent * amount If it changes in the far future, well none of those fields like currency or conversion rate even exist at the moment so I don't think I can do much there

You can set a custom price level for that line, add in a discount item with calculated discount amount, or add in a promo. If you have the logic in handy. Create auto promos might do the job tbh.