Best Of

Hi @Clarisa De Torres-Oracle ,

Your prompt response has been very helpful. Thank you so much for providing support. Got it!

Hi @User_80C0N

Please Hit the like / Awesome / Agree for the code comment I provided as a sign of gesture🙂 that would boost me for the time I spent for your requirement.

Got it!… im changing logic accordingly

<#list record.item as tranline>
<#assign itemName = tranline.item>
<#assign serialNumbers = tranline.serialnumbers>
<#assign itemIndex = -1>
<#list salesorder.item as soItem>
<#if soItem.type == 'Item' && soItem.item == itemName>
<#assign itemIndex = soItem_index>
</#if>
</#list>

<tr>
<td colspan="12" style="border: 0.5px;"><span class="itemname">${tranline.item}</span><br />${tranline.description}</td>
<td colspan="3" style="border: 0.5px;">${serialNumbers}</td>
<td align="right" colspan="2" style="border: 0.5px;">${(itemIndex != -1)?then(salesorder.item[itemIndex].quantityordered, '')}</td>
<td align="right" colspan="2" style="border: 0.5px;">${(itemIndex != -1)?then(salesorder.item[itemIndex].quantityremaining, '')}</td>
<td align="right" colspan="2" style="border: 0.5px;">${tranline.quantity}</td>
</tr>
</#list>

This code goes through each item in your Item Fulfillment document, kind of like checking off items from a shopping list. For every item it finds, it takes name and any serial numbers associated with it.

Then, it checks your sales order to see if there's a matching item. If it finds a match, it figures out how many of that item were ordered and how many are still needed.

After all that, it puts everything together on your packing slip: the item details, any serial numbers you noted during fulfillment, and the quantities that were ordered and are still left to pack.

Update - Avinash's help was instrumental in getting this template to work. I had to slightly modify the above code. Below is the code that I got to work with the two changes shown in bold.

<#list record.item as tranline>
<#assign itemName = tranline.item>
<#assign serialNumbers = tranline.serialnumbers>
<#assign itemIndex = -1>
<#list salesorder.item as soItem>
<#if soItem.ItemType == 'InvtPart' && soItem.item == itemName>
<#assign itemIndex = soItem_index>
</#if>
</#list>

<tr>
<td colspan="12" style="border: 0.5px;"><span class="itemname">${tranline.item}</span><br />${tranline.description}</td>
<td colspan="3" style="border: 0.5px;">${serialNumbers}</td>
<td align="right" colspan="2" style="border: 0.5px;">${(itemIndex != -1)?then(salesorder.item[itemIndex].quantityordered, '')}</td>
<td align="right" colspan="2" style="border: 0.5px;">${(itemIndex != -1)?then(salesorder.item[itemIndex].quantityremaining, '')}</td>
<td align="right" colspan="2" style="border: 0.5px;">${tranline.quantity}</td>
</tr>
</#list>

Again - I very much appreciate the help!!!

Hi @User_TXI1Z, yes it's sourcing the actual ship date from the sales order. You can also verify this from the search by opening the formula field column, on the formula drop down, select the Actual Ship Date then it will give you {transhippeddate}.

Hope this clarifies! :)

Just circling back to close the loop on this question. NetSuite implemented a fix for this issue and performance is fine now. No further details were provided by support as to what the issue / fix actually was.

Hi @Richard James Uri-Oracle

Yes, your article is very helpful.

Thank you so much for your support!

Best regards,
Shubham Singh.

This has been resolved.

From ${check.trandate?string['MM/dd/YYYY']}, I changed it to ${check.trandate?string['MM/dd/yyyy']}

Thanks!

Hi @gracecan,

I hope you are doing well.

Are you creating the transaction in a US or Canadian Nexus (Tax Country)? If so, this field is not available and greyed out for this countries. This is an enhancement under 165243.

This field is available for other countries such those in Europe, for example, in a German customer:

Apologies for this system limitation.