[al3xicon]

Hi all –

Anyone out there using Advanced PDF forms for a picking ticket? I got this working but suddenly two columns stopped working – one was a simple output of the qty remaining (left to pick) – I was using {item.quantityremaining} but as of a couple weeks ago that suddenly doesn’t work any more (I have a support case and defect in with NetSuite but they are saying this is expected behavior).

The other field was to output a custom transaction column that simply sourced a field from the Item record (but didn’t store the value). It’s set in Printing Fields on my sales order form and was outputting, again, without issue until a couple weeks ago when it, too, suddenly stopped showing up. This one I know I could fix with a customization (likely script) that sets the value and stores it, and displays it on the form via screen fields, but it seems like overkill and I feel like I shouldn’t have to.

Anyone have experience with these or similar issues? NS Support has been particularly frustrating on this issue, not answering my actual questions and not resolving the case.

Thanks in advance,

Alex
This is a cached copy. Click here to see the original post.

[michoel]

For quantity remaining to pick we use:

Code:

${toNumber(item.quantitycommitted) + toNumber(item.quantitybackordered)}
To source an item from the Item record, you should not have to store the value, but make sure the Show checkbox is enabled in Screen Fields, but remove all the text from the Label if you want to hide it in the UI.

[al3xicon]

Originally posted by michoel

View Post

but remove all the text from the Label if you want to hide it in the UI

I FORGOT about this neat trick! Thanks so much for the reminder. That worked wonders, I already had the field set up.

As for the quantity, I wound up using: ${item.quantity – item.quantityfulfilled}. It works so far, though I receive an error when saving the PDF Template:

Error on line 219, column 40 in template Expression item.quantityfulfilled is not numerical

Additionally, I need to display the Bin Numbers for the line item on the pick ticket. Bin Numbers do not show on the Sales Order, so I had to make a custom column field and write a script to populate the value onBeforeSubmit. It seems to work well so far, but I’m a little worried about how Kit Items will display.

Has anyone had any experience with adding Bin Numbers column to an Advanced PDF form (that works with Kit Items)?

[michoel]

Originally posted by al3xicon

View Post

As for the quantity, I wound up using: ${item.quantity – item.quantityfulfilled}. It works so far, though I receive an error when saving the PDF Template:

Error on line 219, column 40 in template Expression item.quantityfulfilled is not numerical

That’s the reason I use that Freemarker function posted above to make sure everything is converted to numbers.

[al3xicon]

michoel – thanks, I implemented your function and adapted it to my formula, it looks good and I get no error. Thanks!

[nic kcd]

al3xicon originally you mentioned adding a custom column type to Advanced PDF. I am looking for this functionality. Are you aware of anyway to add that to Advanced PDF template?

[al3xicon]

nic kcd – you can add custom column transaction fields to Advanced PDFs no problem, yup. Just refer to its script ID in your template.

[nic kcd]

al3xicon that’s what I would expect. But when I add internal id ${item.custcol_notes} into the script, I get an error. Also when I try to go to the GUI editor I cannot pull in any custom columns using the add field feature. Oh well, will dig into it more. Thanks

[al3xicon]

Hmm, what does the error say? Also, what is your surrounding code?

[nic kcd]

It gives me the very helpful “Unexpected Error”. It give me that error weather or not I am in source code or the WYSIWYG.

The code surrounding is just an HTML table. Pretty sure it is not a syntax error.

[nic kcd]

al3xicon I see what is it. There were two custom columns. custcol_notes, custcol_printed_notes. custcol_notes was not selected as show/print, I am pretty sure that is why it was throwing error… love coming into a new system.

Thanks for listening

[al3xicon]

Glad you figured it out nic kcd !

[Author]

Posts