Has anyone worked on Vendor statemnt, similar to Customer statement...

I'm curious what is the business use case here. Shouldn't the vendors be the ones to send you the statement?

Also wondering about this. When would you need to send your suppliers a list of what you owe them? I'm sure they'd prefer you just pay them...

it is part of auditing process... don't care about why the auditor ask for that. Request is : send statement to supplier and ask to return it signed

That's a very odd audit request as it's not part of a normal business process.

from the business point of view, I agree that no make a sense

I'd push back on that request or simply answer no.

if it's a one-off request for an auditor, i'm wondering why an AP Aging report by vendor wouldn't suffice?

thank you guys for the comments. We are not discuss is it odd or not... The client ask to me to avoiding manual creating word documents, creating PDFs, sending to the suppliers...I am not complaining on NetSuite 😂... If you experienced something like this request, I will appreciate...

I guess I'd either make a script to print what you want, or use a custom saved search / advanced PDF combo

I would go for @al3xicon’s route. My question is in standard p2p process you issue PO to your vendor and vendor fulfills it then bill you, PO act as a binding contract, why not use this route?

Thanks @Sam-I-Am for your intention to help, but you still miss the point. This is not a topic about customer-supplier relationship... Here, in my country the legislative related to auditing process, ask an enterprise company to provide confirmed and signed statements both for customer and suppliers... Why? I don't care. My client is obligated to do that... They are disappointed, but no one them ask if they want to do that. They need to do provide that. Small and middle size companies are not obligated to provide confirmed and signed statemens. ... that's the theory... So, just imagine that you have a hundreds even thousands suppliers... The one option is sending all of them email with blablabla please send us financial statement with our balance at your books... or... prepare PDF documents (as we do for customer's statement), send to all suppliers and ask for response with agreement about balance. Now, my client use AP report, export the results in excel, manually create the documents, save them in PDF format and manually send email with attached statement... And they have very very simlle question for me : Could you help us and automate the whole process? What I should answer to them? You are stupid, our law is stupid, use PO from NetSuite??? Here, I asked very short question : Does anyone know shortcut to create solution? I know that NetSuite has many options for generating Customer statements... but have never met before for Vendors... Maybe I missed something... Now, I will response to my client :, there is no native NetSuite solution, we must create our tailored one. Thank you all NstSuiters for ideas and comments

@Zoran R-DATAGRAM how sophisticated does the statement need to be? I would suggest you test the following in SB: a) Create a Saved Search of all Open Vendor Bills. b)Add the columns you want to have c) Customise the email you want d) Use Send to Recipient e) Tick SUMMARIZE SCHEDULED EMAILS f) Schedule a send g) This method will give the vendor a list to accept but wont get a total onto the summary The other solution is a map/reduce script that identifies vendors with open balances, then for each of those run another search to include the open Bills.

Hi @Netsuite Tragic thank you for your reply!!! That's what I want to see here in Slack... ideas 😂

this is a standard auditors’ request, they are comparing what business has as an outstanding balance vs what vendor has. I would just create a saved search/analytic wb looking similarly to the customer statement (i.e. dates, product, amount as minimum, rest is business specific)

@Karina thank you for confirming it's a regular audit request... It is not problem for me to realize a solution, I just wonder if there a out-of-box solution (feature to enable, bundke to install...).