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 build "Prepayments from vendors" Report
Hi team,
I hope you are doing well.
I have a question:
I would like to build a report detailing the composition of the Vendor Prepayment account per period grouped by vendors.
The goal is that the report will only show bills that have been paid and have not yet had a bill credit.
If possible - to have the possibility to present the report at the level of each of the Subsidiaries and Consolidated as well as by choice of Primary / Local currency books.
For example, filter the data to June and see a bill from April that is paid in full and without applying for bill credit, even though there was a Bill credit created in August. If I would look at the same bill and filter it to August, I will not see the bill as this account is balanced for this transaction.