0

Consolidate Function - Jet report

Jet Reports Historic Posts

January 28, 2017 10:07

None

Follow

Hi,

I am new to NAV & Jet, need some help in reporting so here it goes.

I'm creating a stock valuation report using data table value entries =NL("Rows","Value Entry",,,,"Company=","Limited","Item No.",option!$C$5) as there are 100'thousand lines (which can take hours to run) I wish to consolidate the item no. & only see it once with total cost amount actual. Please could anyone guide as as how can i do this. Thanks

attached sample file.

regards,
Accountant

• Stock Valuation Value Entries Test Ltd only 2.xlsx

• Facebook
• Twitter
• LinkedIn

3 comments

• 
  Jet Reports Historic Posts January 30, 2017 15:08 Official comment

  Something like this, perhaps?
  
  
• 0
  
  Jet Reports Historic Posts January 28, 2017 10:21

  Hi ,
  
  I am new to forum and only started using jet few month ago. Wonder if anyone could help so here it goes
  
  I'm building a inventory valuation report using NL("Rows","Value Entry",,,,"Company=","Limited","Item No.",option!$C$5) but it takes hours to run due to thousands of lines what i want to be able to do is sum by each item number and get actual cost total. I have attached the xl sheet
  
  Thanks

  • Stock Valuation Value Entries Test Ltd only 2.xlsx
• 0
  
  Jet Reports Historic Posts March 29, 2017 22:47

  Thank you that worked