I figured it out for #2. I just made 2 fields on the customer, 1 a formula, and 1 a stored value. the formula field uses a summary saved search to get the "max" date survey sent, and then a workflow is storing that value in the second field. easiest than I thought!

thanks for your reply! it helped me for #1 because I realized that I made a dumb mistake and "recentorderlink" wasn't added to the online form. for #2, i have the parent child relationship set up, so, I could populate the date if the person actually took the survey, but I want to get the date it was sent regardless if it…

it is NOT fixed yet, I would still highly advise against it. They released 2 temporary fixes for it on our account, and there are logged defects for the bugs, but the most recently fix actually just broke something else for us. We implemented with it, so we didn't have to rewrite anything, but now we're stuck building…

did you ever find a solution? in the same boat.

this, inventory adjustment is an expense account, it shouldn't be used for variance accounts.

I'm assuming you figured this out. I was struggling with trying to "join" the sales order, when I didn't have to select that field because the workflow is already looking for the sales order fields. so you just have to put "sales rep" under the value field for assigned to. the only thing I haven't found out how to do is to…

crazy, I've been trying to do exactly this. I didn't even get as far as you, mine only made 1 task for my saved search of orders and i wasn't able to pull in any fields. did you try selecting "sales order" under the join column, and then "sales rep" under the field value to the right? it wasn't working for me, but you seem…

thanks, I think the first solution is the right track. the thing is, the script doesnt run until an item is added, and then the tax rate gets posted to the line, so i guess the check box would need to be a body field or it will need another function based on the "override tax" checkbox if its a line field. I think I can…

one thing you could try is adding restrictions so only 1 form can be used, and making the field disabled. I imagine that would mean it wouldn't be highlighted when the fufillment is created.

you can add the item level location but clicking customize and adding it as a filter and/or column, but not the inventory quantity location. the fulfill orders page is not very customizable. you could probably do some fancy stuff with field sourcing and custom field workflows to get the inventory locations for each order…

the easiest way is with a workflow, I believe both things you want can be done easily. just follow along with the documentation if you get stuck but the basics of it: create a workflow applied to the transfer order, with 2 "set field value" actions. for setting the employee, select that field, then for "value", choose…

yes i'm referring to the "total" row. the "total row" on a customized report can have the formula applied to it as well.

I'm already using a formula to calculate the margin, but I don't see a way to apply it to the "total" column, the total is just summarizing the average of the formula results, not applying the forumla to the total like you can do with a report.

(You've probably already considered this or figured it out) but I've done a similar search where it's displaying line items from a transaction, and I just have it set to main line false, and the Created From shows for every line regardless. So I guess the question is why not just do main line false and then you should only…

Yes I tried that but then it doesn't sort the number as a number, basically anything that starts with 1 or 9 is first instead of it starting with around 40000 which is our newest sku

So I was able to do with using the SuiteAnswer related to the "after record submit" trigger, but that isn't the most convenient trigger. I tried importing some data to trick it into thinking it was "submitted" again but that didn't work...so not quite there. Strange that After Record Submit is the only trigger that works.

Same here, I'd like to be able to display the margin on the item level. I figured out a way with Suiteflow and a custom field that shows the margin when an item is viewed, but we're also trying to get the custom field to "store" the value I guess so it's visible on the item list page with that column filter. (but it won't…

This happened to us too. I did what OP did and it worked. Another workaround though that I think is worth mentioning is that Firefox lets you choose a launch application directly from the browser and it takes precedence over the windows default. So you can select the .bat file in Firefox to open zpl/epl

Just to follow up on this. We ended up creating a custom field with a mandatory list and a blank default value, and with one of the options being "Ready to ship", while the others being items that would not be shipping right away for whatever reason. Then we were able to filter the fulfill order screen based on this field.…

Thanks, that's actually the most recent thing I've tried but the even after it was saved as a cash sale the button for "Bill" was still active and it was pending billing - I'll head down that path further though....

how come this formula is not working? I'm just trying to pass a value if another value is selected in a multi-select field on the item record. I've tried to reverse this formula, tried using the internal id of "reverb" and i've tried using the "NOT IN" operator too, but it always just outputs 'reverbsync: off' ? CASE WHEN…

I'm using a custom tracking email that our go-live rep helped me out with - while not perfect, it's definitely better than the netsuite included one (at least for our purposes). It just requires a workflow to "send email" upon completed fulfillment, sourcing the "maximum" tracking number from a search, and building the…

Ah gotcha. ours isn't a webstore template, just a system one. must be nice that something is being phased out without a proper replacement and will little warning :)

Just curious if OP had any success here? Facing a similar situation.

I see, that's helpful actually yes, so I could potentially just not use that default record, and create an identical custom record and I would be able to access that with a script or maybe even just a workflow in that case?

This is how it works in Netsuite unfortunately and it's a pretty dangerous bug as it can really screw with your inventory value! To make sure this is right you need to adjust the "cost estimate type" line item on your RMA and item receipt to reflect the "purchase price", or "custom" and enter price if purchase price isn't…

Your use case is beyond the scope of what I could help with, but we've also been experiencing annoying bugs with this feature. feel free to chime in here :) https://usergroup.netsuite.com/users/forum/product-areas/supply-chain-management/inventory-management-aa/443813-anyone-using-the-newer-inventory-status-feature