[Req] Unfill with key

I had like to request to allow UNFILL but using a key , in addition to EDT already doing UNFILL using similar values , but I had a case of SAME PO qty in different PO number being unfilled.

I would need an example plus expected output.

@Admin

Here it is a thread in which I suggested this and gave example, your reply was that you will add this for v2.

1 Like

It is indeed in the ‘wishlist’ already. It is a big wishlist. ;0)

I’ve looked through the code and isn’t a big change. I will see if I can get it into the next release for both Fill and Unfill.

1 Like

This now available in v2.2.0:

WOHOO , thanks for this . Allow me to give you a case where this is awesome for me . I am giving a simplistic scenario

Table A contains Sales order , number of pcs to buy
101| Zinc Grade A | 300 pcs | Client X
102| Zinc Grade B | 250 pcs | Client Y

Table B contains Purchase items , Sales order key and pcs
101 | Zinc Grade A | Supplier AB | 300 pcs

When it’s a 1-1 relationship it’s simple , issue happen when the item is purchased from 2 suppleirs

102 | Zinc Grade B | Supplier AB | 150 pcs
102 | Zinc Grade B | Supplier XY | 100 pcs

When doing a parent to child relationship , Qty required will be duplicated in each field as it’s supposed to , pivoting now will show requirement of 250+250 pcs = 500 pcs

102| Zinc Grade B | 250 pcs | Client Y |Supplier AB | 150 pcs
102| Zinc Grade B | 250 pcs | Client Y |Supplier XY | 100 pcs

So either the SQL query grows complex with a window function where we determine first row and then nullify , or in pivot tables we show 250 pcs as text
BUT NOW

UNFILL with key allows
102| Zinc Grade B | 250 pcs | Client Y |Supplier AB | 150 pcs
102| Zinc Grade B | NULL | Client Y |Supplier XY | 100 pcs

1 Like