How to query the customer balance

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.

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.

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.