My sales team is using Business Opportunity to add lines and only moving to Sales Quotation when the quote is ready to be generated for the customer. They wish to see “Available Qty” on Opportunity Lines just like the native field displays on the Sales Quotation Lines. It doesn’t appear I can create a simple read only reference field for this and need a select statement. I haven’t been able to get one to work, can someone offer assistance?
+19
There are plenty of existing knowledge in the Community in this topic.
Adding custom fields in IFS cloud environment | IFS Community
(759) Add Custom Fields | Custom Attributes | IFS Cloud | Part 2 - YouTube
+2Hello - I first tried creating a read only field using Referenced Value but there don’t appear to be any references that include this field. I then tried a Select statement to reference the Available Qty field on Inventory Part Availability Planning but could not get it to work. I looked in Apps10 and we used a Read Only Expression referencing an API. I will need to dig deeper.
My Select statement I was trying was:
SELECT AvailableQty
FROM InvPartConfigProject
WHERE PartNo:=CatalogNo
Error is: Mismatch in number of parameters and number of bindvariables (should be at least one parameter and/or bindvariable).
I’m still very new to SQL so it very well could be user error.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.