Create a Transaction Saved Search to Display the Receivable and Payable Balances for Polymorphic Records (Records of Customers which are also Vendors)

Problem/Business Requirement/Unique Question:

User need a report or saved search to display both the payable and receivable balances of their customers which are their vendors at the same time so that they could easily track how to offset both balances.

 

Symptoms/Details of Business Requirements/Any Additional Information:

Create a Transaction Saved Search to Display the Receivable and Payable Balances for Polymorphic Records (Records of Customers which are also Vendors)

Solution/Workaround/Gotcha/Recommendation Details:

1. Navigate to Reports > Saved Searches > All Saved Searches > New

2. Select the Search Type = Transaction

3. Enter the Search Title for this saved search

4. Under Criteria tab > Standard subtab, add the following fields:

   -- Account = choose the Accounts Payable or Accounts Receivable accounts

   -- Customer (Main Line) fields… > choose Other Relationships = Vendor

5. Under Results tab > Columns subtab, the following fields are required to be added:

   -- Customer (Main Line) fields… > choose Balance

        --- Summary Type = Group

        --- User may want to add a custom label to differentiate this column as the Customer Balance column

   -- Vendor fields > choose Balance

        --- Summary Type = Group

        --- User may want to add a custom label to differentiate this column as the Vendor Balance column

   -- Name

        --- Summary Type = Group

   -- Amount

        --- Summary Type = Sum

6. Save and Run the search and verify the accuracy of the result