0

Report not pulling info for vendor client that has duplicate

Jet Reports Historic Posts

February 08, 2017 16:43

None

Follow

Hello -

I have two questions:

1) If you drill down on the result of the NL(Sum) function, what records are displayed?

2) If you go into NAV (specficially to the Lot Control table) filter by the Vendor No. and Vendor Client No., and then sum up the Product Revenue field do you get a different value than your NL(Sum) function? Are different records displayed than in the the drilldown?

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts February 08, 2017 16:43

  I am trying to pull information on vendor clients through Nav. the report shows sales by vendor client, but we have recently come across the issue where some of our vendor clients have become vendors. Now there are 2 vendors with the same vendor client and the report is only pulling the one that was created first.
  My formula to find the product revenue by vendor client is:
  
  =NL("Sum","Lot Control","Product Revenue","Purchaser Code","@@"&$D13,"Vendor No.","@@"&$H13,"Vendor Client No.","@@"&$J13,"Date Filter",$C$3)
  
  Any help would be great!

• 0
  
  Jet Reports Historic Posts February 08, 2017 20:18

  I am not able to drill down. It gives me an error.
  
  But the issue i am having is that it is not giving me the product revenue for the new vendor at all. It is only showing $0 for the old vendor.