query products sold per vendor

[MarkOenema]

Dear all,

Please can you help me with a query?

I would like to see per vendor which item we sold per month and an average over 6 months, so it will be easier for me to order new stock.

Please advise.

Regards, Mark

[jitin_chawla]

Hi,

Please check if the query provided by @azizelmir  in the below thread link helps you regarding your query:

https://community.sap.com/t5/enterprise-resource-planning-q-a/query-get-item-sold-quantity-for-last-...

Kr,

Jitin

[MarkOenema]

Hi Jitin,

Thanks for your reply.
Indeed it's in that thread, though I can't see the average nor the on-hand to see for how many months we still have stock.

Unfortunately don't the totals match if I compare it in SAP by checking the sales analysis

Please advise.
Regards.