cUSTOMER CARD DOUBT

Business Central/NAV User Forum
1

hI,

I have a small doubt in The balance field of customer card.

All the entries of the customer are getting updated in the customer ledger entry table.

So my doubt is how these two tables are related with the particular Balance Field and where the code i9s written for this to happen .

Please explain me in detail

Thank u

2

Hi,

The Balance field is a flow field in NAV. Flow fields are not stored in tables, rather they are calculated on run-time.

For details:

Object Designer >> Table >> Customer (Table No.18) >> Balance (Field No.58) >> Shift+F4 (Properties)>>CalcFormula

Following is the relationship:

Sum(“Detailed Cust. Ledg. Entry”.Amount WHERE (Customer No.=FIELD(No.),Initial Entry Global Dim. 1=FIELD(Global Dimension 1 Filter),Initial Entry Global Dim. 2=FIELD(Global Dimension 2 Filter),Currency Code=FIELD(Currency Filter)))

Hope this helps. For more info about Flow Fields refer to documents on NAV.

3

Hi Veda,

I will suggest you to read up on Flowfields and SIFT…
This is very essential for NAV.

The Balance field is defined in the table-definition of the Customer table, as a field of fieldclass Flowfield.
In the property list of this field, you’ll find a property called CalcFormula.
This i where you define the relation to the CLE table.