Skip to main content
Question

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


I’m modifying the pick list to have Qty Orders, Qty already Picked and Qty left to pick. I’m running into issues.

=[SOLine.OrderQty] works for Qty Ordered.

What fields would I use to show Qty Picked and Qty left to pick?

I’ve tried various combinations of things to populate either value and they are coming up blank:

=[SOShipLine.OpenOrderQty]

=[SOShipLine.OpenQty]

=[SOShipline.Qty]

=([SOShipline.Qty]-[SOShipLine.OpenQty])

=([SOShipline.Qty]-[SOShipLine.OpenOrderQty])

=([SOShipline.OrigOrderQty]-[SOShipline.Qty])

This is outside of the realm of acumatica support, so hopefully someone has some ideas on what I’m doing wrong.

 

Denis

 

 

10 replies

Zoltan Febert
Jr Varsity I
Forum|alt.badge.img+3

Don’t you have pickedQty field in SOShipLine DAC?


  • Author
  • Freshman I
  • 5 replies
  • August 11, 2023

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])?


Zoltan Febert
Jr Varsity I
Forum|alt.badge.img+3

Yes, I would give it a try.


  • Author
  • Freshman I
  • 5 replies
  • August 11, 2023

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. 

 


Zoltan Febert
Jr Varsity I
Forum|alt.badge.img+3

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)


  • Author
  • Freshman I
  • 5 replies
  • August 11, 2023

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. 

 


Zoltan Febert
Jr Varsity I
Forum|alt.badge.img+3

Try to change Behavior - ProcessOrder from WhilePrint to WhileRead.


  • Author
  • Freshman I
  • 5 replies
  • August 14, 2023

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

 

 


Zoltan Febert
Jr Varsity I
Forum|alt.badge.img+3

You need to use SOShipLine instead of SOShipline.


  • Author
  • Freshman I
  • 5 replies
  • August 14, 2023

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]

 


Reply


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