Skip to Content
0
Former Member
May 01, 2018 at 01:42 PM

Formatted searches and queries

104 Views Last edit May 02, 2018 at 07:26 AM 2 rev

Hi,

Created 2 formatted searches that update 2 udfs on the BP Master Data with the latest payment date and amount and visually I can see both fields are populated on screen. However, when I run a query on the table OCRD and include the 2 udfs, values returned are Null, unless I make a change to the BP and press update.

Is there a way of being able to report via query manager on the 2 udfs without having to update all BP records?

Thanks,

Jon