From what I remember when I was dabbling with adding product images to the Advanced PDF/HTML Templates, was that I had to create a custom field for the image URL on the item record. You just can't get the URL from the store display image. var item = nlapiLoadRecord('inventoryitem',117) var imageId =…

Hold tight for 2017.1 The new reporting/searching functionality that they demoed at SuiteWorld will be in beta. Wes

Hi, I've been trying something similar, which is to reference the tracking number from the packages tab in the item fulfillment record to the invoice for which it is billed. We had originally tried to source the tracking number through sourcing and filtering on a new custom field, but Item Fulfillment is not a supported…

ajfrane, It looks like Advanced PDF Forms will be the way to go for you, once the packing slips are fixed (hopefully) in 2014.1 Wes

Sue, I just tested nlapiLookupField client-side on my Release Preview (we have not been upgraded yet), and it works the way you are using it. Wes

Thanks for the info! It's better to know to wait a week than to frustrate myself with code that won't work! The version # is in the 'view source' all the way at the bottom. Best, Wes

Thanks Corey! I'll try the original code again today and see what I get. My version yesterday was 2014.2.0.44, today is 2014.2.0.47 I've been able to get address data out through search as you've shown above, but I really will need to be able to update fields in the addresses (I will be including latitude and longitude on…

I also get the same error when there are scripts that deal with address records on the form. (Addresses are now records of their own)

Alas, I get the same error today as yesterday.... :(

This is GREAT news! Will we be able to view these changes in the release preview BEFORE our accounts go live? (Please?) Wes

Have you gotten a resolution on this? We are not on 2014.1 yet, but my Templates are set up with ${item.item} and ${item.description} in both Sales Orders and Invoices also. Thanks! Wes

OK, now that I have enabled Advanced Bin/Numbered Inventory Management, I now understand where item.inventorydetail comes from. If you have Advanced Bin/Numbered Inventory Management enabled - the Advanced Printing uses item.inventorydetail to pull serial numbers. If you do not have it enabled, Advanced Printing uses…

Hi I know this is old, but if you haven't found an answer: If you are trying to print the serial number of an item on the invoice, use {item.serialnumbers} Wes

I've also found that if you add a custom field to the address record that is of type 'Decimal Number', the new UI will not let you enter an address when adding a NEW customer, until that field has a value. Editing existing customer addresses and adding addresses to existing customers work fine, this behavior is only when…

Hi, I have found that using the same number of zeroes as the integer works: ${transaction.somebodyfield?string("0000000")} Note also, the braces are around the whole expression. Hope that helps! Wes

You could write a script, but a workflow will do it as well. Triggered on Create, Action Set Field Value, Choose the Vendor Field and the Value, then in the condition, set custom form. Hope that helps! Wes

This is my latest stab at the formula, but it still results in ERROR: Invalid Expression <table> <tr> <td>LEAST( (IF {baseprice} IS NOT NULL then {baseprice} ELSE '999999999'), (IF {pricelevel3} IS NOT NULL then {pricelevel3} ELSE {baseprice}), (IF {pricelevel4} IS NOT NULL then {pricelevel4} ELSE {baseprice}), (IF…

Here is my latest stab, but it still errors with Invalid Expression: LEAST( (CASE WHEN {baseprice} IS NOT NULL then {baseprice} ELSE '999999999' END), (CASE WHEN {pricelevel3} IS NOT NULL then {pricelevel3} ELSE '999999999' END), (CASE WHEN {pricelevel4} IS NOT NULL then {pricelevel4} ELSE '999999999' END), (CASE WHEN…

OK Tristan, Your suggestion does not result in an error, but my results are ALL NULL... I think I need an ELSE for each IF statement that will return a large number... because if the pricelevel is NULL, what does that IF statement return? I will try that. Wes

Hi Tristan, I appreciate your time in helping with this! I don't think nesting will help, as I need to find the lowest price in the pricing matrix for each item. My logic is that LEAST takes a comma separated list of numbers and returns the lowest one, with NULL being a valid lowest number (hence the need to replace NULL…

Hi All, I'm trying to output on an item saved search the LOWEST price for each item in the Price Level matrix, disregarding one level. We currently have 16 price levels. Not all price levels are populated. I'd also like a solution where it wouldn't matter if another price level were added, and would still calculate on all…

Thanks Bednar, I see how that would handle the CASE WHEN...NOT NULL pretty well. I'll try that and see if at least I don't get an Invalid Expression error. Best, Wes

Thanks Tristan! I will try it that way. Wes

Hi Tristan, Thanks for the reply, I did not try that, as LEAST will return NULL if NULL is one of the values. Since not all items have all price levels filled, this will not help. I WILL try it to see if it errors though. Wes

Ours is down too!

It seems to just be affecting our SiteBuilder site. We are implementing SC, and have that on our production account as well, but that seems to be working.

We had the same problem, but it has cleared up.

Here's the defect, not prioritized as of yet... Support Case #: 2475952. Hello Wes, We have filed the following defect on your behalf. Defect #- 404199 Transactions > Sales > Enter Sales Orders > Fill all Mandatory Fields > Save > Error: 'You have selected a promotion but have not applied it. Please apply the promotion…

Update: On the phone with support, and we've pinpointed some of the issue to the 'Calculate' (icon) button on the shipping tab interfering somehow with the 'Calculate' button on the Items tab for promotions. Sounds like a Thursday night hot-fix. Wes

Found a workaround: We have to click the Calculate button on the promotion (even though there isn't one) to save the transaction. Calling support now to log a case. Wes