如何在销售订单保存搜索的行项目结果中包含主行发货日期? [英] How can I include the main line ship date in line item results for a sales order saved search?

问题描述

我正在尝试创建一个已保存的搜索，可用于按商品类型细分按时发货.但是，我注意到 {shipdate} 未包含在销售订单订单项的结果中.

I am trying to create a Saved Search that can be used to break down on time shipments by item type. However, I've noticed that {shipdate} isn't included in the results for the line items on sales orders.

Here is an example search where the "Inventory Item" line does not have ship date.

I've tried using a formula field and variations of {*.shipdate} and {mainline.shipdate}, but they only produce errors; {mainline.shipdate} produces "Field not found" and {*.shipdate} produces "Invalid Expression." I do not have the same problem with {actualshipdate} as this date is displayed on line item results when included.

How do I access this main line dimension on line item results?

解决方案

That is odd that your NetSuite isn't returning the mainline ship date on every line. It does for me, so perhaps there is a setting somewhere.

Apart from finding a setting, the simplest way to return the Ship Date on every line is with an analytic function:

MIN/*_*/({shipdate}) OVER (PARTITION BY {internalid})

这篇关于如何在销售订单保存搜索的行项目结果中包含主行发货日期?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！