Netsuite 字段 ID 未打印在高级 PDF 上 [英] Netsuite Field ID's not printing on Advanced PDF

问题描述

我正在 Netsuite 中创建高级 PDF 装箱单.我试过按照记录浏览器 (https://4779356.app.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2018_2/script/record/salesorder.html) 但只有少数不同数量的字段 ID 实际显示数据.

我试过:${tranline.quantity} ${tranline.quantityavailable} ${tranline.quantitybackordered} ${tranline.quantitybilled} ``${tranline.quantitycommitted} ${tranline.quantityfulfilled} ${tranline.quantityrevcommitted} ${record.item.quantity} ${record.item.quantityremaining} 并且只有 tranline.quantity 返回任何数据，但它返回运出的内容.>

我希望找到 quantityordered、quantityfulfilled 和 quantitybackordered，但我只能得到 tranline.quantity，显示发货的数量，应该是quantityfulfilled.

解决方案

如果您从高级 PDF/HTML 模板开始使用标准装箱单，则记录可用作项目的 record原始销售订单的履行和 salesorder.

您是否可以访问数量已完成等取决于您为 Netsuite 帐户打开的选项.如果您可以在销售订单上看到退回订购的数量，那么您可能已经打开了正确的东西.

为了协调销售订单行与履行行，我使用如下示例的代码.请注意，这要求商品尚未发货.

<#list salesorder.item as tranline><#assign shipping=0><#assign prevShipped=tranline.quantityfulfilled><#assign qtyRemaining=tranline.quantity - prevShipped><#if (tranline.quantitybackordered gt 0)><#assign qtyRemaining=tranline.quantitybackordered></#if><#list record.item as item><#if tranline.line==item.orderline><#assign shipping=item.quantity><#assign prevShipped=tranline.quantityfulfilled-item.quantity></#if></#list><tr><td colspan="12"><span class="itemname">${tranline.item}</span><#if tranline.itemtype =='NonInvtPart'>**<#分配 anyNonInvt='T'></#if><br/>${tranline.description?html}</td><td align="center" colspan="3"><#if shipping gt 0><b>${shipped}</b><#else>0</#if></td><td align="center" colspan="3">${tranline.quantity}</td><td align="center" colspan="3">${prevShipped}</td><td align="center" colspan="3">${qtyRemaining}</td><td colspan="4">${tranline.options?html}</td></tr></#list></#if>

I'm working on creating an Advanced PDF Packing List in Netsuite. I have tried following the record browser (https://4779356.app.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2018_2/script/record/salesorder.html) but only a few of the field id's for different quantities actually display data.

I've tried: ${tranline.quantity} ${tranline.quantityavailable} ${tranline.quantitybackordered} ${tranline.quantitybilled} ``${tranline.quantitycommitted} ${tranline.quantityfulfilled} ${tranline.quantityrevcommitted} ${record.item.quantity} ${record.item.quantityremaining} and only tranline.quantity returns any data, but it returns what was shipped out.

I expect to find the quantityordered, quantityfulfilled, and quantitybackordered, but I am only able to get the tranline.quantity, which displays the quantity that was shipped, which should be quantityfulfilled.

解决方案

If you are starting with the standard packing slip from an Advanced PDF/HTML template then the records are available as record for the item fulfillment and salesorder for the originating Sales Order.

Whether or not you can access quantityfulfilled etc depends on what options you have turned on for your Netsuite account. If you can see quantity back ordered on the Sales Order then you probably have the right things turned on.

In order to coordinate the sales order lines with the fulfillment lines I use code like the sample below. Note this requires that the item fulfillment is not yet shipped.

<#list salesorder.item as tranline>
    <#assign shipped=0>
    <#assign prevShipped=tranline.quantityfulfilled>
    <#assign qtyRemaining=tranline.quantity - prevShipped>
    <#if (tranline.quantitybackordered gt 0)> <#assign qtyRemaining=tranline.quantitybackordered></#if>
    <#list record.item as item><#if tranline.line==item.orderline>
        <#assign shipped=item.quantity>
        <#assign prevShipped=tranline.quantityfulfilled-item.quantity>
    </#if></#list>
<tr>
    <td colspan="12"><span class="itemname">${tranline.item}</span><#if tranline.itemtype =='NonInvtPart'>**<#assign anyNonInvt='T'></#if><br />${tranline.description?html}</td>
    <td align="center" colspan="3"><#if shipped gt 0><b>${shipped}</b><#else>0</#if></td>
    <td align="center" colspan="3">${tranline.quantity}</td>
    <td align="center" colspan="3">${prevShipped}</td>
    <td align="center" colspan="3">${qtyRemaining}</td>
    <td colspan="4">${tranline.options?html}</td>

    </tr>
    </#list>
    </#if>

这篇关于Netsuite 字段 ID 未打印在高级 PDF 上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！