Skip to main content
Question

Relation between Fixed Asset Object and Purchase Order lines

  • June 9, 2026
  • 1 reply
  • 24 views
A
Do Gooder (Partner)
Forum|alt.badge.img

Dear community,

When several Fixed Asset Objets are created at Purchase Order release, does anyone know how to retrieve the link between the PO lines and the connected Fixed Assets ?

On PO lines, we can identify the FA objet No when 1 FA objet is created, in the Code F or G field. However when multiple FA objets are created this field is blank.

Does anyone knows if a view contains this information ?

Our client is using in IFS Cloud 25R2.

 

Thank you very much !

1 reply

Furkan Zengin
Ultimate Hero (Partner)
Forum|alt.badge.img+21
  • Furkan Zengin
  • Ultimate Hero (Partner)
  • June 9, 2026

Hello Anita,

codeno_d is the code part for fixed asset in my case. So use this select statement and see if it returns required information

select * from IFSAPP.PURCHASE_ORDER_LINE_ALL where pre_accounting_id in (select pre_Accounting_id x from IFSAPP.PRE_ACCOUNTING where codeno_d=object_id and company=company)

Hope this helps

Furkan

https://superp.solutions/
Terms & ConditionsAccessibility statement