0

Customer Balances

Jet Reports Historic Posts

January 21, 2008 18:14

None

Follow

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??

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts January 21, 2008 18:28

  I looked at one of my reports that give me the customer balance and we are using the "Net Change" field instead of the "Balance" field. This seems to work for us.
  
  So in your example, the formula would be =NF("REF","Net Change","Date Filter",NP("DateFilter",,B4))
  
  Does anyone know why "Balance" doesn't work, but "Net Change" does?

• 0
  
  Jet Reports Historic Posts January 22, 2008 16:04

  Net Change does not seem to work for me either?

• 0
  
  Jet Reports Historic Posts January 22, 2008 16:22

  Noël_L
  
  Here is a quick report that I wrote that has both the "Net Change" and "Balance" fields from the customer table. joejet is correct, "Net Change" should work.
  
  QuickCustBalVSNet.xls
  
  Change the date, run the report, and see if the Net Change is different than the Balance column.
• 0
  
  Jet Reports Historic Posts January 22, 2008 18:27

  Thanks, I got it working now!