Skip to main content
Question

Purchase Order Lines received quantity

  • September 16, 2022
  • 6 replies
  • 380 views

Forum|alt.badge.img+6

Hello,

 

I would like to see the received quantity of purchase order lines from the Purchase Order screen, PurchaseOrderLinePart and PurchaseOrderLineNopart. For example, each Part Order Line may be partially received, and I would like to see a reference to the quantity received for lines at any given time from this screen.

 

Is this possible?

 

Thank you!

Adam

6 replies

Dilan Senevirathne
Superhero (Partner)
Forum|alt.badge.img+14

Hi @acjedynak 

As per the current application design there is no field in the order line that shows the received qty. But you can get it done through a custom field.

 

Thank You.


Forum|alt.badge.img+6
  • Author
  • Sidekick (Customer)
  • September 19, 2022

Thank you @Dilan Senevirathne . Do you know best approach for the custom field solution, such as what field(s) from elsewhere in the application best reflect the received qty for purchase order lines?

 

Thank you,

Adam


Forum|alt.badge.img+6
  • Author
  • Sidekick (Customer)
  • September 20, 2022

This was solved by using the Receipt_Info_API.Get_Sum_Qty_Arrived_By_Source API call in a custom field.


Forum|alt.badge.img+5
  • Sidekick (Customer)
  • October 18, 2023

Anyone know the input parameters for this? We are hosted so am unable to look on the db.


Forum|alt.badge.img+6
  • Author
  • Sidekick (Customer)
  • October 18, 2023

@Tim We are using Apps10 in an on-premise environment, so if you are on Cloud or hosted the solution may not work. But for anyone who might find it helpful, our solution was to make a read-only custom field in PurchaseOrderLine. The full expression I’m using is:

 

Receipt_Info_API.Get_Sum_Qty_Arrived_By_Source(ORDER_NO, LINE_NO, RELEASE_NO, Null, 'PURCHASE_ORDER')

 

And for reference, these are the parameters to be passed through that function:

 

 

 

I leave the last two out so they default to null.

 

 

 


Forum|alt.badge.img+6
  • Sidekick (Partner)
  • December 11, 2023

Hi @Tim

In the IFS cloud, what would be the solution?, Can we add a custom field to show the receipt Qty in IFS Cloud?

 

Regards,

NayD