Forum Discussion
hi
hi
I have a sales table where i have value sold and return. When sold invoice number is normal a number but when return then there is CR at beginning and CR or return invoice number is not sam...
I think we made a mistaked
| 221104 | 120 |
| CR999999 | -120 |
not always be together. invoice number and corrorpondance invoice CR could be in different place, could be after fifteen thousand or tweenty thousand rows. could be anywhere in same table.
in that case - 1 is not right.
we could say when CR Nat Amount matches with invoice Net Amount and in same invoice date (I didnt mention it in my example table but you can create it in yours) then make CR Nat Amount and Net Amount of them 0
data is something like this its over 3 milions of data with invoice and CR Net amount and Invoice Date
could you tell me how i can i make ) when CR is full refunede. if thats the thing is hard to do
thanks