Hi All,
I’m trying to pass few fields value from document details tab to another custom tab on same screen(subcontract). here i need to filter and carry forward only the non stock item type =”N” from document lines to my custom tab.
I already created a view to bring the fields from Document details to my custom tab, but not sure how to apply the filter condition for the view. could anyone please help me on this.
Regards,
Ramya
Best answer by jinin
Hi
Can you try the BQL and check once.
PXSelectJoin<POLine, InnerJoin<InventoryItem, On<POLine.inventoryID,Equal<InventoryItem.inventoryID>>>,Where<POLine.orderNbr,Equal<Current<POOrder.orderNbr>>,
And<POLine.orderType, Equal<Current<POOrder.orderType>>,And<InventoryItem.ItemType,Equal<INItemTypes.nonStockItem>>>>> MOSTesting;
Let me know if not working.
+11Hi
You can join the InventoryItem table and check the condition.
Please refer the below code sample
PXSelectJoin<POLine, InnerJoin<InventoryItem, On<POLine.inventoryID,Equal<InventoryItem.inventoryID>>>,Where<POLine.orderNbr,Equal<Current<POOrder.orderNbr>>,
And<POLine.orderType, Equal<Current<POOrder.orderType>>,And<InventoryItem.ItemType,Equal<INItemTypes.nonStockItem>>>>> ViewName;
Hi Jinin,
Thank you so much for the response.
But my scenario is to filteronly “Non-stock Item Type” in non-stock items from Document detail lines. Non-stock is having the other types as mentioned in the below screenshot. Please help me on this.
Regards,
Ramya
+11Hi
Can you try the BQL and check once.
PXSelectJoin<POLine, InnerJoin<InventoryItem, On<POLine.inventoryID,Equal<InventoryItem.inventoryID>>>,Where<POLine.orderNbr,Equal<Current<POOrder.orderNbr>>,
And<POLine.orderType, Equal<Current<POOrder.orderType>>,And<InventoryItem.ItemType,Equal<INItemTypes.nonStockItem>>>>> MOSTesting;
Let me know if not working.
Hi
Thank you so much!!
It is working as expected. Today I learnt new thing, you are great.
Thank you,
Ramya
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
