+1Hi all,
I’ve only started working with IFS from last week, so please bear with me :)
Would it be possible to add:
Lot Size and Order Point to
“Suppliers for Purchase parts”? basically to get a list and overview of all Purchased Parts set up.
I’ve tried using Query designer with no luck, because SupplierAssortment doesn’t have a PartNo in a dropdown menu to choose.
Best answer by Roel van Zwieten
Hi Jan,
Yes you're right that there needs to be some relationship with the entity you want to get the data from, the system uses this to decide which record to fetch the data from. You're in luck, because both the Supplier for Purchase Part and the Inventory Part Planning Data screens have the ‘Part’ and ‘Site’ fields that you can use for this.
I've created an example for the lot size field. This is creating a read only custom attribute on the PurchasePartSupplier entity that uses a select statement to get the required data from the Inventory Part Planning Data screen. You can use the same concept for another custom attribute for the Order Point.
I've used the built in page info in IFS Cloud to get the required views for this.
You can then use the Page Designer to add this new field to the Supplier for Purchase Part screen.
Hi Jan,
Are you trying to add these fields to your query in the query designer, or are you trying to add these fields to the Suppliers for Purchase parts screen?
If you're trying to add it to your query in the query designer, you can use the below screenshot as an example. Make sure you have selected the right entities and then you can configure the Join as well. The SupplierAssortment entity you have selected is referring to a different screen, that's why you don't see the expected fields.
If you want to add these 2 fields to the Supplier for Purchase Parts screen, you can use the online documentation to help you configure a Read Only custom attribute.
https://docs.ifs.com/techdocs/25r2/040_tailoring/225_configuration/400_entity_configurations/100_create_custom_attribute/
+1Hi Roel,
Thank you very much for your answer!
What I was trying to do was add these two fields to the Supplier for Purchase Parts screen. Since I’m a complete noob in IFS, I first tried going through the Query Designer. Thank you very much for the link—I’ll dig into that.
Kind regards,
Jan
+1Hi Roel,
After digging into custom attributes, ( I might be of course wrong) I found out that I cannot create a custom attribute on one entity that automatically reads data from an unrelated entity unless there is a reference between them.
So If I want to add to Supplier for Purchase Parts fileds like:
Lot size
Order Point
These values physically belong to Inventory Part Planning not to the Supplier itself.
If I am not mistaken read-only attributes can derive data only if a relationship exists
Do I create that relationship and joins in query designer and than reference it somehow in custom attributes?
Sorry If that doesn’t make too much sense :) but trying to figure this out yesterday, completely fried my brain.
Kind regards,
Jan
Hi Jan,
Yes you're right that there needs to be some relationship with the entity you want to get the data from, the system uses this to decide which record to fetch the data from. You're in luck, because both the Supplier for Purchase Part and the Inventory Part Planning Data screens have the ‘Part’ and ‘Site’ fields that you can use for this.
I've created an example for the lot size field. This is creating a read only custom attribute on the PurchasePartSupplier entity that uses a select statement to get the required data from the Inventory Part Planning Data screen. You can use the same concept for another custom attribute for the Order Point.
I've used the built in page info in IFS Cloud to get the required views for this.
You can then use the Page Designer to add this new field to the Supplier for Purchase Part screen.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
