Skip to main content
Solved

Purchase Transaction history

  • July 15, 2024
  • 1 reply
  • 84 views

Forum|alt.badge.img+3

We are currently using IFS Apps 9, and I am relatively new to the ERP system. As I familiarize myself with IFS, I am working on creating a quick report to retrieve purchase order line details associated with general ledger vouchers.

In the Purchase Transaction History form, there is a field for the part number description E.g. (Dye Penetrant Testing in the below screenshot), but unfortunately, there is no direct column for the part description available in this view. To retrieve the part description, I am aware that I can join the Purchase Order Line table. However, I am curious if there is an alternative method to obtain this data without requiring a join. Thank you for assistance !

 

 

Best answer by Stefan.Schuetze

Hello.

I am not sure if this works in Apps9 as well but in Apps10 you got additional information regarding each field in menu.

As you already mentioned the information in “Part No” is connected with SQL column “PART_NO”. For description field IFS uses an internal API: “Purchase_Order_Line_API.Get_Part_Description(ORDER_NO, RELEASE_NO, SEQUENCE_NO, ORDER_TYPE)”.

If you use this expression in SQL statement, you will get the description.

Regards

 

1 reply

Forum|alt.badge.img+5
  • Hero (Customer)
  • 18 replies
  • Answer
  • July 16, 2024

Hello.

I am not sure if this works in Apps9 as well but in Apps10 you got additional information regarding each field in menu.

As you already mentioned the information in “Part No” is connected with SQL column “PART_NO”. For description field IFS uses an internal API: “Purchase_Order_Line_API.Get_Part_Description(ORDER_NO, RELEASE_NO, SEQUENCE_NO, ORDER_TYPE)”.

If you use this expression in SQL statement, you will get the description.

Regards