I don't think there can be an answer to your question. Consider this data...
|
A |
B |
1 |
Remain
amount |
Supplier |
2 |
25 |
A |
3 |
75 |
A |
4 |
50 |
A |
5 |
50 |
A |
6 |
25 |
A |
7 |
-125 |
A |
Anyone of the following would meet your conditions; how would we know which one is correct?
|
D |
E |
F |
G |
H |
I |
J |
K |
1 |
Remain
amount |
Supplier |
|
Remain
amount |
Supplier |
|
Remain
amount |
Supplier |
2 |
25 |
A |
|
25 |
A |
|
25 |
A |
3 |
75 |
A |
|
75 |
A |
|
75 |
A |
4 |
50 |
A |
|
50 |
A |
|
50 |
A |
5 |
50 |
A |
|
50 |
A |
|
50 |
A |
6 |
25 |
A |
|
25 |
A |
|
25 |
A |
7 |
-125 |
A |
|
-125 |
A |
|
-125 |
A |
Is there anything tying the amounts together (like an Invoice Number or something)?
Bookmarks