Skip to main content
Question

Separating "PN - Description" into different columns


Forum|alt.badge.img+2

When viewing component parts on the Product Structure page the Component Part column is formatted like: “Part Number - Description”. When you export to Excel, this column is formatted the same way. We would like a dedicated column for Part Number, and a dedicated column for Description. Is there a way to achieve? Thanks

Forum|alt.badge.img+18
  • Superhero (Partner)
  • April 7, 2023

Hi @dtaranto ,

You can do this in excel as below 

 

Hope this helps!!

Regards,

Mithun K V


Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • April 7, 2023

Thank you for the response. However, the problem is many of our part numbers (and descriptions) contain the character “-”. I believe all our part numbers containing a “-” would be cut short using this approach. 


Björn Hultgren
Hero (Employee)
Forum|alt.badge.img+23

@dtaranto When I tried to export from a page with Part Number and Description in the same field, they where already separated when exported to excel. Which version are you on?

 


Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • April 11, 2023

They are not separated before the export (see screenshot below). Component part number and component part description are merged into one column called “Component Part”. I am using IFS Apps 10 (Aurena). Thanks

 

 


Björn Hultgren
Hero (Employee)
Forum|alt.badge.img+23

@dtaranto In IFS Cloud the Component Part Number and Component Part Description are displayed in the same field, but when exported to Excel they are separated into part number and description. See below:

 


Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • April 12, 2023

Not for me… Is this configurable somewhere? I would like the export to look like yours. Thanks

 

 


Björn Hultgren
Hero (Employee)
Forum|alt.badge.img+23

I think it’s an enhancement that was made in IFS Cloud that might not be available in Apps 10.


Forum|alt.badge.img+2
  • Do Gooder
  • June 26, 2023
dtaranto wrote:

When viewing component parts on the Product Structure page the Component Part column is formatted like: “Part Number - Description”. When you export to Excel, this column is formatted the same way. We would like a dedicated column for Part Number, and a dedicated column for Description. Is there a way to achieve? Thanks

Björn Hultgren wrote:

@dtaranto In IFS Cloud the Component Part Number and Component Part Description are displayed in the same field, but when exported to Excel they are separated into part number and description. See below:

 

Can you please let me know the cloud version in which, there is dedicated column for component and its description.


Forum|alt.badge.img+2
  • Do Gooder
  • June 26, 2023

@Björn Hultgren Can you please let me know the cloud version in which there is dedicated column for component and its description.


Björn Hultgren
Hero (Employee)
Forum|alt.badge.img+23

@Haru unfortunately I’m not aware in exactly which IFS Cloud version this feature became available.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings