https://netsuiteprofessionals.com logo
m

mattb

05/10/2022, 12:01 AM
does anyone have any thoughts on how to add 30c to every line item for a particular product group that will neatly calculate towards the net/tax/gross amounts? is it a custom line field + workflow or is there something a bit more built in and dynamic as the sales order is created?
a

AI1

05/10/2022, 12:02 AM
Like if the price of the item is $2.00 you want to make it $2.30?
m

mattb

05/10/2022, 12:04 AM
yeah exactly
also taking price levels into account, so if the product is $2.00 but the price level is a 10% discount, the price needs to be $1.80 + 30c
a

AI1

05/10/2022, 12:06 AM
Does it have to be per line or can you just add 1 line at the bottom for the sum of all the extra $0.30 from all the lines
m

mattb

05/10/2022, 12:10 AM
interested in either option
i was hovering around netsuite’s own shipping cost calculator but wasn’t quite sure whether that was the answer
a

AI1

05/10/2022, 12:19 AM
You could use a workflow to sum it all up into 1 line Just make a saved transaction search that adds your $0.30 per item/line that matches your item group. Then make it a summary search Use that search as the source of a custom field on your sales order Then make an Other Charge item for sale (Can be Fullfilled = ‘F’. And call it whatever you want. Then make a workflow and use the. Create Line action on After Record Submit In your action set the item to your custom item above, quantity is 1 and Rate is from your custom field above
m

mattb

05/10/2022, 12:38 AM
that’s awesome, thank you!
3 Views