Vendor statement

Vendor Statement is similar to that of a Customer Statement. It lists vendor transactions which include BillsBill CreditsBill Payments, and Journals. Unlike customer statements, vendor statements are not yet available in NetSuite. As a workaround, we can customize A/P Register to show all vendor transactions as of a specified time for a specific vendor. To do the same, perform the following:

  1. Navigate to Reports > Vendors/Payables > A/P Register
  2. Click Customize
  3. Click Filters
  4. Expand Vendor Register Transactions folder
  5. Choose Vendor (Line)
  6. Click Filter
  7. Select Equal to
  8. Click Select Multiple button
  9. Choose the Name of the vendor
  10. Check the Show in Footer box
  11. Click Done
  12. Click Done again
  13. Click Preview
  14. To save the report:
  15. Click Return to Customization
  16. Enter a Report Name
  17. Click Save : With the Show in Footer functionality, there is no need to change the filter each time the report is generated for another vendor. While viewing the report, the vendor name can be changed in the footer filter.

Leave a comment

Your email address will not be published. Required fields are marked *