0

Customer Item Sales - Navison

Jet Reports Historic Posts

August 14, 2008 00:00

None

Follow

Customer Item Sales - Navison, Anyone have idea how to show summaray of items sold for customer price groups from Microsoft Naviaion

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts August 14, 2008 09:08

  Your question is a little cryptic, but I think you could advance using these functions:
  
  first, you need a simple grouping of the Customer Price Group (CPG), ex cell D4:
  
  =NL("Rows=2";"Customer";"Customer Price Group")* note: this is on the customer table, it could be more intresting on the order table (only lists used CPG's)
  
  After that you just need all items sold to the CPG in D4, so this is D5:
  =NL("Rows";"Sales Line";"No.";"Customer Price Group";"@@"&D4)
  You have a grouping by CPG, with all items sold by CPG.
  Thereafter, you can use ordernrs & items as a filter to filter on the item ledger entry table for example (for totals, quantity's).
  
  Another intresting one (and rather easy to built) could be to have the items in rows and the CPG in columns.
  If you request more info, let us know.