0

Customer Balances

I am using Navision and I want to pull up customer balances as at a specific date.

I use the NL("Rows","Customer") to initiate each line then create the following cells NF("REF","Name") NF("REF",No.") (where REF is the cell referece to my NL function)

inthe cell in which I want to show the balance at I have entered =NF("REF","Balance","Date Filter",NP("DateFilter",,B4) (where cell B4 is the cell where I entered the specific date for which I want the customer balance)
I have confirmed that "Balance" is indeed a flowfield in the customer table.

What am I missing??

4 comments

Please sign in to leave a comment.