+1Hi,
Inventory Value Sum Report (Summarized Inventory Value Report) has option to include Parts in report. We used to do that back in IFS 8. Now it still prints Part numbers, but no part descriptions.
Is there a way to include part descriptions? Already tried to figure making custom field but cannot figure out in which entity it would work and show up in report.
+11Please see my below suggestions and see whether you could be able to get some benefits to make it successful.
1. Check the Report Layout and Base Views
• Verify if the standard report layout has changed in IFS 10 compared to IFS 8. After an upgrade, sometimes the report definitions or the views used may be different.
• Review the base view that feeds data into the report. Often, the part description might be in the base table but not included in the report output. Check the view, likely INVENTORY_PART or something related, as it contains part descriptions.
2. Add a Custom Field to the Report
• You mentioned struggling to add a custom field. Usually, for part-related data, the INVENTORY_PART entity holds part descriptions, stored in the PART_DESC field.
• Create a custom field for PART_DESC and link it to the INVENTORY_PART entity. Then, modify the report to include this custom field.
3. Customize the Report Layout
• Use IFS Report Designer to edit the layout of the Inventory Value Sum Report. You can add the part description field if it’s available in the data source.
• In some cases, you might need to update the report query to pull the part description from the INVENTORY_PART table and include it in the outputp.
4. Review Report Parameters
• Make sure you’re using the correct report parameters, as some reports allow you to enable or disable certain fields, like part descriptions, through these parameters.
If this response helps you, please mark it as the correct answer, as it will also assist other community members in future
Regards
Chanuka
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
