In our retail subsidiary, Wayfair is a customer. We issue a lot of invoices to them (although the items are shipped to the end consumers). The struggle is that they pay in bulk for multiple invoices ranging from 20 to 100. It is quite inconvenient to trace it in NS or do a CSV import. Is there a third-party solution for the customer payments or bundle or SuiteApp?

Have you looked at Invoice Grouping? Not sure if you significantly reduced the total count of invoices if this would help? Not sure if they require an invoice per transaction. If so, might want to consider EDI for invoices/payment.

Hi @Luis, I have three suggestions for you, unfortunately none are particularly cheap or easy. First, setup a NetSuite integrated EDI connection with Wayfair and ask them to send you an 820 Remittance Advice. If EDI integration is not a skill you have in house, the I recommend going with an established NetSuite EDI integrator like SPS Commerce. Second, use an integration PaaS, like Celigo or Boomi, to create an API connection between Wayfair and your NetSuite account (not sure if Wayfair supports remittance via API). Third, if you are receiving remittance files from Wayfair in a standard and consistent format, like JSON, CSV, XML, or some other flat file, then any reasonably experienced NetSuite developer should be able to script importing the Wayfair payment file when uploaded to specified location in your file cabinet. In closing, don’t forget to ask you NetSuite account exec if she or he has any ideas. Sorry it’s not a simple answer, good luck!

Thanks everyone. Appreciate it. Will look into them.

@Cameron can we build EDI AS2 integration with core netsuite suitescript modules? Can we transfer data to AS2 EDI system?

With only the core, I don’t think so. You need some kind of PaaS like Boomi, Celigo, or B2B Gateway to handle the AS2 communication. However, I do believe you can do an SFTP connection using public key authentication, but I’ve never done that personally. There may be a 3rd party app/bundle that will do the AS2 transport, but I’m sorry I can’t think of any. If you’re interested in doing the SFTP connection, here’s a SuiteAnswer to get you started. https://netsuite.custhelp.com/app/answers/detail/a_id/61948/

@Cameron Got it.. Thank you very much 😊