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 !
+21Hello 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
Hi Furkan,
Thank you very much for your reply. Unfortunatly when multiple FA are created for 1 PO line, the code part for fixed asset is empty, and therefore we loose this direct link.
Thank you.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.