[esmeralda]

Does anyone know how i can generate a list of vendors who are also customers with the total A/P and the total A/R balances?

i need this in order to make journal entries at month end closing.

I have sofar:

vendor search with criteria

“other relationships any of customer”

but have some trouble specifying the results.

thanks

Esmeralda
This is a cached copy. Click here to see the original post.

[ecacho]

Please try the steps below:

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

[Author]

Posts