0

when was this item last sold

Jet Reports Historic Posts

April 21, 2008 01:40

None

Follow

I'm looking to put together a reports. I have most of the info, but not sure if i have it right.

report that tells me any item that hasn't been sold in a specific period of time. (i think i can figure out, but would like some further suggestions if possible)

• Facebook
• Twitter
• LinkedIn

7 comments

• 0
  
  Jet Reports Historic Posts April 21, 2008 20:20

  I would suggest to take a look at the Sales (Qty) field on the Item table. This is a Flowfield which sums the sales invoiced quantity and has an option for a date filter.
  
  Maybe a formula like NL("Rows","Item",,"Date filter","StartPeriod..EndPeriod";"Sales (Qty.)";"0") will give you what you need.
  
  Let us know if this works for you, ok?

• 0
  
  Jet Reports Historic Posts April 22, 2008 00:26

  I haven't tried what you wrote, but i would have thought that using the item ledger entry fields and making it filter out any date not = to the dates given.. would my way be simpler?

• 0
  
  Jet Reports Historic Posts April 22, 2008 02:20

  Of course you can build a query on the Item ledger entry table, but it will take your report a bit longer to run I would say.
  
  But why don't you give both methods a try to see the difference?

• 0
  
  Jet Reports Historic Posts April 22, 2008 02:28

  I will see what i can put together tomorrow when i am in front of my pc instead of on vpn. lol thank you

• 0
  
  Jet Reports Historic Posts April 22, 2008 13:02

  haha I don't even see the Sales (Qty.) in the item table. I see it in the list in jet, but not physically on the item card.
  
  The sales (Qty.) is supposed to give a sum of all the sales for that particular item am i understanding that correctly?

• 0
  
  Jet Reports Historic Posts April 22, 2008 13:41

  It's on the Item turnover Form: Open Item card -> Select Item menu buttion -> Statistics -> Turnover. Use the Help on the Sales (Qty) field. Use the Drilldown on the Sales (Qty) field to get an idea of how this field is calculated by opening Table filter in the Item ledger entries form
  
  And if you have the Advanced designer installed you can see the CalcFormula in the Jet Designer.

• 0
  
  Jet Reports Historic Posts April 23, 2008 01:24

  I don't see that using the sales (qty.) way being the easiest or simplest way to do this..
  I gave it a try.. lol