SQL Queries?

[Former Member]

Hey guys,

I'm new to SAP B1 and have been asked to create a DASHBOARD for display on our monitors around the office, the following information is needed:

1. Display above sales team

1. a.      The current visual
2. b.      Sales Figures
   • Sales £ MTD
   • Sales Target for month £
   • Sales orders picked so far today £
   • No of orders for shipping tomorrow already picked today
   • No of orders for shipping tomorrow yet to be picked today

Is there a way to obtain this easily?

[kothandaraman_nagarajan]

Hi James,

Welcome to SAP B1 forum. Yes, possible to get those report. But as per forum rule, you should not ask multiple questions in single discussion.

Have you tried standard sales analysis report for sales per month?

Thanks