Trying to show Qty remaining to be picked on pick list SO644000

Don’t you have pickedQty field in SOShipLine DAC?

I’m new to this report writer. Are you saying I should use =[SOShipline.PickedQty] for the items already picked? If so, for the items left to pick, would I use =([SOline.OrderQty]-[SoShipline.PickedQty])?

Yes, I would give it a try.

Change the Qty Picked line, per your suggestion. Still showing up as blank (see screenshot). If there’s nothing already picked (which may be the case in this example), can we return 0? Not family with the syntax on that, but the blank isn’t confirming anything either. Thanks again for your help on this. 

I am not really familiar with Report Designer, but there is an IsNull(value, nullValue) expression.
In your case it is something like this (I didn’t try): =IsNull( [SoShipline.PickedQty] , 0)

Per your suggestion, I replaced Qty Picked with:

=isNull([S0Shipline.PickedQty], 0)

It’s still showing blank (null). 

I’m sure I’m just getting the syntax wrong. 

Try to change Behavior - ProcessOrder from WhilePrint to WhileRead.

zfebert56 - I made the change to WhiteRead and now I’m getting output as “Invalid table name”.

You need to use SOShipLine instead of SOShipline.

That did something! Now I just need to make sure it’s outputting the right field in the right place. 

For Qty Picked, I have =[SOShipLine.Qty].

For Qty to Pick, I have =[SOShipLine.OpenOrderQty]