Discussions
SuiteWorld is the largest annual gathering of the NetSuite community! It will be held in Las Vegas on October 6-9, 2025. Our customers and partners look forward to SuiteWorld every year as a place to hear the latest from NetSuite, get hands-on learning, and connect with each other. Register now!
How to include Journal in Purchases By Vendor Report?
Hello Community,
Curious if anyone else has run into this and/or has a solution. I ran a Purchases By Vendor report and realized that Journal Entries were not included (I was looking at a particular vendor that I do not necessarily create Bills for, but know we have expense recorded through JEs). I also included the vendor name in the JEs as part of the line item detail (so the JEs show up in the View All Transactions section of the vendor record).
I figured out how to add Journals as a record type to my Purchases By Vendor report by clicking on Customize and Filters. So I expected to see different expense numbers thanks to my Entity Name entries in my JE line items. Alas, all the journal entry expenses showed up in the Unassigned vendor. Does the entity name field in the JE line item not populate all areas of vendor activity? I.E. Putting Amazon in the Entity Name field got the JE to the View All Transaction section of the Amazon vendor record, but it does not affect the Purchases