+1Dear 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
+1Hi 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.
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.
How do you manage it? Do you use preposting distribution on PO line?
In such case there’s additional table containing preposting lines per PO line
+1Hi 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.
How do you manage it? Do you use preposting distribution on PO line?
In such case there’s additional table containing preposting lines per PO line
Hi Adam,
Thank you very much, indeed we manage pre-postings on PO line, and we have been able to find out the link at that stage.
Also on the Purchase History transaction at PO receipt, we were able to achieve this requirement.
Thank you all for your help.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
