Skip to Content
Aug 20, 2015 at 09:19 AM

Query help: Items which has been ordered last year (same month)


Dear experts,

i need your help in a user query containing this information:

  • DocNum
  • DocDate
  • CardCode
  • CardName
  • ItemCode
  • ItemName
  • Quantity

Docdate has to be the current month, but one year before.

Quantity has to be the sum of all same items ordered in this month.

All is based on sales orders.

I hope, you understand my thoughts ;-)

Thanks for your help!