B1 Query for Item Wise sales for monthly

[former_member676350]

Dear Experts,

We are selling items A, B,C & D.

I need statement for this daily wise invoice quantity & Invoice vale for 30 Days like below.Please help me to get this report.

1 2 3 4 5 Total Item Qty Value Qty Value Qty Value Qty Value Qty Value Itemwise Total Qty Itemwise Total Inv Value Item A Item B Item C Item D Datewise total

[marcella_rivi]

hello Vinneth,

Did you try to use the sales report?

Regards,

Marcella

[jagan4]

Hi Vineeth PN,

Refer below link for query reports,

https://blogs.sap.com/2015/07/22/queries-reports-for-sap-b1/

Regards,

Jagankumar