I have dataset like this:
PO# Position Sequence# POQTY Invoice# InvoiceQTY
123 1 1 100 10 50
123 1 1 100 11 50
I need the result like this, so the PO QTY won't be doubled even the PO was invoiced twice with half of the original quantity on each invoice.
PO# Position Sequence# POQTY Invoice# InvoiceQTY
123 1 1 100 10 50
123 1 1 0 11 50
Does anyone know how? Thanks a lot.
PO# Position Sequence# POQTY Invoice# InvoiceQTY
123 1 1 100 10 50
123 1 1 100 11 50
I need the result like this, so the PO QTY won't be doubled even the PO was invoiced twice with half of the original quantity on each invoice.
PO# Position Sequence# POQTY Invoice# InvoiceQTY
123 1 1 100 10 50
123 1 1 0 11 50
Does anyone know how? Thanks a lot.