0

Last Purchase Price

Jet Reports Historic Posts

January 26, 2010 05:27

None

Follow

Hi,

Is there a way to filter to show the last purchase price of the item, instead of showing every purchases.


Field that i have

Item | Posting Date | Unit Cost

Thanks in advance.

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts January 26, 2010 07:39

  NL("First","THE TABLE","Unit Cost","Item","YOUR ITEM","-Posting Date";"*")
  
  OR
  
  NL("Last","THE TABLE","Unit Cost","Item","YOUR ITEM","+Posting Date";"*")
  
  but is personally think that the first is faster cause it queries the in reverse order and then takes the first record instead of getting the whole set and then picking the last record.
  
  Maybe someone from JetReports can give an definite answer to this….

• 0
  
  Jet Reports Historic Posts January 27, 2010 04:31

  Thanks for your help :)

• 0
  
  Jet Reports Historic Posts January 27, 2010 15:15

  =NL("Last","Purchase Line","Amount","Amount",">0","Quantity",">0","Document Type","Order","Type","Item","Order Date","01/26/2010")
  
  I just tried testing it with the yesterdays' date. You should be able to leave it blank. If you consistently create the purchase order then it will be hard to track. The better way is to filter it with last business days date. Let me know if you have any questions.
  
  Thanks,