I believe if "Show Internal IDs" is selected in the user preferences it will show up by default. If not, you can add a formula column and simply use the internal id field as the formula: {internalid}

Just received an email from NetSuite support - this isn't possible. There is currently an enhancement to request this functionality (143160).

Hi, I asked our account manager the exact same question last week. He came back with the following options: - Contactual - https://forms.netsuite.com/app/site/hosting/scriptlet.nl?script=232&deploy=1&compid=NLCORP&h=10c39fdab870d76b741c&custpage_published_solution_id=103&custpage_directory_solution_id=125 - Contivio.com -…

It's funny how the super complicated formulas I'm okay with, but when it comes to this stupid simple one my brain refuses to work. Really appreciate the help! :)

Ah so it can't just end. I feel dumb. Thanks. :) Any idea how I can check if the field is blank instead of zero?

So this is the formula I'm using now: CASE WHEN {custrecord_tran_customer.custrecord_tran_date} != (to_char({today}, 'mm'))-1 THEN ({custrecord_tran_customer.custrecord_tran_est_gp} * 0) ELSE CASE WHEN {custrecord_tran_customer.custrecord_tran_type} = 'Credit Memo' THEN ({custrecord_tran_customer.custrecord_tran_est_gp} *…

I have again verified that the second part of the statement works as designed. It's only the date limiting part that is erroring.

Nope, same thing. Is the 'within last month' a valid argument?

Awesome - that's a big help trimblee. I'm not exactly there yet but this is a huge step in the right direction. Thanks! And Alex I'll look into that as well.

I think it's also possible that my usage of "WHEN THEN" statements could be incorrect. If that is the case feel free to point it out. :)

What about for the previous month?

That got enough to do most of what I need. Thanks!

Actually your post helped me realize that the problem was that the location was being carried over to the invoice unnecessarily. Changed that and no longer need this report. Thanks! :)

I feel dumb. I kept looking for "Shipping Method" since that is what is was labeled on the fulfillment screen. Thanks! :)

Looks like this is a system problem, although they're calling it an enhancement: Enhancement # 73707 - Dashboard > Custom KPI from saved search with grouped results -- only one line of the results is shown for the KPI, not the search total

They're using the same date range - that's why I can't understand why the results aren't the same.

Still new to the formula stuff - didn't realize there was a popup. That did it - thank you both!

Here are some good links to reference. https://system.netsuite.com/help/helpcenter/en_US/RecordsBrowser/2011_2/index.html https://netsuite.custhelp.com/app/answers/detail/a_id/8439/kw/formulas Thanks - that first link was exactly what I was looking for. Still trying to figure out how to bring in the field on a custom…

I keep getting an error: field not found. I think it's because of the JE#:amount, because I'm not sure how to refer to it in the formula nor do I know where to find out how to refer to it.

No one else ever wants to add items to their fulfillments after creating them?

FYI... we use method to print ZPL labels from NS to wireless label printers. It might be easier a different way but this works... I setup an email template with the raw ZPL code that pulls the item data into the form. I created a workflow button on the Item record that will print the labels (we have an optional quantity…

Unfortunately this is not available. I have also been looking for such a report but it simply does not exist. Right now when we receive a PO if picking tickets aren't generated our shipping/receiving staff have to manually research every part number to see what orders are outstanding for it. It's one hell of a time waster,…

We have 3 locations so we've been using MLI from the start. I did create a new location for our shop, which is a sub-location of our main office. This should help once the inventory starts flowing properly. We can't stock the inventory that's coming in because the majority of it is not items that we keep stock of. I…

Depends on where it's supposed to go. It never has to be reallocated because it usually allocates to the correct place, the problem is that nowhere in the receiving process is that place made known. So if we get an order that goes to a work order for our shop, we get no paperwork or anything out of the system, only a…

Is anyone else having problems with not being able to tab through fields in lists? Like when you are entering items for an Estimate/Sales Order? We now have to click every single field for text entry. Our upgrade is in a few weeks and this is going to destroy the productivity of my sales staff.

Awesome. Thank you!

Does anyone have a solution for this? Our shipping department has accidentally fulfilled drop shipments quite a few times and it is causing us issues.

I have reported a defect, this has been annoying to me since we have gone live. Hopefully they can fix this one soon.

Was this ever resolved? Does anyone know how to edit the account on an expense report?

Not sure that will work for me either, as the items aren't grouped together by any common searchable field. They all have different vendors and their part numbers vary wildly. I have a feeling I'm going to have to do it manually.