How to query the customer balance

Business Central/NAV Technical Forum
1

Hello all:

I am using Microsoft Dynamics Nav 2009 running on a SQL Server 2005 database. I want to be able to create a query using the outstanding balance for the customer but I can’t identify the table in SQL that contains the balance field. The balance does appear, however, when you open the customer card in Nav.

Any assistance will be greatly appreciated.

2

Hi Windros,

You find the Balance field directly on the Customer table (18), but you cannot query directly using SQL Queries (if that’s what you want). The Balance field is a calculated field (Flow field) containing the total sum of the Amounts of the Detailed Customer Ledger Entries.

3

Hello Erik:

Thanks for your reply and the solution. I should be able to query the Detailed Customer Ledger Entries table and come up with the balance.

Windros