0

Top Vendor List, filtered by Item Posting Group

Jet Reports Historic Posts

February 10, 2011 23:46

None

Follow

Using NAv 2009 RTC, Jet version 2009.

Been trying to get a report to show me my top 25 vendors by purchases, but filtered by the item posting group field on the item card. ( I want this so I can see my top vendor by different item categories)

So far, the report takes 20 minutes to run.

Has anyone done this before ??

• Facebook
• Twitter
• LinkedIn

5 comments

• 0
  
  Jet Reports Historic Posts February 11, 2011 13:06

  are you refering to filters on a different sheet?
  
  I was able to speed up reports using where filters are located on a options sheet by applying delay function within the filter, some reports from +45 min run now in 15 min

• 0
  
  Jet Reports Historic Posts February 11, 2011 13:20

  no, not filters on a different sheet.
  
  Just a vendor top 25 list, but being able to filter by inventory posting group.

• 0
  
  Jet Reports Historic Posts February 11, 2011 16:40

  I'd say it depends on how you're filtering by it. Can you either attach the report or describe the structure? Are you using NL(Filter) or Link=? What is the structure of the replicators, etc.?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts February 11, 2011 17:15

  Here is what I have so far.
  Take a look and see what you think.

  • Top Vendor filter by inv post. group.xlsx
• 0
  
  Jet Reports Historic Posts February 12, 2011 00:56

  Have you tried replicating vendor numbers from the Vendor table rather than from the purchase invoice line? You might try something like this:
  
  =NL("Rows","Vendor","No.","Link=","Purch. Inv. Line","Buy-from Vendor No.","=No.","Posting Date",$C$2,"-Amount Including Tax","*","Limit=",25,"Link=","Item","No.","=No.","Inventory Posting Group",$C$3)
  Regards,
  Hughes