Is there a way to get the list of vendor credits a...
# administration
n
Is there a way to get the list of vendor credits applied on the vendor payment?
s
try doing a search using applying transaction or applied to transaction (don't recall which one exactly - it's bit confusing, still I need to look up the applying and applied to table from the suiteanswers every time 🙂 )
n
I have done that but it only gives me the vendor bills the payment is applied to using Applied To Transaction column. Nothing comes in Applying Transaction column.
s
try fiddling with criteria join applying/applied trans type or applying/applied link type. I have done that for one of the companies I have worked for in the past.
a
i've had to solve this by leveraging the advanced pdf templates, pulling from that list and storing as JSON in a custom field on the payment record using a script
👍 1
n
Thanks @al3xicon. Yes, PDF can print the list without any problems.
a
I've spent hours trying to get the same proper list via a saved search, to no avail sadly
n
Did you render the transaction as string and then parse the XML? @al3xicon
a
Yep basically
In a UE script
n
Ok, thanks.
@al3xicon I have had no luck so far to get it from the PDF. Render as string doesn't return the lines. Render as PDF returns encoded string. Any suggestion is appreciated.