Hello,
I have a requirement on a report to include comments on 2 different intersections of the same record but I'm struggling to get both comments captured properly when sending them in at the same time. Here is an example:
The report pulls data for actuals and budget for current month and YTD. Users want to be able to enter separate comments for the current month variance and comments on the YTD variance. I inserted 2 columns to capture the 2 different comments, using EVCOM. However if users enter comments in both columns, and when they send the data in, only comments on one column is captured. If they enter comments on one column, send that one in then enter commnets on the other column then send those in, the comments are captured properly. Has anyone run across this scenario before and what is the best way to go about so we can enter commnets on both columns and send them in at the same time.
Thanks,
David