I am working on something and stuck on a condition.
If anyone could help it would be a great help, Condition is
say there are columns named , “PO” ,“PC” “Vendor Number” rows of these contain duplicate values i.e same PO number, PC number and Vendor Number
one more column is “ageing” which contains age exampl. 89, 90, 92 etc
what i have to do is : Combine the duplicate Lines into ONE by adding the Amount of two or more similar lines by following logic, :
1. Apply For Duplicate PO and PC (Same in all the lines) and having the same vendor numbers .
2. The merging of amount can be done with in item having the oldest Ageing.
It would be great help if someone can guide. Please feel free to ask any questions.