我必须创建一个保存搜索并获取基于数量的商品价格.怎么做.对于获取单价,我使用以下公式.
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
更多推荐
如何在保存搜索网络套件中采用基于数量的定价
发布评论