Adrian, this actually worked very well. Thanks for the help and the .INA file.
------------------------------
Mike Spalding
Abbvie Inc.
------------------------------
Original Message:
Sent: 08-17-2023 07:22
From: Adrian Williams
Subject: Highlight Expense Amount if Negative Match Found
I used a similar approach to the solution described by 'Soporte LAE'.
However, as the data type of the expense amounts is double (i.e. floating point numbers) this may cause issues with matching some amounts due to the minor rounding errors that are inherent in floating point numbers. Best practice would be to convert the monetary amount to cents with an integer data type and use that for the matching. I matched on the cents amount and the inverse cents amount - meaning that only one join was required. The joined data was then sorted by the source and the absolute cents amount. See the attached zip file containing the .lna file
------------------------------
Adrian Williams
Precisely Software Inc.
Original Message:
Sent: 08-16-2023 11:47
From: Mike Spalding
Subject: Highlight Expense Amount if Negative Match Found
Hello,
I have a data set where I have positive expense amounts and negative expense amounts. I'd like to find a way to sort by the source ID and then look for a possible match. If found, mark the matching negative/positive so I can than research and adjust, if needed.
Can D360 be used to sort the data by the source and then look for the "equal" negative/positive and then mark those two transactions so I can look and confirm the adjustment?
The attachment is a sample of the data I'm looking to adjust.
------------------------------
Mike Spalding
Abbvie Inc.
------------------------------