We are currently using IFS Apps 9, and I am relatively new to the ERP system. As I familiarize myself with IFS, I am working on creating a quick report to retrieve purchase order line details associated with general ledger vouchers.
In the Purchase Transaction History form, there is a field for the part number description E.g. (Dye Penetrant Testing in the below screenshot), but unfortunately, there is no direct column for the part description available in this view. To retrieve the part description, I am aware that I can join the Purchase Order Line table. However, I am curious if there is an alternative method to obtain this data without requiring a join. Thank you for assistance !
![](https://uploads-eu-west-1.insided.com/ifs-en/attachment/d0d32a2d-46f4-44b1-81b8-d5e45fd9b1f6.png)