Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
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