0

Virtual Column no longer working

Ted 3 weeks ago in Home Portal updated by mark 2 weeks ago 7

Hi all,

When we started using XTRF we created a virtual column to give us a vendor's paypal email address. (Here's our original post about it where my colleague Mark Bishop shared the code.). We noticed today that the data for that field isn't showing up in our vendor invoice views. (We just get a column of dashes)

 Has this happened for anybody else with a virtual column?

+1

Hi,

Ours is still working (XTRF v8.9.7).

+1

So odd. We're still on 8.8.4. I wonder if something broke and got fixed between versions? And just to confirm, the code we're using is:

#if(!$unwrappedThis.getDefaultPaymentMethod().getCustomFields().get("Owner email"))
#else
$unwrappedThis.getDefaultPaymentMethod().getCustomFields().get("Owner email")
#end

+1

Exactly. Did you check that they have selected Paypal as the Payment Method for this specific invoice?

+1

Just checked... these all have Payapal selected on these invoices. I'm so confused. 

We even tried re-enabling Paypal as the vendor's payment method just to see if that would make a difference...

Did you try to troubleshoot with something like:
#if(!$unwrappedThis.getDefaultPaymentMethod().getCustomFields().get("Owner email"))
N/A 
#else
$unwrappedThis.getDefaultPaymentMethod().getCustomFields().get("Owner email")
#end

Just to make sure you are getting results?

I would then try and check if the issue is the default payment method (e.g. if for some reason it has changed from PayPal to something different).

Finally, I guess another way to do this would be to change the code and instead get the list of payment methods, go through the list and check if PayPal is there to get the email (so it wouldn't have to be both the default payment method).

Thanks Alexandros. I appreciate that idea! It helped us pinpoint the issue. 


Turns out we've been adding payment types as we transition all our international payment to Tipalti. The vendors whose emails aren't showing up are the ones we transitioned to Tipalti and we no longer have them marked as PayPal with the default payment. So now we know what to do with this report and how to address it. Thanks for the help thinking this through!

Mark