vendor/customer balance

united77

Hi all, relatively new to the NAV world, can anyone help me with the following, I am trying to compare two databases to make sure that the vendors and customers balances match in both.
Is there a way of seeing a list or similar of all vendors with balance and all customers with balance?(if poss exported to excel) :?:
I am comparing 2013 with 2013 R2

Many thanks

Lisa

PanzeriElena

You can add "balance (LCY)" field in customer list page (and in vendor list page)...
In this way, you can export in Excel only the information you need.

Elena

ssingla

Or probably "Net Change" field with appropriate posting date filter.