Hi everyone and thank you in advance for your help. Is there a way in NetSuite in a list of vendor bills to show what is paid in full because a credit memo has been applied? Like a single field or a trick that is not requiring to show applied to link transactions resulting in multiplications of data.

just thinking on top of my head, you'd need to use the applied to/applied from in the saved search, if you fiddle with that you'd get what you need

Of course that will show the info. But there are several cases in where this will multiply results. And if the goal is showing a YES / NO in a list that will be tricky. It's incredible that when finance want to understand which vendor bills have been closed with a credit and not a payment they have to manually open case by case. Almost incredible

I assume you guys mean you do partial credits? or do your credits apply to the bill fully?

sounds like you want a script or scheduled workflow to update the bill if it was paid in full by a CM and set some body level checkbox. That way you can search off of it.

Found a good way in saved search with complex formula. What they want is just to have a NO YES in a list of a vendor credit has been applied to a vendor bill so that together with the status they can easily understand the case in the list

using the applying or applied to transaction?

The reason is that sometime approvers are calling finance asking why they paid a vendor bill that was not approved for payment since they where waiting for a vendor sending a credit note. In both cases the status is paid in full so this is creating confusion