Query sales last month

[Former Member]

Hi there, Can anyone help me creating a Query that tells me what was sold last month!?? The Report should include ItemCode, Describtion, Quantity  and the Price per Unit (OPLN List Name 2) Should be a simple one but couldnt figure out yet... Thanks in advance, Flo

[RahulHanda]

Hi Florian,

Have you already tried connecting VBRK & VBRP tables (basically billing tables - header & item data)? I would suggest you to link these two in SQVI and see the results.

If this resolves your concern

Regards

Rahul