Skip to Content
0
Dec 07, 2011 at 02:41 AM

Remove duplicated entry under certain condition

24 Views

Good day!

I have this report that displays Journal Entry Numbers and their corresponding Outgoing Payments Numbers (if they have). Tables involved are OVPM and OJDT. The problem is, there's this one Journal Entry number that two Outgoing Payments points at. One of the Outgoing Payments' Remarks is labeled 'Cancelled'. On the report, I wanted to remove the OVPM that has a Cancelled remark. Thank you.