[al3xicon]

Hi all –

I have an Advanced PDF form for picking ticket. We need to display Bin Numbers on it. It seems natively they aren’t available, so I made a custom column and wrote a script to populate them on the SO, which works great – however, it doesn’t seem to work for Kits.

We have “ALWAYS PRINT KIT ITEMS ON PICKING TICKETS” turned on.

Has anyone successfully managed to print Kit member items’ bins on an Advanced PDF Picking Ticket?

If I can’t figure this out, I’ll have to revert to using Basic forms.
This is a cached copy. Click here to see the original post.

[david.smith]

I just did one of these. The item record is available but the bin is just the default bin. JCirocco did this by using the item.inventorydetail field.

Code:

…

${item.item}
${item.description} ${item.quantity} ${item.inventorydetail} ${item.options}

…

[JCirocco]

Alex, try {item.binnumber}

The customer we did a pick ticket for uses advanced bin management and item.inventorydetail worked for that.

[al3xicon]

Thanks for the responses, guys.

Sadly, neither idea worked. david.smith, as John notes, inventorydetail requires Advanced Bin Management, which we aren’t using.

There’s an example – the “Bin #” column is my custom field w/ script, which works on any non-Kit item. The two columns next to it are labeled as such and don’t work at all.

Interestingly JCirocco – ${item.binnumber} *used* to work, until a few weeks ago when they changed something to make these Advanced Forms more strict; basically, now, if a given field / bit of data is NOT available via the SuiteScripts Record Browser for a given record, then the advanced form won’t be able to use it.

It seems as though, unless I’m missing something, NS has made it so that you’re SOL if you want to use Advanced PDF Picking Ticket, and use Kits, and use Bins, but don’t use Advanced Bin Management.

¯_(ツ)_/¯

PS I opened a case asking this exact same question and got the “Your Support Package is Self Service which gives you access to Customer Support to file a defect in the application and request for a new product feature.” message. Essentially a giant “eff you” from our NS overlords.

Thanks for your help guys.

[dmashburn3]

Twice this week it sounds like updates have screwed you over pretty good. On the bright side, it appears you sell beer making kits, so that’s fun.

Cheers

[david.smith]

al3xicon we can always script it if you want. I always have some tricks up my sleeve.

[al3xicon]

Thanks dmashburn3 – drinking a pint right now as I type, while at work. It helps.

david.smith – I am plenty comfortable with scripting myself, but I didn’t see a (non-custom-record-based) solution for this one. If you have tricks you’re willing to share, I’m open to hearing them. Generally if I can’t figure it out, then a 3rd party project would probably be too big for budget. Maybe not this time, I’m all ears.

---

david.smith replied on 09/01/2016, 02:54 PM: I have a way to extend the suitscript and use the Freemarker format with your own added JSON and records. Basically, you would run your script to get your data and then load the Freemarker from a file. You can compile it into your PDF/HTML and output it as a download, email, whatever.

[al3xicon]

FWIW, my response from Support:

Support Case #: 2506699.

Hi Alex,

How are you doing? I have further information on our case.

For the Advanced template, I have tested all other ways like building Transaction Column Fields and pulling out the data from the item record on the template like you did. The only template that can print out the Bin Numbers for now is the Basic template.

Apparently, there is already an Enhancement request for this. There had been cases before that are very similar to this one. For further movement of this case, I’ll tag this case to the enhancement.

Rest assured that we’ll keep you posted on further updates on this.

Best Regards,

Kevin

[Author]

Posts