Skip to main content
Solved

Why Can the "Soshipline.openorderqty" NOT be found in GI? How can I filter the not shipped full item out?

  • 11 December 2020
  • 3 replies
  • 117 views

Forum|alt.badge.img+5
  • Captain II
  • 398 replies

Hello,

      We don’t generate “Back order”  in business.

That is, even if the soline is not shipped in full, the soline would become completed after shipment and the OPEN QTY on soline would become 0

           

But I checked, this item on its shipment line would remain open qty on screen.

     However, when I trying to make the conditions in GI, I can not find the SOShipline.OpenOrderQty field.

      Since GI does not support the condition in formula like:

  SOShipline.OrderQty - SOShipline.ShippedQty >0
    

       How can I filter out the items that did not ship in full in daily business?
        Thank you

Best answer by ray20

Hello, I am sorry, Actually, the below setting will work:

 

 

But still, it is a little bit strange that
OpenOrderQty can be found in Results tab
But it can NOT be found in conditions tab

View original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img+5
  • Author
  • Captain II
  • 398 replies
  • Answer
  • December 11, 2020

Hello, I am sorry, Actually, the below setting will work:

 

 

But still, it is a little bit strange that
OpenOrderQty can be found in Results tab
But it can NOT be found in conditions tab


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 625 replies
  • December 11, 2020

Hi @ray20 ! In this case the OpenOrderQty is a calculated field and may require other fields from the SOShipLine table to be present to be able to calculate the result, or it may be that the calculation takes place on the page you see it on and you will need to re-create the calculation in the GI.

Often times a calculated result will need to have this setup in the expression to show the field since the actual field isn’t storing values. 

Sounds like your workaround fits for this situation but an expression on the results grid subtracting the closed qty from the total should leave you the open qty.


Forum|alt.badge.img+5
  • Author
  • Captain II
  • 398 replies
  • December 12, 2020

@BenjaminCrisman Thank you, Benjamin, you and your colleagues are always helpful and warm hearted.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings