0

Vendor balance at date

Jet Reports Historic Posts

March 02, 2015 18:36

None

Follow

Hello Niallc,

I usually try to go to the master table for these. You can use the NAV FlowField "Balance on Date (LCY)" and apply the Date Filter. Your function could look something like this:

=NL("First","Vendor","Balance on Date ($)","No.",E3,"Date Filter","2/3/15","Company=",G2)

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts March 02, 2015 18:36

  Hi all
  
  Is this formula my best bet for a vendor balance at date?
  
  it works, but is there something more efficient?
  
  trying to build an inter co matrix
  
  =NL("sum","Detailed Vendor Ledg. Entry","Amount (LCY)","Vendor No.",E3,"Posting Date","010110..311214","Company=",G2)

• 0
  
  Jet Reports Historic Posts March 17, 2015 14:03

  thanks for your response,
  
  Im not familiar yet with flow fields,
  
  do i have to create one, or should i have balance at date in my options when looking at the vendor table, i dont see it?

• 0
  
  Jet Reports Historic Posts March 17, 2015 15:33

  Hi Niallc
  
  Are you located outside the US? It looks like, according to Microsoft, this is a standard field noted as "United States Local Functionality" so perhaps if you located outside the US, you don't have this field. https://msdn.microsoft.com/en-us/library/hh176657%28v=nav.71%29.aspx

• 0
  
  Jet Reports Historic Posts March 26, 2015 12:41

  yes im in europe,
  
  i think i have found the solution now
  
  thanks again