如何在保存搜索网络套件中采用基于数量的定价 [英] How to take quantity based pricing in save search netsuite
问题描述
我必须创建一个保存搜索并获取基于数量的商品价格.怎么做.对于获取单价,我使用以下公式.
I have to create a save search and fetch pricing of items which is quantity based. How to do that. For fetching unit price, I use the following formula.
DECODE({inventorylocation},'WH29',{locationquantityavailable})
推荐答案
AFAIK数量定价在搜索连接/列中不可用.您也可以加载记录并获得数量定价.
AFAIK quantity pricing is not available in search joins/columns. You may alternatively load the record and get quantity pricing.
加载记录后,您可以对字段API进行矩阵处理以获得价格信息.
You can matrix field APIs to get pricing information after you load the record.
请注意,定价矩阵ID取决于是否启用了多种价格和多种货币功能.
Note, that the pricing matrix id varies depending on whether multiprice and multicurrency features are enabled.
[更新]
有此pricing
联接,未记录.
在搜索界面中,它具有有用的字段,例如:currency
,minimuquantity
和maximumquantity
.
In the Search UI it has useful fields like: currency
, minimuquantity
and maximumquantity
.
从脚本中,我可以获取其他字段的值,例如:
unitprice
,pricelevel
和quantityrange
From the script I could get value for additonal fields like:
unitprice
, pricelevel
and quantityrange
这篇关于如何在保存搜索网络套件中采用基于数量的定价的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!