PO wise supply issue

[majidsiddique]

Hi all,
I have a problem in issue the products on the basis of PO wise ( PO means purchased order issue by Hospital with all term and condition QTY, PRICE ,Supply, etc. ). We can’t serve complete PO qty on a one day with different reason but issue to hospital on demand basis. There is a problem in PO No because same PO No issued by another hospital with different or same item description.
In this way I make a small summary of PO wise detal issue by hospital:
In H3 used formula to find out value of PO Qty issued by Hospital:
=IF(AND(D3=$M$3:$M$7,E3=$N$3:$N$7),VLOOKUP(E3,$N$3:$P$7,3,0),0)
In H7 to H9 formula failed:
H7=0, H8=#value!, H9= #value! Result
In j3:
I have to balance out of PO Last balance Qty – issued Qty automatic like below mention table.
I find out out small PO balance Qty in a table but, how to apply with minus issued Qty.
P9={=SMALL(IF((n9=D3:D12)*(o9=E3:E12),J3:J12,""),ROWS(A1:A1))}
When PO balance Qty of any PO no ( 95255 and NICVD ) will be Zero then all PO partial would be changed PO complete where they are.
If anybody has a better idea to record this transaction in a different way to easy find out my result then tell me.
It is manual sheet update with small data:

[TABLE="width: 708"]
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Dec.No[/TD]
[TD]Date[/TD]
[TD]PO No[/TD]
[TD]Hospital Name[/TD]
[TD]Item[/TD]
[TD]Description[/TD]
[TD]PO Qty[/TD]
[TD]Supply Qty[/TD]
[TD]Balance[/TD]
[TD]PO Status[/TD]
[/TR]
[TR]
[TD]KCN-001[/TD]
[TD]01/11/2018[/TD]
[TD]95255[/TD]
[TD]NICVD[/TD]
[TD]RINT[/TD]
[TD]Resolute[/TD]
[TD]1500[/TD]
[TD]100[/TD]
[TD]1400[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-002[/TD]
[TD]02/11/2018[/TD]
[TD]62500[/TD]
[TD]TABBA[/TD]
[TD]INT[/TD]
[TD]Baloon[/TD]
[TD]4000[/TD]
[TD]200[/TD]
[TD]3800[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-003[/TD]
[TD]04/11/2018[/TD]
[TD]95255[/TD]
[TD]TABBA[/TD]
[TD]INT[/TD]
[TD]Baloon[/TD]
[TD]4000[/TD]
[TD]400[/TD]
[TD]3400[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-004[/TD]
[TD]05/11/2018[/TD]
[TD]95255[/TD]
[TD]NICVD[/TD]
[TD]RINT[/TD]
[TD]Resolute[/TD]
[TD]1500[/TD]
[TD]200[/TD]
[TD]1200[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-005[/TD]
[TD]05/11/2018[/TD]
[TD]95255[/TD]
[TD]TABBA[/TD]
[TD]INT[/TD]
[TD]Surgery[/TD]
[TD]4000[/TD]
[TD]500[/TD]
[TD]2900[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-006[/TD]
[TD]06/11/2018[/TD]
[TD]95255[/TD]
[TD]NICVD[/TD]
[TD]RINT[/TD]
[TD]Resolute[/TD]
[TD]1500[/TD]
[TD]900[/TD]
[TD]300[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-007[/TD]
[TD]07/11/2018[/TD]
[TD]95255[/TD]
[TD]TABBA[/TD]
[TD]INT[/TD]
[TD]Baloon[/TD]
[TD]4000[/TD]
[TD]1000[/TD]
[TD]1900[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-008[/TD]
[TD]09/11/2018[/TD]
[TD]95255[/TD]
[TD]NICVD[/TD]
[TD]RINT[/TD]
[TD]Resolute[/TD]
[TD]1500[/TD]
[TD]300[/TD]
[TD]0[/TD]
[TD]PO complete[/TD]
[/TR]
[TR]
[TD]KCN-009[/TD]
[TD]10/11/2018[/TD]
[TD]95255[/TD]
[TD]TABBA[/TD]
[TD]INT[/TD]
[TD]Baloon[/TD]
[TD]4000[/TD]
[TD]2000[/TD]
[TD]900[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-010[/TD]
[TD]10/11/2018[/TD]
[TD]95255[/TD]
[TD]TABBA[/TD]
[TD]INT[/TD]
[TD]Baloon[/TD]
[TD]4000[/TD]
[TD]900[/TD]
[TD]0[/TD]
[TD]PO complete
[/TD]
[/TR]
</tbody>[/TABLE]

 

[majidsiddique]

Small Summary detail PO hospital:

[TABLE="width: 344"]
<colgroup><col><col><col span="2"><col></colgroup><tbody>[TR]
[TD]Hospital PO[/TD]
[TD]H.Name[/TD]
[TD]Description[/TD]
[TD]Description[/TD]
[TD]PO QTY[/TD]
[/TR]
[TR]
[TD]95255[/TD]
[TD]NICVD[/TD]
[TD]RINT[/TD]
[TD]Resulute[/TD]
[TD]1500[/TD]
[/TR]
[TR]
[TD]62500[/TD]
[TD]TABBA[/TD]
[TD]ONYX[/TD]
[TD]Resulute[/TD]
[TD]2000[/TD]
[/TR]
[TR]
[TD]70001[/TD]
[TD]NICVD[/TD]
[TD]NCEUP[/TD]
[TD]Baloon[/TD]
[TD]5000[/TD]
[/TR]
[TR]
[TD]8001[/TD]
[TD]AKU[/TD]
[TD]SPL[/TD]
[TD]Baloon[/TD]
[TD]4000[/TD]
[/TR]
[TR]
[TD]95255[/TD]
[TD]TABBA[/TD]
[TD]INT[/TD]
[TD]Baloon[/TD]
[TD]4000[/TD]
[/TR]
</tbody>[/TABLE]

 

[Logit]

.
If I correctly understand your issue, you are seeking a means to assign PO numbers that were issued by two different hospitals .. so you can accurately fulfill their order requests.

If this is the issue, consider concatenating the hospital's first letter in their name to the end of the PO number. This will make it easier to sort the data and ensure you are selecting the
right PO numbers for the specific hospital.

Paste this macro into a module. Run it by pasting a command button on the sheet in question. The macro is set for "Sheet1". If your sheet name is different you will need to edit the code
to reflect the correct sheet name.

Option Explicit




Sub Concat()
    Dim i As Long, lRow As Long
    With Sheets("Sheet1")
        lRow = .Range("C" & Rows.Count).End(xlUp).Row
        For i = 2 To lRow
            Sheets("Sheet1").Cells(i, 3) = .Cells(i, 3) & Left(.Cells(i, 4), 1)
            
        Next i
    End With
End Sub

Download sample workbook : https://www.amazon.com/clouddrive/share/3ZLMjNjWmCjOzc5tQxaU8tiKIAXseWJp7u8RGemjStw

 

[majidsiddique]

Hi logit:
this is small example actually PO range too lengthy. you can see it summary PO report range N2 to R7:
[TABLE="width: 344"]
<colgroup><col><col><col span="2"><col></colgroup><tbody>[TR]
[TD]H.Name[/TD]
[TD]Hospital PO[/TD]
[TD]Item[/TD]
[TD]Description[/TD]
[TD]PO QTY[/TD]
[/TR]
[TR]
[TD]NICVD[/TD]
[TD]95255[/TD]
[TD]RINT[/TD]
[TD]Resulute[/TD]
[TD]1500[/TD]
[/TR]
[TR]
[TD]TABBA[/TD]
[TD]62500[/TD]
[TD]ONYX[/TD]
[TD]Resulute[/TD]
[TD]2000[/TD]
[/TR]
[TR]
[TD]NICVD[/TD]
[TD]70001[/TD]
[TD]NCEUP[/TD]
[TD]Baloon[/TD]
[TD]5000[/TD]
[/TR]
[TR]
[TD]AKU[/TD]
[TD]8001[/TD]
[TD]SPL[/TD]
[TD]Baloon[/TD]
[TD]4000[/TD]
[/TR]
[TR]
[TD]TABBA[/TD]
[TD]95255[/TD]
[TD]INT[/TD]
[TD]Baloon[/TD]
[TD]4000
[/TD]
[/TR]
</tbody>[/TABLE]

can any you tell me if any error on this, i am using it;
=IF(AND(D3=VLOOKUP(D3,N3:O7,2,0),E3=VLOOKUP(E3,N3:O7,1,0)),CONCATENATE(D3,left(E3,3)),0)
not working in F3:
how i can Qty minus with smallest value of PO, mention below table.

[TABLE="width: 807"]
<colgroup><col><col><col><col span="2"><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Dec.No[/TD]
[TD]Date[/TD]
[TD]PO No[/TD]
[TD]Hospital Name[/TD]
[TD] [/TD]
[TD]Item[/TD]
[TD]Description[/TD]
[TD]PO Qty[/TD]
[TD]Supply Qty[/TD]
[TD]Balance[/TD]
[TD]PO Status[/TD]
[/TR]
[TR]
[TD]KCN-001[/TD]
[TD]01/11/2018[/TD]
[TD]95255[/TD]
[TD]NICVD[/TD]
[TD]#N/A[/TD]
[TD]RINT[/TD]
[TD]Resolute[/TD]
[TD]1500[/TD]
[TD]100[/TD]
[TD]1400[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-002[/TD]
[TD]02/11/2018[/TD]
[TD]62500[/TD]
[TD]TABBA[/TD]
[TD]62500TAB[/TD]
[TD]INT[/TD]
[TD]Baloon[/TD]
[TD]4000[/TD]
[TD]200[/TD]
[TD]3800[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-003[/TD]
[TD]04/11/2018[/TD]
[TD]95255[/TD]
[TD]TABBA[/TD]
[TD]FALSE[/TD]
[TD]INT[/TD]
[TD]Baloon[/TD]
[TD]4000[/TD]
[TD]400[/TD]
[TD]3400[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-004[/TD]
[TD]05/11/2018[/TD]
[TD]95255[/TD]
[TD]NICVD[/TD]
[TD]FALSE[/TD]
[TD]RINT[/TD]
[TD]Resolute[/TD]
[TD]1500[/TD]
[TD]200[/TD]
[TD]1200[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-005[/TD]
[TD]05/11/2018[/TD]
[TD]95255[/TD]
[TD]TABBA[/TD]
[TD]62500TAB[/TD]
[TD]INT[/TD]
[TD]Surgery[/TD]
[TD]4000[/TD]
[TD]500[/TD]
[TD]2900[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-006[/TD]
[TD]06/11/2018[/TD]
[TD]95255[/TD]
[TD]NICVD[/TD]
[TD]#VALUE![/TD]
[TD]RINT[/TD]
[TD]Resolute[/TD]
[TD]1500[/TD]
[TD]900[/TD]
[TD]300[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-007[/TD]
[TD]07/11/2018[/TD]
[TD]95255[/TD]
[TD]TABBA[/TD]
[TD]#VALUE![/TD]
[TD]INT[/TD]
[TD]Baloon[/TD]
[TD]4000[/TD]
[TD]1000[/TD]
[TD]1900[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-008[/TD]
[TD]09/11/2018[/TD]
[TD]95255[/TD]
[TD]NICVD[/TD]
[TD]#VALUE![/TD]
[TD]RINT[/TD]
[TD]Resolute[/TD]
[TD]1500[/TD]
[TD]300[/TD]
[TD]0[/TD]
[TD]PO complete[/TD]
[/TR]
[TR]
[TD]KCN-009[/TD]
[TD]10/11/2018[/TD]
[TD]95255[/TD]
[TD]TABBA[/TD]
[TD]#VALUE![/TD]
[TD]INT[/TD]
[TD]Baloon[/TD]
[TD]4000[/TD]
[TD]2000[/TD]
[TD]900[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-010[/TD]
[TD]10/11/2018[/TD]
[TD]95255[/TD]
[TD]TABBA[/TD]
[TD]#VALUE![/TD]
[TD]INT[/TD]
[TD]Baloon[/TD]
[TD]4000[/TD]
[TD]900[/TD]
[TD]0[/TD]
[TD]PO complete[/TD]
[/TR]
</tbody>[/TABLE]

 

[majidsiddique]

hi,
can anybody tell me any idea to solve this?
if you more clarification on it please tell me.
thanks.

 

[majidsiddique]

hi,
i add a new colume on it smallest value of PO qty apply this
=SMALL(IF((D3=$D$3:$D$12)*(E3=$E$3:$E$12),$J$3:$J$12,""),ROW($A$1:$A$1)) in K3
it works but there is a problem,

balance qty of j3 1400 can be copied in h6 then apply j6=h6-i6 result should be 500. i use it manually 1400-900=500. actullay 500 balance then goto h10 minus 500 supply more then it will become a zero and PO qty zero show every cell. PO status is maintaining manually.

i apply it only one PO:
NICVD and 95255
[TABLE="width: 770"]
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]PO No[/TD]
[TD]Hospital Name[/TD]
[TD]Item[/TD]
[TD]Description[/TD]
[TD]PO Qty[/TD]
[TD]Supply Qty[/TD]
[TD]Balance[/TD]
[TD]smallest Value PO[/TD]
[TD]PO Status[/TD]
[/TR]
[TR]
[TD]01/11/2018[/TD]
[TD]95255[/TD]
[TD]NICVD[/TD]
[TD]RINT[/TD]
[TD]Resolute[/TD]
[TD="align: left"]

1500

<tbody>
</tbody>

[/TD]
[TD]100[/TD]
[TD]1400[/TD]
[TD]0[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]02/11/2018[/TD]
[TD]62500[/TD]
[TD]TABBA[/TD]
[TD]INT[/TD]
[TD]Baloon[/TD]
[TD]4000[/TD]
[TD]200[/TD]
[TD]3800[/TD]
[TD]3000[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]04/11/2018[/TD]
[TD]62500[/TD]
[TD]TABBA[/TD]
[TD]INT[/TD]
[TD]Baloon[/TD]
[TD]4000[/TD]
[TD]1000[/TD]
[TD]3000[/TD]
[TD]3000[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]05/11/2018[/TD]
[TD]95255[/TD]
[TD]NICVD[/TD]
[TD]RINT[/TD]
[TD]Resolute[/TD]
[TD]1500[/TD]
[TD]900[/TD]
[TD]500[/TD]
[TD]0[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]05/11/2018[/TD]
[TD]70001[/TD]
[TD]NICVD[/TD]
[TD]NCEUP[/TD]
[TD]Surgery[/TD]
[TD]5000[/TD]
[TD]2000[/TD]
[TD]3000[/TD]
[TD]3000[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]06/11/2018[/TD]
[TD]95255[/TD]
[TD]TABBA[/TD]
[TD]INT[/TD]
[TD]Resolute[/TD]
[TD]4000[/TD]
[TD]3000[/TD]
[TD]1000[/TD]
[TD]1000[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]07/11/2018[/TD]
[TD]95255[/TD]
[TD]TABBA[/TD]
[TD]INT[/TD]
[TD]Baloon[/TD]
[TD]4000[/TD]
[TD]500[/TD]
[TD]3500[/TD]
[TD]1000[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]09/11/2018[/TD]
[TD]95255[/TD]
[TD]NICVD[/TD]
[TD]RINT[/TD]
[TD]Resolute[/TD]
[TD]1500[/TD]
[TD]500[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]PO complete[/TD]
[/TR]
[TR]
[TD]10/11/2018[/TD]
[TD]95255[/TD]
[TD]TABBA[/TD]
[TD]INT[/TD]
[TD]Baloon[/TD]
[TD]4000[/TD]
[TD]200[/TD]
[TD]3800[/TD]
[TD]1000[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]10/11/2018[/TD]
[TD]95255[/TD]
[TD]TABBA[/TD]
[TD]INT[/TD]
[TD]Baloon[/TD]
[TD]4000[/TD]
[TD]200[/TD]
[TD]3600[/TD]
[TD]1000[/TD]
[TD]PO partial[/TD]
[/TR]
</tbody>[/TABLE]

 

[majidsiddique]

kindly give me any suggestion to solve this. i am waiting

 

[majidsiddique]

Hi all,
kindly help me to solve this. i am continuous trying.
i use H6:
=LARGE(IF((D6=$D$3:$D$12)*(E6=$E$3:$E$12),J3:J5,""),ROWS($A$1:$A$1))
i got the result Large value matching criteria 1400
but use in H10:
=LARGE(IF((D10=$D$3:$D$12)*(E10=$E$3:$E$12),J3:J9,""),ROWS($A$1:$A$1))
result found again 1400 but i need 400 because j3=h10-i10 result 400.
i use it BUT failed:
=LARGE(IF((D10=$D$3:$D$12)*(E10=$E$3:$E$12),J3:J9,""),ROWS($A$1:$A$1))-small(IF((D10=$D$3:$D$12)*(E10=$E$3:$E$12),J3:J9,""),ROWS($A$1:$A$1)

after this found the smallest value of k3 to k12 match criteria.
where i use
=SMALL(IF((D3=$D$3:$D$12)*(E3=$E$3:$E$12),$J$3:$J$12,""),ROW($A$1:$A$1)) with array and found smallest value of PO
it will be ZERO at J10=h10-i10

[TABLE="width: 829"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Dec.No[/TD]
[TD]Date[/TD]
[TD]PO No[/TD]
[TD]Hospital Name[/TD]
[TD]Item[/TD]
[TD]Description[/TD]
[TD]PO Qty[/TD]
[TD]Supply Qty[/TD]
[TD]Balance[/TD]
[TD]smallest Value PO[/TD]
[TD]PO Status[/TD]
[/TR]
[TR]
[TD]KCN-001[/TD]
[TD]01/11/2018[/TD]
[TD]95255[/TD]
[TD]NICVD[/TD]
[TD]RINT[/TD]
[TD]Resolute[/TD]
[TD]1500[/TD]
[TD]100[/TD]
[TD]1400[/TD]
[TD]400[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-002[/TD]
[TD]02/11/2018[/TD]
[TD]62500[/TD]
[TD]TABBA[/TD]
[TD]ONYX[/TD]
[TD]Baloon[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-003[/TD]
[TD]04/11/2018[/TD]
[TD]62500[/TD]
[TD]TABBA[/TD]
[TD]ONYX[/TD]
[TD]Baloon[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-004[/TD]
[TD]05/11/2018[/TD]
[TD]95255[/TD]
[TD]NICVD[/TD]
[TD]RINT[/TD]
[TD]Resolute[/TD]
[TD]1400[/TD]
[TD]1000[/TD]
[TD]400[/TD]
[TD]400[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-005[/TD]
[TD]05/11/2018[/TD]
[TD]62500[/TD]
[TD]TABBA[/TD]
[TD]ONYX[/TD]
[TD]Surgery[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-006[/TD]
[TD]06/11/2018[/TD]
[TD]62500[/TD]
[TD]TABBA[/TD]
[TD]ONYX[/TD]
[TD]Resolute[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-007[/TD]
[TD]07/11/2018[/TD]
[TD]62500[/TD]
[TD]TABBA[/TD]
[TD]ONYX[/TD]
[TD]Baloon[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-008[/TD]
[TD]09/11/2018[/TD]
[TD]95255[/TD]
[TD]NICVD[/TD]
[TD]ONYX[/TD]
[TD]Resolute[/TD]
[TD]1400[/TD]
[TD]400[/TD]
[TD]1000[/TD]
[TD]400[/TD]
[TD]PO complete[/TD]
[/TR]
[TR]
[TD]KCN-009[/TD]
[TD]10/11/2018[/TD]
[TD]62500[/TD]
[TD]TABBA[/TD]
[TD]ONYX[/TD]
[TD]Baloon[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-010[/TD]
[TD]10/11/2018[/TD]
[TD]62500[/TD]
[TD]TABBA[/TD]
[TD]ONYX[/TD]
[TD]Baloon[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]PO complete[/TD]
[/TR]
</tbody>[/TABLE]

 

[majidsiddique]

Dear James006:
i use your formula mention in carry forword balance.
=INDEX($J$3:$J$12,MATCH(D9&E9,$D$3:$D$12&$E$3:$E$12,0)) with array but not working same balance carry in below.
kindly help me.
[TABLE="width: 834"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Dec.No[/TD]
[TD]Date[/TD]
[TD]PO No[/TD]
[TD]Hospital Name[/TD]
[TD]Item[/TD]
[TD]Description[/TD]
[TD]PO Qty[/TD]
[TD]Supply Qty[/TD]
[TD]Balance[/TD]
[TD]smallest Value PO[/TD]
[TD]PO Status[/TD]
[/TR]
[TR]
[TD]KCN-001[/TD]
[TD]01/11/2018[/TD]
[TD]95255[/TD]
[TD]NICVD[/TD]
[TD]RINT[/TD]
[TD]Resolute[/TD]
[TD]1500[/TD]
[TD]100[/TD]
[TD]1400[/TD]
[TD]400[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-002[/TD]
[TD]02/11/2018[/TD]
[TD]62500[/TD]
[TD]TABBA[/TD]
[TD]ONYX[/TD]
[TD]Baloon[/TD]
[TD]4000[/TD]
[TD]200[/TD]
[TD]3800[/TD]
[TD]800[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-003[/TD]
[TD]04/11/2018[/TD]
[TD]62500[/TD]
[TD]TABBA[/TD]
[TD]ONYX[/TD]
[TD]Baloon[/TD]
[TD="align: right"]3800[/TD]
[TD]1000[/TD]
[TD]2800[/TD]
[TD]800[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-004[/TD]
[TD]05/11/2018[/TD]
[TD]95255[/TD]
[TD]NICVD[/TD]
[TD]RINT[/TD]
[TD]Resolute[/TD]
[TD="align: right"]1400[/TD]
[TD]1000[/TD]
[TD]400[/TD]
[TD]400[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-005[/TD]
[TD]05/11/2018[/TD]
[TD]62500[/TD]
[TD]TABBA[/TD]
[TD]ONYX[/TD]
[TD]Surgery[/TD]
[TD="align: right"]3800[/TD]
[TD]2000[/TD]
[TD]1800[/TD]
[TD]800[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-006[/TD]
[TD]06/11/2018[/TD]
[TD]62500[/TD]
[TD]TABBA[/TD]
[TD]ONYX[/TD]
[TD]Resolute[/TD]
[TD="align: right"]3800[/TD]
[TD]3000[/TD]
[TD]800[/TD]
[TD]800[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-007[/TD]
[TD]07/11/2018[/TD]
[TD]62500[/TD]
[TD]TABBA[/TD]
[TD]ONYX[/TD]
[TD]Baloon[/TD]
[TD="align: right"]3800[/TD]
[TD]500[/TD]
[TD]3300[/TD]
[TD]800[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-008[/TD]
[TD]09/11/2018[/TD]
[TD]95255[/TD]
[TD]NICVD[/TD]
[TD]ONYX[/TD]
[TD]Resolute[/TD]
[TD="align: right"]1400[/TD]
[TD]400[/TD]
[TD]1000[/TD]
[TD]400[/TD]
[TD]PO complete[/TD]
[/TR]
[TR]
[TD]KCN-009[/TD]
[TD]10/11/2018[/TD]
[TD]62500[/TD]
[TD]TABBA[/TD]
[TD]ONYX[/TD]
[TD]Baloon[/TD]
[TD="align: right"]3800[/TD]
[TD]200[/TD]
[TD]3600[/TD]
[TD]800[/TD]
[TD]PO Partial[/TD]
[/TR]
[TR]
[TD]KCN-010[/TD]
[TD]10/11/2018[/TD]
[TD]62500[/TD]
[TD]TABBA[/TD]
[TD]ONYX[/TD]
[TD]Baloon[/TD]
[TD="align: right"]3800[/TD]
[TD]200[/TD]
[TD]3600[/TD]
[TD]800[/TD]
[TD]PO complete[/TD]
[/TR]
</tbody>[/TABLE]

 

[majidsiddique]

hi all:
i am very surprised, no one is giving any comment o this.
Thanks