Hi all, we have an issue with NetSuite's electronic payment remittance not pulling through bills that have a credit fully applied to it during the payment run. Scenario: Bill A $100 Bill B $200 Credit Y of $150 Net Due to Vendor: $50 The PDF will show Bill C of $50 being paid. However we need to show our vendors the full story that during the run we applied the $150 credit to Bill A for $100 and partially applied to Bill B for $50. Leaving the $50 balance. We can get the Credits to pull through to the remittance as they are connected to the Bill Payment record. However Bill A is not deemed to be connected to the Bill Payment record and thus cannot be billed through. Any help would be much appreciated.

There is no native connection between Bill A and Payment C that you can use. This is not due to NetSuite's EBP, the data structure would be identical if you applied the credit and made payment through the Pay Bills page or manually. You could probably get a script written to use the Payment File Administration to relate them, but that seems like a lot of cost for the benefit. Can you instead pull an AP payment history report or a saved search that shows AP transactions and share that with the vendor as backup?

Hi @Catherine Fray thanks for the reply. Sorry for the slow response on my side. We've suggested that, however the client vendor's need to understand what each payment relates to in terms of bills and credits so they can reconcile it on their side. As you said, its difficult to relate the bills and credits to the payment file. Particularly because bills that getting 100% paid off by a credit then aren't even connected to the payment record.