Hello @michoel and @mattb - sorry to interrupt. If you get a chance, please take a look at a question I posted in #random.

@neerajrtiwari No worries.. I did see it at the time, I didn't answer as I don't use Netsuite Reports much. I use either Saved Searches or ODBC for almost everything.

Oh ok, no problem. Are you aware if you can pull up value of a custom field in a saved search if it does not store value?

I don't think you can

I am thinking it is the same problem in reports as well. Never mind, I will see how we can fix this. Thanks!

@mattb Sorry, I got distracted by some real work 😈

on a friday… afternoon…? 😮

Yeah, I'm actually away all next week so trying to tie up all the loose ends

And I finish early on Fridays

haha fair enough - all good!

So hopefully someone else can chime in which more details if what I wrote is not enough

@neerajrtiwari: wish I could help your #random question but a little out of my scope too

@michoel: sounds like multi-level joins will be the limitation. the dashboard link exists to quickly check sales for the given period so I all pretty swell with it otherwise

<!here|@here> How do I get the bin numbers on a picking ticket when i'm printing it using advanced PDF/HTML. If i use the basic transation form (😷) you can specify the "bin number" in the columns tab. and it'll give you a list of all available bins for x location on that item.

item.inventorydetail

However if I'm doing ${item.inventorydetail} or ${item.binnnumber} on the advanced PDF i'm getting nothing

A picking ticket is based off a sales order record

Also remember not to @ here in general

So ${item.inventorydetail} doesn't work, as that's only used when the inventory detail has been set on the record.

Since it's based off a sales order, the lines don't have their detail set I just want the list of available things to set.

AKA where they can pick it from.

I had this issue too. Could not get it to work. Everyone recommend scripting on the SO to pull in the preferred bin to a custom column. This is the only form we haven't moved to Advanced PDF.

I don’t believe you can set the item.inventorydetail on a sales order record. But that’s what I use to get bin data on the advanced form. Let me check my code.

Yeah here’s the code I use on my picking ticket form: ' <td align="center"><#if item.itemtype = "InvtPart"><#if item.inventorydetail?has_content>${item.inventorydetail}<br /><#else>No Bin Data Available. </#if> </#if></td>'

wouldn't work if he doesn't use advanced bins @jokell

Ah

We're multi location, trying to pull in the preferred bin that is associated with the location defined on that specific line.

same here @dansteg

Yeah we're not using advanced bins.

Multi Location too.