Hello Experts,
Have anyone tried to generate a query that would display Availability of all items in month view:
Ex: It would be in this format. I created 2 views to accomodate this but still thinking to see if i get this data with a single query or is there any table that i look into and group by months?
*Year ItemCode ItemDesc Instock Jan Committed Jan OnOrder Jan ATP...........................Dec Commited Dec OnOrder Dec ATP*